Post reply

SSRS - ENABLE/DISABLE PROMPTS/PARAMETERS

  • June 30, 2009 at 10:50 am

    #206114

    SSRS - ENABLE/DISABLE PROMPTS/PARAMETERS

    hI ALL...

    I have a question in SSRS report, that I am designing using BIDS, I am not doing any coding.

    I have to show the Date Selection Prompts either as Calendar Dates or as Year and Month.

    For this I need a initial Promt saying

    Calendar Format ( values 1. Date and 2. Year/Month)

    1. Now If I select Date – then It should show me FROM and TO DATE Prompts

    2. But If I select Year/Month Then It should not diplay From/To prompts, instead should display Year promt and Month prompt.

    I am unable to hide other prompts in this even if I select Date or Year/Month, All four prompts are always visible.

    Please reply

    Thanks in Advance.

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • July 1, 2009 at 4:51 am

    #1018269

    I had same problem but could not resolve this. I dont think there is any way to hide the parameters at run time. There are some limitations of SSRS.

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • July 2, 2009 at 8:25 am

    #1019188

    Hi, I agree with the previous reply, there are limitations on how we can dynamically show/hide parameters on reports in SSRS.

  • July 2, 2009 at 8:35 am

    #1019190

    Surely this thread would be more likely to get a decent response in the BI forum?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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