Post reply

SSRS @StartDate and @EndDate

  • February 22, 2012 at 7:50 am

    #257253

    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

  • February 22, 2012 at 8:04 am

    #1450318

    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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply