Page 1 of 1
Report Drilldown Database Queries
Posted: Fri Dec 15, 2023 3:04 pm
by wayne_the_coder
Is there a way to load/refresh an SQL Data Source when displaying a Drilldown page? I have tables with millions of rows so it is not really possible to load Drilldown data when the main report is displayed. I need to be able to load a data source with data when the use clicks a drilldown link passing in a param to filter the data in the SQL.
Re: Report Drilldown Database Queries
Posted: Mon Dec 18, 2023 10:34 pm
by Lech Kulikowski
Hello,
You can use the Drill-Down parameters in the query.
Thank you.
Re: Report Drilldown Database Queries
Posted: Mon Dec 18, 2023 11:11 pm
by wayne_the_coder
Lech Kulikowski wrote: ↑Mon Dec 18, 2023 10:34 pm
Hello,
You can use the Drill-Down parameters in the query.
Thank you.
Will the Data source automatically refresh when the user clicks a Drilldown link?
Wayne
Re: Report Drilldown Database Queries
Posted: Tue Dec 19, 2023 12:35 pm
by Lech Kulikowski
Hello,
Yes.
Thank you.