How to pass parameters in SQL Report Builder

[douglasoce4268]

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.

It's possible?

[sonika_veeramne]

Hi

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

[jasonledfo09f5]

This is an old follow up, sorry.  Is it possible to get the values from the filter dashboard where the dates are available?  I am not looking for custom variables but just want to grab the existing date filters from the dashboard view.  How can I do that with a custom SQL report?

[glo11486ad4f3e]

Hi jasonledfo09f5,

Thanks for reaching out to us.

Please give us 2-3 days to reply back to thie query.

[glo11486ad4f3e]

Hi jasonledfo09f5,

SQL reports are mostly built with a date filter logic. Overriding that with dashboard level date filter specified by end user is not allowed.

This is due to the complex logic involved in SQL based reports and issues with re-rendering the dashboard dynamically based on user-defined date filter.