I have tried putting various things in the Qry Append field of Report Set to get the parameters pane to be hidden when an SSRS report is run from Tessitura. (such as &rc:Parameters=Collapsed ) So far I have been unsuccessful.
What am I missing?
Hi David
The easiest way to do this is to hide all the parameters on the report within reporting services. You can then decide which parameters are hidden.
I haven't found the query string works too well when running reports through tessitura.
Hope that helps
Nick
Nicholas Insell Rheolwr Cronfa Ddata Database Manager Canolfan Mileniwm Cymru Wales Millennium Centre
029 2063 4672 www.wmc.org.uk
nodwch rif ffôn NEWYDD y Swyddfa Docynnau please note NEW Ticket Office number 029 2063 6464
Cysylltwch yn Gymraeg neu'n Saesneg fel dymunwch Contact us in English or Welsh as you prefer
Meddyliwch am yr amgylchedd cyn printio / Please consider the environment before printing this email
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Woodall Sent: 23 September 2010 16:42 To: Nick Insell Subject: [Tessitura Technical Forum] SSRS Post Report Parameter Pane
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!
Yes, I could do that. What I'd like is to hide the parameters normally, but have them be available, if possible.
Any ideas?
There is a setting when you setup the parameters in SSRS to select hidden. In the Report menu, report parameters it will list the parameters and the options available to you. Hope that helps.
Thank you and have a great day!
Naomi Williams
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Woodall Sent: Thursday, September 23, 2010 10:57 AM To: Naomi Williams Subject: RE: [Tessitura Technical Forum] SSRS Post Report Parameter Pane
From: Nick Insell <bounce-nicholasinsell2570@tessituranetwork.com> Sent: 9/23/2010 10:49:23 AM
Error! Filename not specified.
Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL
&rc:Parameters=Collapsed works for me. Are you sure there isn't something else wrong with your syntax earlier in the string that's preventing it from even getting to that part? I had that problem a couple weeks ago. Took me forever staring at it, wondering why it wasn't working only to finally realize there was a typo.
Amanda, Is that for a SSRS URL or SSRS POST report? I am using SSRS POST and trying to add the render command in the Query Append field in Report Setup.
I am not explaining myself very well. I understand I can hide the individual parameters, but what I'd like to do is leave them visible (for development and testing) and collapse the parameter pane when the report is rendered in Tessitura.
David, sorry to not have chimed in here sooner.
The Query Append field was added mainly for development purposes. Its purpose was always intended for adding additional Report server commands above and beyond the passing of parameters. What we’ve found is that some commands are ignored when passed from the proxy. We’ve slated to remove this in a later version as it’s never been completely functional. That being said, I am able to get these commands to work on 2008 R2:
rc:Toolbar=False
rc:Parameters=Collapsed
I’ve not checked these in SSRS 2008 R1 or 2005.
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David WoodallSent: Friday, September 24, 2010 11:02 AMTo: Ryan CrepsSubject: Re: [Tessitura Technical Forum] SSRS Post Report Parameter Pane
From: David Woodall <bounce-davidwoodall1530@tessituranetwork.com>Sent: 9/24/2010 9:57:36 AM
Opening up a very old thread...
Is there a way to save the collapsed parameter setting on SSRS Custom Reports, where the only Report Path in Report SetUp is the path to the report in Report Server? I'm not familiar with the Query Append field.
thanks,
frannie