Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS @StartDate and @EndDate Expand / Collapse
Posted Wednesday, February 22, 2012 7:50 AM


Group: General Forum Members
Last Login: Monday, March 19, 2012 3:00 PM
Points: 19, Visits: 92
I was using the date parameter @StartDate and @EndDate , But SQL was executing from the year 19-- .
But how I can get values only between @StartDate and @EndDate .
*When i hid zero in SSRS in see only date between @StartDate and @EndDate without zero record.
Can anyone the way. Like if it in where clause dates between MM/DD/YYYY and MM/DD/YYY SSRS pick only value on the range.
Let me know your feedback.

Post #1255992
Posted Wednesday, February 22, 2012 8:04 AM



Group: General Forum Members
Last Login: Thursday, December 1, 2016 11:26 AM
Points: 7,502, Visits: 8,651
This question needs more clarification.

How are the parameters being populated?

What about the report? Is it an auto-run or is it printed upon request?

I'm not sure about the rest of your statements because they make no sense to me. How can you tell SSRS to ignore zeros in a date? Are you talking about the query behind the report?

Brandie Tarvin, MCITP Database Administrator

LiveJournal Blog:
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1256007
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse