Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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.

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:45 AM
Points: 7,214, Visits: 6,356
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

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
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