I have complex reporting requirements that can't be handle in Visual Report Builder. So I'm using SQL query builder where I can achieve what I need.
I want to make it dynamic by passing parameters from my dashboard to my report.
For example I want to extract the sales for a time interval but user can change interval with (To and From) Dates, without the user need to change the SQL querie.
HiUnfortunately it is not possible to dynamically filter SQL reports using time options on dashboard. As needed, all the required filters will have to applied by adjusting the query in SQL report builder.