• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 51 views
  • Users 0 members are here
Related

Collapse parameters on SSRS Custom reports

Frances O'Connell
$organization

Hi there,

I'm trying to hide parameters from end users on SSRS Custom reports in the client. I know I can set the parameter to be hidden in the SSRS template in Visual Studio. But ideally, I'd have it render with parameters collapsed, but still allow the parameter pane to pull down, for those more savvy users who understand they can change parameters without rerunning...  I think I could have done this with an SSRS URL report  by adding &rc:Parameters=Collapsed to the URL, but I"m not sure what my options are for SSRS Custom reports. 

Anyone?

Thanks,

frannie

Parents
  • Former Member
    Former Member $organization

    Matt

     

    I think Frances was asking about showing and hiding the report parameters dynamically at run time, not row groups.

     

    Frances

     

    I’m not sure there is an easy way to do that, but I think that as a quick workaround you can have two versions of the report, one with the parameters hidden and the other one with parameters visible. Then make an element of the report with the hidden parameters (e.g. the report title) a link to call the other report with the same parameters’ values. You would set up Tessitura to run the hidden parameters version, and instruct the users to click on the report title to get access to modify the parameters. Haven’t tried doing it, but I think it might work.

     

    Fernando Margueirat
    Business Analyst
    The National Ballet of Canada
    470 Queens Quay West
    Toronto, Ontario
    M5V 3K4
    P: 416 345 9686 x453
    F: 416 345 8323

    http://ballet.ca

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hoyt
    Sent: Thursday, April 23, 2015 10:48 AM
    To: Fernando Margueirat
    Subject: Re: [Tessitura Technical Forum] Collapse parameters on SSRS Custom reports

     

    Hi Frannie,

    I think the ToggleItem property of a row group is what you are looking for.

    You can see it in action in ReportParameters.rdl, which can be found in solution 32 of the  Version Upgrades and Patches workspace in TASK. Download the TessituraSampleLibrary_v11.zip file and go from there. That's the most recent version I know of.

    Hope that helps!

    Matt

    From: Frances O'Connell <bounce-francesoconnell1133@tessituranetwork.com>
    Sent: 4/17/2015 2:47:40 PM

    Hi there,

    I'm trying to hide parameters from end users on SSRS Custom reports in the client. I know I can set the parameter to be hidden in the SSRS template in Visual Studio. But ideally, I'd have it render with parameters collapsed, but still allow the parameter pane to pull down, for those more savvy users who understand they can change parameters without rerunning...  I think I could have done this with an SSRS URL report  by adding &rc:Parameters=Collapsed to the URL, but I"m not sure what my options are for SSRS Custom reports. 

    Anyone?

    Thanks,

    frannie




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Former Member
    Former Member $organization

    Matt

     

    I think Frances was asking about showing and hiding the report parameters dynamically at run time, not row groups.

     

    Frances

     

    I’m not sure there is an easy way to do that, but I think that as a quick workaround you can have two versions of the report, one with the parameters hidden and the other one with parameters visible. Then make an element of the report with the hidden parameters (e.g. the report title) a link to call the other report with the same parameters’ values. You would set up Tessitura to run the hidden parameters version, and instruct the users to click on the report title to get access to modify the parameters. Haven’t tried doing it, but I think it might work.

     

    Fernando Margueirat
    Business Analyst
    The National Ballet of Canada
    470 Queens Quay West
    Toronto, Ontario
    M5V 3K4
    P: 416 345 9686 x453
    F: 416 345 8323

    http://ballet.ca

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hoyt
    Sent: Thursday, April 23, 2015 10:48 AM
    To: Fernando Margueirat
    Subject: Re: [Tessitura Technical Forum] Collapse parameters on SSRS Custom reports

     

    Hi Frannie,

    I think the ToggleItem property of a row group is what you are looking for.

    You can see it in action in ReportParameters.rdl, which can be found in solution 32 of the  Version Upgrades and Patches workspace in TASK. Download the TessituraSampleLibrary_v11.zip file and go from there. That's the most recent version I know of.

    Hope that helps!

    Matt

    From: Frances O'Connell <bounce-francesoconnell1133@tessituranetwork.com>
    Sent: 4/17/2015 2:47:40 PM

    Hi there,

    I'm trying to hide parameters from end users on SSRS Custom reports in the client. I know I can set the parameter to be hidden in the SSRS template in Visual Studio. But ideally, I'd have it render with parameters collapsed, but still allow the parameter pane to pull down, for those more savvy users who understand they can change parameters without rerunning...  I think I could have done this with an SSRS URL report  by adding &rc:Parameters=Collapsed to the URL, but I"m not sure what my options are for SSRS Custom reports. 

    Anyone?

    Thanks,

    frannie




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children