Designer seems to struggle with large number of datasets

[KC_Reports]

I'm testing the trial version of Stimulsoft.Net and I currently have 190 + datasets loaded as well as over 200 data relations.
When trying to open the designer it takes about 12 - 15 seconds to load and then another few seconds for the dictionary to load, if you try clicking on anything on the designer I get the Not Responding error. Even when double clicking on the Bands it takes about 10 seconds for the dialog box to be displayed

Is there a way to optimise the data?

Thanks
Gail

[Andrew]

Hello,

200 datasets - it is a very large number.
With so many ones data tree is rendered slowly in the dictionary, in which the data sources and their fields are displayed (the TreeView component is slow) and before each operation the Undo/Redo service, which saves a copy of the report, is triggered.

Which version and build of Stimulsoft Reports do you use?
In the last version we have made ​​some optimizations for speed designer.
Also you can send your report for investigation.

As a workaround, please send less datasets to a report.

Thank you.

[KC_Reports]

Hi Andrew

I am using Reports.Net file version 2011.2.1024.0 which I think is the latest build.
The designer is fine with less datasets, but my application will be linking to an financial application when loading up so that all the tables (Datasets) are available to create reports from, rather than having to create the datasets on the fly

I think any real world application would have that many database tables and even more.

I don't need to send the report because it's when you create a new report that the designer seems to struggle with, once it has loaded up then it seems to work fine

Gail

[Andrew]

Hello,

Do I understand you correct that the issue is solved?

Thank you.

[KC_Reports]

Hi Andrew

No the issue is the designer cannot handle loading a large number of datasets at runtime.
It seems to use nearly 100% of CPU, unless you can think of any tips or tricks to optimise the data or the Report Engine?

Thanks
Gail

[Andrew]

Hello,

We couldn't reproduce this bug.
Can you please send us a simple test project, which reproduces the issue?
Perhaps we do not consider something.

Thank you.

[KC_Reports]

Hi Andrew

I'm not sure how I can make 200 dataset test a 'simple test', as I mentioned before if I had ten datasets it seems it seems to work fine.

I also notice this is the Debgging window of my SDK

'A first chance exception of type 'System.Exception' occurred in Stimulsoft.Report.dll'

It doesn't stop my application from compiling though.

Could this cause some issues as well?

Also have noticed another side affect for large datasets, if I put a GroupHeanderBand onto deigner and double click on it, it takes over a minute to load the dialog box..
Databand takes less than a second


Regards
Gail

[Andrew]

Hello,

I'm not sure how I can make 200 dataset test a 'simple test', as I mentioned before if I had ten datasets it seems it seems to work fine.

We tried, for example, the following code:

Code: Select all

 for (int index = 0; index < 200; index++)
{
DataTable dt = new DataTable("MyTable" + index.ToString());
for (int index2 = 0; index2 < 10; index2++)
{
DataColumn dc1 = new DataColumn("Column1_" + index2.ToString(), typeof(string));
dt.Columns.Add(dc1);
DataColumn dc2 = new DataColumn("Column2_" + index2.ToString(), typeof(int));
dt.Columns.Add(dc2);
DataColumn dc3 = new DataColumn("Column3_" + index2.ToString(), typeof(double));
dt.Columns.Add(dc3);
DataColumn dc4 = new DataColumn("Column4_" + index2.ToString(), typeof(bool));
dt.Columns.Add(dc4);
DataColumn dc5 = new DataColumn("Column5_" + index2.ToString(), typeof(string));
dt.Columns.Add(dc5);
}
for (int index2 = 0; index2 < 1000; index2++)
{
dt.Rows.Add(dt.NewRow());
}

DataSet ds = new DataSet();
ds.Tables.Add(dt);
rep.RegData(ds);
}

With these data everything worked fine.
Possibly we did not consider any features of your database.
So we need a report sample.

As a way, send us at least a report sample, in which dictionary there are all 200 data sources used so we can analyze it.

I also notice this is the Debgging window of my SDK
'A first chance exception of type 'System.Exception' occurred in Stimulsoft.Report.dll'
It doesn't stop my application from compiling though.
Could this cause some issues as well?

First chance exception messages most often do not mean there is a problem in the code.
For applications/components which handle exceptions gracefully, first chance exception messages let the developer know that an exceptional situation was encountered and was handled.

Exceptions may cause problems and greatly reduce the speed of work, so without an example it is impossible to determine the specific cause.

Thank you.

[KC_Reports]

Hi Andrew

I have attached the report hope it works

[Andrew]

Hello,

Thanks for the report example.
We have reproduced the problem with GroupHeader and work on its solution.

Thank you.