SSRS Report from Constituent Report menu

Thanks Ryan!  Unfortunately still having a problem,  due to my inexperience working on Tessitura.  I've attempted to create an SSRS-URL report,  and definiting it in t_constituent_report,  but all I'm getting is a blank screen. 

Does the report get defined still in the report setup app,  or just specify the url in t_constituent_report 'D Object' column?

Also, on the SSRS report,  how should I be specifying the constituent id parameter?

Thanks...

Hi David,

Did you ever get this working?

I'm trying to get the new v11 'Constituent Profile' (which is SSRS) report to run from the Constituent report menu.

thanks,

Dara

Just wanted to bump this thread.  I would like to add an SSRS report to the Constituent menu.  I know I need to enter a URL in T_CONSTITUENT_REPORT, but I'm not sure how ti construct the URL.  I don't believe it would be the same as the one used to run the report from the Web.  Am I wrong about this?

Thanks!

- Levi

Levi-

We've done this successfully in v11.0.4 using the following format:

<<URL>>?[REPORT_PATH_AND_NAME]&rs:Command=Render&customer_no=<<key>>&UserGroup=<<ug>>&UserId=<<user>> &CompanyName=<<companyname>>

Replace [REPORT_PATH_AND_NAME] with the same path and name as you would use it in the Report Setup application. (don't use brackets!)

I remember there being a rendering issue when we first went to v11, but there was either a hotfix or something in the 11.0.4 upgrade that fixed that.

Hope that helps!

Beth

-----
BETH GILLILAND
UMS Tessitura System Administrator
bethgill@umich.edu
www.ums.org  //  www.umslobby.org

Levi-

We've done this successfully in v11.0.4 using the following format:

<<URL>>?[REPORT_PATH_AND_NAME]&rs:Command=Render&customer_no=<<key>>&UserGroup=<<ug>>&UserId=<<user>> &CompanyName=<<companyname>>

Replace [REPORT_PATH_AND_NAME] with the same path and name as you would use it in the Report Setup application. (don't use brackets!)

I remember there being a rendering issue when we first went to v11, but there was either a hotfix or something in the 11.0.4 upgrade that fixed that.

Hope that helps!

Beth

-----
BETH GILLILAND
UMS Tessitura System Administrator
bethgill@umich.edu
www.ums.org  //  www.umslobby.org

Hi Levi -

And if you really want to generic-ize (is that a word?) Beth's great answer it would look something like...

http://ServerName/ReportServer_InstanceName?/Report+Folder(s)/ReportName&parameter1=value1&parameter2=value2

(plus signs + stand in for spaces if you have any)

ALso, here's a link I've found useful to help with SSRS URLs:

http://msdn.microsoft.com/en-us/library/ms154042.aspx

HTH,

Heather
Seattle Rep 

Thanks, Heather - was hoping to be generic enough, but was too lazy today to go looking, so I just pasted directly from our system table. :)

It is nice to use <<URL>> though at the beginning, instead of the actual server name, as I think it simply references the SSRS_URL entry in T_DEFAULTS. That way if the server moves/changes, you don't have to relink all your reports (hopefully!)

Beth

Thank you both! I'll give it a try on Monday.  There will be some very excited users :)

Hi,

We also have SSRS Reports working in constituent menu in 11.0.4 (It don't work in earlier versions).

Following is a sample entry from our T_CONSTITUENT_REPORT:

<<URL>>?/TessituraCustomReports/ConstituentProfileAbbey&rs:Command=Render&rc:DocMap=false&customer_no=<<key>>&UserGroup=<<ug>>&UserId=<<user>>&CompanyName=<<company>>

cheers, Dara