Page 1 of 1

Drill-Down and DataSources

Posted: Mon May 23, 2016 4:18 pm
by 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.

Re: Drill-Down and DataSources

Posted: Tue May 24, 2016 6:49 am
by 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
Capture1.PNG (40.89 KiB) Viewed 2072 times
Capture2.PNG
Capture2.PNG (47.53 KiB) Viewed 2072 times
Capture3.PNG
Capture3.PNG (51.98 KiB) Viewed 2072 times
Thank you.

Re: Drill-Down and DataSources

Posted: Mon May 30, 2016 2:34 pm
by Hyam
I'll try it and report back. Thanks :)

Re: Drill-Down and DataSources

Posted: Tue May 31, 2016 6:26 am
by Alex K.
Hello,

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

Thank you.