Drill-Down and DataSources

[Hyam]

Hello,

Is there any way that one data source can only be loaded after I click/enter a drill-down page?
Right now I'm facing a performance problem, it takes a while to load all data when I click the drill-down because my data sources are loaded with all my data and only after are filtered on a data band.
I tried using events to set a Variable and use it on my queries to load only the data that I need (in that drill-down), but looks like the data sources are loaded when the report starts rendering the first time.
I'm using Stimulsoft 2015.2

Thanks in advance.

[Alex K.]

Hello,

In this case, you can use the DrillDown parameter in the query of the data source. Please see screenshots and sample report in the attachment.

Capture1.PNG (40.89 KiB) Viewed 2071 times

Capture2.PNG (47.53 KiB) Viewed 2071 times

Capture3.PNG (51.98 KiB) Viewed 2071 times

Thank you.

[Hyam]

I'll try it and report back. Thanks

[Alex K.]

Hello,

Ok.
Let us know if you need any additional help.

Thank you.