Wealth Engine SSRS Custom Screen

My Development department purchased an one-time data download from Wealth Engine. I have imported the data into an impresario local table and created a local view.  I have added in System table entries to add fields to list manager and output set.  I now created a simple local procedure and created a SSRS report for a custom screen. I need to place it in Tessitura does anyone know how to get an SSRS custom screen into Tessitura.

Parents
  • Hi Joseph, like a InfoMaker custom screen, you can enter a row in TR_CUSTOM_TAB table for your SSRS report. The tricky part is the entry in the “D Object” column. An example from one of our constituent custom screens: “http://tessiperi/ReportServer/Pages/ReportViewer.aspx?%2fTessituraCustomReports%2fGetEticketsByCustomer&rs:Command=Render&customer_no=<<key>>” (without the double quote). “tessiperi” is the name our report server, “TessituraCustomReports” is the Report Server folder where the report is deployed and “GetEticketsByCustomer” is the SSRS report name; other part of the URL is standard. I am assuming you have only one parameter for the customer no.

     

    Hope this helps.

     

    Mo

    National Ballet of Canada

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Joseph Shafranek
    Sent: Thursday, September 06, 2012 1:12 PM
    To: Mohiuddin Faruqe
    Subject: [Tessitura Technical Forum] Wealth Engine SSRS Custom Screen

     

    My Development department purchased an one-time data download from Wealth Engine. I have imported the data into an impresario local table and created a local view.  I have added in System table entries to add fields to list manager and output set.  I now created a simple local procedure and created a SSRS report for a custom screen. I need to place it in Tessitura does anyone know how to get an SSRS custom screen into Tessitura.




    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
  • Hi Joseph, like a InfoMaker custom screen, you can enter a row in TR_CUSTOM_TAB table for your SSRS report. The tricky part is the entry in the “D Object” column. An example from one of our constituent custom screens: “http://tessiperi/ReportServer/Pages/ReportViewer.aspx?%2fTessituraCustomReports%2fGetEticketsByCustomer&rs:Command=Render&customer_no=<<key>>” (without the double quote). “tessiperi” is the name our report server, “TessituraCustomReports” is the Report Server folder where the report is deployed and “GetEticketsByCustomer” is the SSRS report name; other part of the URL is standard. I am assuming you have only one parameter for the customer no.

     

    Hope this helps.

     

    Mo

    National Ballet of Canada

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Joseph Shafranek
    Sent: Thursday, September 06, 2012 1:12 PM
    To: Mohiuddin Faruqe
    Subject: [Tessitura Technical Forum] Wealth Engine SSRS Custom Screen

     

    My Development department purchased an one-time data download from Wealth Engine. I have imported the data into an impresario local table and created a local view.  I have added in System table entries to add fields to list manager and output set.  I now created a simple local procedure and created a SSRS report for a custom screen. I need to place it in Tessitura does anyone know how to get an SSRS custom screen into Tessitura.




    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
No Data