I'm currently using Reporting Services for SQL Server 2005. I have been able to setup, and configure the Report Manager interface, as well as generate reports via the Report Builder. What I have been unable to do is allow the user to dynamically set the date range that my SQL query will use. Can someone suggest / is it even possible wihtout using a custom web interface?
If you are using BI studio to build the report, you need to create two parameters, say StartDate and EndDate. Set the data type for both parameters to DateTime. Then in the data set query, in the where clause, you'll need to do something like DateTimeColumn BETWEEN @.StartDate AND DATEADD(d, 1, @.EndDate). HTH.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment