Report Widget

Hey friend,

You might need to have RAMP Support point your file path for you. I'm not certain if RAMP clients can adjust this.

- Chris

Thanks.  Ticket Open.

You've set up your TR_ANALYTICS_REPORT table?

www.tessituranetwork.com/.../SSRS Widget.htm

that is where I am wondering the report path.

So support was a bust. they state as it is "custom" they can not help.

from documentation - When a report is rendered in an SSRS widget, two values make up the report path: T_DEFAULTS.SSRS_CUSTOM_PATH + TR_ANALYTICS_REPORT.report_path. This path is passed to the report server (T_DEFAULTS.SSRS_URL) to locate and render the report.
 
So it should be looking at what is in t_defaults + tr_analytics_report

my T_Default for SSRS Custom Path is
    Tessitura_Custom/

report path is as set in Tessitura is

DEV - Dashboard by Fund FIN

so what would I put in the report path for TR_analytics_report table? just DEV - Dashboard by Fund FIN

I have made sure there is a default value per the documentation.

Hi all -

Mary and I took a look at this together and determined that this issue is addressed by a v15.1 service pack release. There was an issue where the Tessitura Web service in the hosting environment was not properly connecting to the REST service, and this has been fixed.

Thanks,

Patrick

Thanks Patrick - Scheduling the service pack release!

Patrick Schley (Past Staff Member) which specific Service Pack is expected to fix this issue?

The problem was addressed in v15.1.5, so any service pack after that would fix the problem. If you are still seeing this after 15.1.5, we're happy to take a closer look in a Support Ticket.

Thanks,

Patrick

OK - next question - Default Value. (in Report Edit Screen or the actual report set

Hi Mary - In the stored procedure.

Chris Wallingford Question RE: If the SPROC is updated with defaults for the parameters, will it still be possible to run the report with a different set of parameters? Especially the optional parameters. For instance, if the default Category is set in the SPROC to Feedback, can that be overridden by the parameters in the application? If so, how?

HI Phillip,

Yes, if I understand... For example, just running or scheduling the report with a different set of parameters in the application?

Chris Wallingford Exactly. We have a version of the CSI Tracking Report that was converted to SSRS and our Guest Services team wants to use it as a widget in Analytics. If I update the related SPROC to have default parameters that will provide them the result set they are interested in receiving in the widget, I wanted to be sure that they could be overridden by someone manually setting a different set of parameters in the application.

I'll do some testing of this to see if we can get it set up to their liking. 

Thanks!