Creating reports and dashboards | Stimulsoft community forum

Hello,

Unfortunately, on the current moment, the report using double DrillDown will not work on the web, because all parameters are applied to the original report that is stored on the server.

Thank you.

OK. Let's remove the first drill down so there is only one. If I use a Data from Datasource to show a total for each sales rep that looks like this
Sales_Rep Total_Sales
--------- ------------
John 425
Sue 550
Bill 500

If the user clicks on a sales rep, I want it to drill down and show the total sales for that sales rep by region. So If I click on John, I want it to show
Sales_Rep Total_Region
--------- ------------
West 225
East 200

How do I configure the filter for the drill-down page? I know I can use a filter on the second DataBand ... but how do I apply the drill down filter to the Data Source? Wont the filter on the DataSource execute faster and not have to process all records?

Thanks

Hello,

Please see the modified report in attachment.

[quote="jay"@bplogix.com]but how do I apply the drill down filter to the Data Source? Wont the filter on the DataSource execute faster and not have to process all records?[/quote]

In this case you use the FilterEngine property of databand component set to "SQL Query"

Thank you.

What does the FilterEngine setting of "SQL Query" do? How does it use a SQL query if my filter is an expression like this:
(string)this["Sales"] == DataSource1.Sales

Does it somehow convert that expression into a SQL statement?

thanks

Hello,

Requests, when the FilterEngine property is enabled, in "SQL Query" are constructed correctly only when you specify a Value in Conditions. If you use the Expression in Condition you can check the expression sintax for query manualy.

Thank you.