locked
Default Parameter Values RRS feed

  • Question

  • Hi,

    Is there anyway to have the parameter that has default value enabled when not all parameters have default values?  For example, the report has 2 parameters, both have available values from the query. 

    a. If parameter 2 has default value, and parameter 1 does not, when the report is executed the parameter 2 is disabled (and value is not displayed) until parameter 1 is selected.

    b. If parameter 1 has default value, and parameter 2 does not, when the report is executed the parameter 1 is enabled (and value is displayed).

    I need to have scenario a works as same as scenario b.  Is there anyway? or is that by design?  I know I can move the parameters order but that's not what I want.

    Thanks in advance.

    Ash_
    Thursday, January 21, 2010 1:14 AM

Answers

  • Hi Ash_,

    The behavior you described is by design.

    I would suggest you using ASP.NET to implement custom parameter interface and using Report Viewer to display the report. If using ASP.NET web control to implement the parameter interface, we can control the behavior as we wanted.

    Or, please submit a wish at http://connect.microsoft.com
    Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects.

    Please feel free to ask, if you have any more questions.

    Thanks,
    Jin Chen
    Jin Chen - MSFT
    • Marked as answer by Ash_ Tuesday, January 26, 2010 5:12 PM
    Tuesday, January 26, 2010 9:47 AM

All replies

  • Cascading parameters maybe a workaround for your goal.

    Related links:


    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    Thursday, January 21, 2010 1:52 AM
  • Cascading parameters maybe a workaround for your goal.

    Related links:


    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com

    Thank you for the reply but that's not the problem I'm having.  Sorry if I was not clear in my original post; the parameters I've in question are independent of each other so I expect when I run the report, both parameters should be displayed even one has default and other does not. 

    Not sure if you've noticed this behaviour (or I may did something wrong), scenario A happened if the report is run from MS Visual Studio.  When I deployed to RS server and ran it, it still had same problem but when I change the default parameter (checked Has Default) and enter the Default Value, it worked as scenario B.

    Ash_
    Thursday, January 21, 2010 6:19 PM
  • so I expect when I run the report, both parameters should be displayed even one has default and other does not. 


    That is pretty normal.

    Can you reproduce the erroneous behaviour on a real simple report?

    Are you up-to-date with service packs?

    When you say VS, do you mean BIDS? I always use BIDS (3-way templated version of VS).

    If error persists, you can report at: https://connect.microsoft.com/SQLServer?wa=wsignin1.0


    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    Thursday, January 21, 2010 6:41 PM
  • Hi Ash_,

    The behavior you described is by design.

    I would suggest you using ASP.NET to implement custom parameter interface and using Report Viewer to display the report. If using ASP.NET web control to implement the parameter interface, we can control the behavior as we wanted.

    Or, please submit a wish at http://connect.microsoft.com
    Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects.

    Please feel free to ask, if you have any more questions.

    Thanks,
    Jin Chen
    Jin Chen - MSFT
    • Marked as answer by Ash_ Tuesday, January 26, 2010 5:12 PM
    Tuesday, January 26, 2010 9:47 AM
  • Thank you all for your replies.
    Ash_
    Tuesday, January 26, 2010 5:12 PM
  • I'm finding the same peculiar behavior...

    If this is by design, can you tell me how to avoid thinking like a designer?  I wouldn't want to produce products like this.
    Wednesday, February 17, 2010 6:49 AM