Last post Mar 18, 2013 08:59 AM by mm10
Feb 27, 2013 02:20 AM|2revup|LINK
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:
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.
Background tech: using SQLserver 2008 r2 express
Mar 18, 2013 08:59 AM|mm10|LINK
I may have misunderstood the question here but can't you just add two report parameters for the startdate and the enddate to be used in the filtering?