Creating reports and dashboards | Stimulsoft community forum

Hi,

What better way to build a report with high performance (based on a million rows)?
best practices, types, components, datasource, ...

* Using StiWebViewerSL

Hello.

becomex_jle wrote:What better way to build a report with high performance (based on a million rows)?
best practices, types, components, datasource, ...

* Using StiWebViewerSL

We can give you some advises:
- write SQL-query to filter only needed data before getting it in the report generator.
- select only those fields that you use in the report
- less data conversion as possible especially string to number
- create a simple reports with minimum or without grouping, containers and sub-bands

More detailed recommendations can be given after analysing your report and data.

Thank you.

Aleksey wrote:Hello.

becomex_jle wrote:What better way to build a report with high performance (based on a million rows)?
best practices, types, components, datasource, ...

* Using StiWebViewerSL

We can give you some advises:
- write SQL-query to filter only needed data before getting it in the report generator.
- select only those fields that you use in the report
- less data conversion as possible especially string to number
- create a simple reports with minimum or without grouping, containers and sub-bands

More detailed recommendations can be given after analysing your report and data.

Thank you.

ok, thanks.

Hello,

Let us know if you need assistance.

Thank you.

Hello,

I'm trying a simple report with:
- SQL-query
- 6 columns (number, string, data, decimal, decimal and decimal)
- Bands: PageHeaderBand, ReportTitleBand, HeaderDataband and DataBand
- return 100.000 rows with 1493 pages.

Preview Tab: Success
- Generated in 45 seconds.

Preview Silverlight: Error
- Generated 1492 pages in 40 seconds.
- after one minute, occurs erro:



See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Stimulsoft.Base.StiExceptionForm..ctor(Exception exception)
at Stimulsoft.Base.StiExceptionProvider.Show(Exception exception)
at Stimulsoft.Report.Design.Controls.StiDesignerSLPreviewControl.btRefresh_Click(Object sender, EventArgs e)
at Stimulsoft.Report.Design.StiDesignerControl.TabControl_SelectedTabChanged(Object sender, TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabControl.InvokeSelectedTabChanged(TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabControl.tabStrip1_SelectedTabChanged(Object sender, TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.InternalOnMouseDown(MouseEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.OnMouseDown(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Hello.

becomex_jle wrote:I'm trying a simple report with:
- SQL-query
- 6 columns (number, string, data, decimal, decimal and decimal)
- Bands: PageHeaderBand, ReportTitleBand, HeaderDataband and DataBand
- return 100.000 rows with 1493 pages.

Preview Tab: Success
- Generated in 45 seconds.

Preview Silverlight: Error
- Generated 1492 pages in 40 seconds.
- after one minute, occurs error.

Please, send us your report with data to reproduce your issue.

Thank you.

ok.

Hello.

We've reproduced your problem. There are several restrictions and your report is too heavy for Silverlight. Please, decrease the amount of records in a report and split it into several parts.

Thank you.

Hello.

I can't split because it's cash flow report. (in some cases contains +- 1,000,000.00 rows).

Have you any other suggestions?

Thanks

Hello.

becomex_jle wrote:I can't split because it's cash flow report. (in some cases contains +- 1,000,000.00 rows).
Have you any other suggestions?

It's too much data for web-report. We'll try to do something after release but don't promise anything.

Thank you.