Post reply

SSRS 2008 - Report Parameter Visibility

  • May 13, 2008 at 1:33 pm

    #187670

    Hi,

    I am working on SQL Server Reporting Services 2008.

    I need solution for keeping visibility of report parameters on selection of other parameter.

    In reports, I have one combo box which contains values like Daily, Weekly, Monthly and Range.

    On selection of Range, I want to display End date parameter in the report.

    Please suggest pointers to achieve desire solution.

    Nitin

  • May 14, 2008 at 8:54 am

    #815272

    you'll either have to use the report viewer control in your own app, or create a custom control to be used to present/collect the date parameters.

  • May 19, 2008 at 10:51 am

    #817310

    That means there is no direct solution available in Reports to show/hide parameters at run time

  • May 20, 2008 at 1:58 am

    #817632

    I'm not sure if I'm missing the point here, but have you considered placing a text box in the report with something along the lines of:

    ="End Date: "& Parameter!EndDate.Value

    If your parameter has multiple values, you can use a JOIN expression. I don't have the syntax to hand, but can dig it out if you wish?

    On most of my reports, I display the parameters chosen using this method (in case of printing).

    Good luck.

  • May 20, 2008 at 2:46 am

    #817643

    Nitin,

    If it is a single valued parameter, you can follow what matthew has suggested.

    If it is a multi valued parameter, use the following code

    ="End Date:"+join(Parameters!EndDate.Value,",")

    Hope the above helps!

  • May 20, 2008 at 4:24 pm

    #818272

    Thank u Matthew and Samata for ur input.

    But I want something which is related to reports parameter.

    Suppose Report has Two Parameters

    1) Start Date 2) End Date

    if I select start date as first date of the month then I dont want to

    show end date

    while for rest of the start dates I want to show End date

    That means it is something like this

    Start date : 1/1/2008 End date : Disable/Hide

    Start date : 2/2/2008 End date : Enable/Show

  • May 21, 2008 at 7:24 am

    #818541

    that's why you'll either have to use the viewer control in your own app, or create a custom control to collect those parameters.

  • May 21, 2008 at 12:06 pm

    #818780

    Ok Thank u!!!:)

  • June 12, 2008 at 6:46 am

    #827797

    Thanks

  • August 11, 2008 at 4:27 am

    #855957

    Hi Nitin,

    I am also new in SSRS and stuck with similar kind of problem.

    Have you find any solution of this problem?

    If Yes please let me know.

  • May 27, 2009 at 11:07 am

    #1000848

    Hi Nithin,

    I am also searching solution for the same scenario if you find

    any solutions please let me know its greatful

    my id :kaladharreddy15@gmail.com

    Thanks in Advance

    Kaladhar

  • June 29, 2011 at 5:12 am

    #1345803

    Hi,

    How we can use a report viewer control , when we are using BIDS to design a report.

    Thanks

  • September 23, 2011 at 12:35 am

    #1385539

    Did you find the solution to it?

Viewing 13 posts - 1 through 12 (of 12 total)

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