sailu_tp wrote:
Hi Rogelio
I am interested in knowing more about Xsd generator. Could you please list the steps how should we go about this and what are the major benefits of this.
Thanks,
Sailu
I develop the typedlist's xml schema generator for the following:
- I do not want CR to access the database directly.
- My applications have a business layer that allow me to request and process data. I do all the data calculation in the business layer services, this allow me to switch painless from CR to other report generator. As my applications have a business layer, I want all my data request go throught it.
- I use typedlist because it is easy to design using the LLBLGen Pro designer. Typedlist inherits from datatable, then it can be used as datasource for CR.
- To design the report with CR without being online with the datasource (the push method) you need a schema of the data, that is the reason of the typelist's schema generator.
To use the utility you have to:
- Compile the VB project.
- I added a bat file that you can copy and edit for each LLBLGen Pro project that you want to generate the xml schema (read the readme.txt file that is include qith the zip).
- Create your typedlist using the LLBLGen Pro, generate your code and compile it.
- Use the shortcut to the bat file, the utility should shows the list of typelists that are in your DBSpecificxxx.dll. Pick the name of the one you want the xml schema generated and click save schema. Save the xml in the directory you like.
- Open VS and create or open your CR's report and choose create a new connection then select ADO.Net(XML), open the xml schema (from the directory you saved it) and design your report.
- At run time fill your typedlist, create a new instance of your CR's report and assign the typedlist as datasource of your CR document.
I'll upload it later today 
