Report Drilldown Database Queries

[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.

[Lech Kulikowski]

Hello,

You can use the Drill-Down parameters in the query.

Thank you.

[wayne_the_coder]

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

[Lech Kulikowski]

Hello,

Yes.

Thank you.