cancel
Showing results for 
Search instead for 
Did you mean: 

How to pass parameters in SQL Report Builder

How to pass parameters in SQL Report Builder

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?

1 REPLY 1

Re: How to pass parameters in SQL Report Builder

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.