Dynamic DataSet Schema

cmcardle75 · Post by **cmcardle75** » Thu Dec 03, 2009 10:41 am

Is it possible using Stimulsoft to design a report where the number, types and names of the columns in the dataset is not known until it is time to render?

I'd want it to divide up the available space between the columns, preferably intelligently (i.e. looking at the sizes of the strings contained and selecting appropriate widths and font sizes).

Christian.

Post by **Edward** » Thu Dec 03, 2009 1:39 pm

Hi

No problem, it is possible to fill the Dictionary with data just before rendering.

Please see the following flash video:

http://www.stimulsoft.com/livedemos/run ... ntime.html

We have implemented a new table component which is intended for this. Just set AutoWidth property of that component and the table width will be adjusted automatically.

Thank you.

cmcardle75 · Post by **cmcardle75** » Fri Dec 04, 2009 3:05 am

I'm not sure you have understood my problem. The flash video shows a table where the names and number of columns are known at design time. I wish to design a report (actually convert an existing report from a different technology). This report produces a table with run-time variable numbers of columns and rows.

So perhaps one run will produce a table with 4 rows and 3 columns. A different report run might produce 3 rows and 8 columns. At design time, the number and names of the columns are not known, so you can't enter them into the column band.

In the designer, I need to be able to say "display all the columns in the data set", rather than dragging individual columns to the bands. The data is generated dynamically and it is not possible to make a separate design for each set of possible columns. There are probably many millions of variations that the query will be producing.

Christian.

Post by **Edward** » Fri Dec 04, 2009 5:04 am

Hi Christian,

In that case you have to build your report in runtime from scratch.

Please see the following project:

Program Files\Stimulsoft Reports.Net 2009.3 Trial\Samples\C#\RuntimeBuildReport\

This project is the part of standard trial installation.

If you still having problems to figure out what you need to do, please feel free to send us a sample project of your task and we will help you to add all columns from the DATASOURCE to the databand in runtime.

Thank you.

cmcardle75 · Post by **cmcardle75** » Fri Dec 04, 2009 5:54 am

OK. What would be nice is some sort of AutoTable feature, though.

Our intention is that end users will be designing the reports using the .WebDesign component. It may be programatically quite difficult to work out which tables are subject to change and how to detect which data bands are using the dynamic tables and to blow away the design within the band.

It would be so much easier if we can just tick a box in the designer and have Stimulsoft do all the hard work! It would literally be a case of setting the DataSource and telling it to do its best job of determining the columns.

Post by **Edward** » Mon Dec 07, 2009 2:20 am

Hi Christian,

No problem, we will prepare an example with a Table component for you.

Thank you.

Post by **Andrew** » Tue Dec 08, 2009 5:32 am

Hello,

We have created an example. Please see the attached archive.

Let us know if you have additional questions.
Thank you.

Naveen Aggarwal · Post by **Naveen Aggarwal** » Sun Feb 28, 2010 8:09 pm

Will it be possible for you to provide the same sample in vb.net?
Thanks in advance!

Post by **Andrew** » Mon Mar 01, 2010 7:31 am

Hello,

Ok! Please see the attached archive.

Thank you.