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.

 All Forums
 Development Tools
 Reporting Services Development
 Add user generated dates to filter on

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_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.

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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?
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -