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