I have several charts that SSRS is generating, I also have a filter that user can interact with all reports, in that when a user is selected from this drop down all charts displayed on the report are altered.
Ideally I'd like to create a date filter that also changes all charts (they all have the same date field, so it should be doable).
Thus far I have tried creating a new data set and then adding the parameters to the other data sets I have, however when ever this is added and I am previewing the report I get an error:
The report parameter 'startDate' has a defaultValue or a VaildValue that depends on the report parameter.
The query I am using to try and filter on is:
SELECT ,CaseDetails_AllReports.Creation_Date FROM CaseDetails_AllReports where CaseDetails_AllReports.Creation_Date BETWEEN @startDate AND @endDate
Really stuck on this one. Any one that can point me to a guide or someone who can help I would be forever grateful.
is this the query you use for getting date values? do you've date parameters already in report called startdate and enddate other than your current parameter?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Add user generated dates to filter on
Posted - 02/27/2013 : 02:17:32
