SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Add user generated dates to filter on
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

2revup
Posting Yak Master

112 Posts

Posted - 02/27/2013 :  02:17:32  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 02/27/2013 :  04:08:55  Show Profile  Reply with Quote
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 - 02/27/2013 :  16:34:56  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 02/27/2013 :  23:18:39  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000