Post reply

Is there a way to NOT generate a report when all parameters have default values until user clicks "View Report"?

  • June 3, 2008 at 6:35 am

    #207997

    SSRS 2005

    Is there a way to NOT generate a report when all of the parameters have default values until the user clicks the "View Report" button? Right now, if all parameters have a default value (or allow null), the report automatically generates.

    Thanks,

    Wayne

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • June 3, 2008 at 12:45 pm

    #823812

    That is something that always bothered me as well. I asked the same question and could not find a solution to it. Hopefully someone knows of a way around this.

    The reason why this bothered me was because, if the report takes a significant amount of time to generate, it shouldn't automatically generate, because I may want to select differenet parameters (even though I have a default defined).

    TSQL Tutorials

  • June 4, 2008 at 2:43 am

    #824047

    Hi,

    If you dont want to generate report automatically, then you should not select default value. When you define report parameter, you can just select dafault as NULL so that it appears with text - select the value. and dont generate the report.

    If you give the default value then it will run.

    hope this helps.

    regards,

    vijay

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

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