Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
2revup
Posting Yak Master
112 Posts |
 Posted - 2013-02-27 : 02:17:32
|
| 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_DateFROM CaseDetails_AllReports where CaseDetails_AllReports.Creation_Date BETWEEN @startDate AND @endDateReally 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-27 : 04:08:55
|
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
2revup
Posting Yak Master
112 Posts |
Posted - 2013-02-27 : 16:34:56
|
| No I don't the query you see is all I have - do I need the date parameters declared in the query above somewhere? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-27 : 23:18:39
|
| so is this query for startdate? if yes, how can it refer to startdate again in parameters?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Add user generated dates to filter on