• Replies 7 replies
  • Subscribers 338 subscribers
  • Views 68 views
  • Users 0 members are here
Related

New TCast! Tessitura and SSRS Setup

Ryan Creps (Past Staff Member)
$organization

In case some of you may have missed this on our landing page:

We're pleased to announce a new T-Cast covering the setup and integration of SQL Server 2008 Reporting Services and Tessitura. Our fearless presenter Roger Boltz helps you navigate the turns and twists of setting up the Tessitura SSRS integration components (Tessitura SSRS Proxy, and the Tessitura SQL Services assemblies) along with proper configuration of a project and the Reporting Services Report Template (available for download with the T-Cast) in the Reports menu. SSRS 2008 is one key component to preparing for Tessitura Version 11, and Roger walks you through every step.  Link below!

http://www.tessituranetwork.com/en/network/Learning/Webinars%20Archive/IT/SSRS%20Basic%20Setup%20T-Cast.aspx



[edited by: Ryan Creps at 10:55 PM (GMT -6) on 4 May 2011]
Parents
  • $organization

    In case you were looking for a link in the original post, I botched it!  Copy/paste with link embedded in the RichText doesn't play well.

    Here it is:

    http://www.tessituranetwork.com/en/network/Learning/Webinars%20Archive/IT/SSRS%20Basic%20Setup%20T-Cast.aspx

     

  • $organization in reply to Ryan Creps (Past Staff Member)

    Hello, all.  I need to pop in here for a quick update on this TCast.  If anyone has downloaded the SSRSReportTemplate and is running SQL Server 2008 R1 (not R2), you will have issues adding the template to a report server project in Visual Studio (BIDS). 

    The template has been updated today with a version compatible with SQL Server 2008 R1, which can be upgraded to R2.  I recommend re-downloading it here:

    http://www.tessituranetwork.com/network/~/link.aspx?_id=572212D5F42344639BA6FF8D1F8AD923&_z=z

    This is because the original template was provided in an SSRS 2008 R2 format.  Reports saved in SQL Server 2008 R2 use a different schema than R1.  More about this here if you are lucky enough to have to work in both R1 and R2 SQL versions concurrently:

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

    Please let us know if you have any questions!

    Ryan

  • $organization in reply to Ryan Creps (Past Staff Member)
    Hi Ryan! Is the "Tessitura and SSRS Setup" T-Cast no longer available? I can find the second one in the series (Bulding a Tessitura-integrated SSRS Report) but can't seem to find the first one and the link above isn't working out for me. I need to learn how to build new reports and would like to start at the beginning so I don't miss anything important. :)
  • $organization in reply to Beth Hawryluk

    Hello, Beth!  Glad to see someone is looking for this TCast.  We are actively creating a brand new series of TCasts for SSRS and V11 as I write!  We've removed the old TCast as it is mostly obsolete information pertaining to v10.  V11 brings a brand new SSRS/Tessitura infrastructure and there are a few new best practices and techniques for custom report creation.  Old reports continue to work as expected, but these new TCasts are intended to show the new WebReports application and focus on the new features while creating reports.   There are also a number of older techniques (like defining User Group or Request Id in Report Setup) that are no longer necessary.

    Look for this in the coming weeks along with some revamped custom report documentation.

    -Ryan

  • $organization in reply to Ryan Creps (Past Staff Member)

    Ryan, we upgraded TEST to version 11 and we are having issues with SSRS reports access - getting an error ... Where can I find some helpful information?

    Thanks,Sabina

    Exception of type 'System.Web.HttpUnhandledException' was thrown.
    The request failed with the error message: --

    Object moved to here.

    --.

    at System.Web.UI.Page.HandleError(Exception e)
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    at System.Web.UI.Page.ProcessRequest()
    at System.Web.UI.Page.ProcessRequest(HttpContext context)
    at ASP.report_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\webreports\b725b294\89fbf603\App_Web_dxvpu5in.0.cs:line 0
    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Inner Exception

    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.ReportExecutionService.LoadReport2(String Report, String HistoryID)
    at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.<>c__DisplayClass2.b__0()
    at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
    at Microsoft.Reporting.WebForms.ServerReport.EnsureExecutionSession()
    at Microsoft.Reporting.WebForms.ServerReport.GetParameters()
    at Tessitura.WebReports.Controls.ViewReport.PopulateReportParameters()
    at Tessitura.WebReports.Controls.ViewReport.SetupReportViewer()
    at Tessitura.WebReports.Controls.ViewReport.DisplayReport()
    at Tessitura.WebReports.Controls.ViewReport.Page_Load(Object sender, EventArgs e)
    at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

     

Reply
  • $organization in reply to Ryan Creps (Past Staff Member)

    Ryan, we upgraded TEST to version 11 and we are having issues with SSRS reports access - getting an error ... Where can I find some helpful information?

    Thanks,Sabina

    Exception of type 'System.Web.HttpUnhandledException' was thrown.
    The request failed with the error message: --

    Object moved to here.

    --.

    at System.Web.UI.Page.HandleError(Exception e)
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    at System.Web.UI.Page.ProcessRequest()
    at System.Web.UI.Page.ProcessRequest(HttpContext context)
    at ASP.report_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\webreports\b725b294\89fbf603\App_Web_dxvpu5in.0.cs:line 0
    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Inner Exception

    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.ReportExecutionService.LoadReport2(String Report, String HistoryID)
    at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.<>c__DisplayClass2.b__0()
    at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
    at Microsoft.Reporting.WebForms.ServerReport.EnsureExecutionSession()
    at Microsoft.Reporting.WebForms.ServerReport.GetParameters()
    at Tessitura.WebReports.Controls.ViewReport.PopulateReportParameters()
    at Tessitura.WebReports.Controls.ViewReport.SetupReportViewer()
    at Tessitura.WebReports.Controls.ViewReport.DisplayReport()
    at Tessitura.WebReports.Controls.ViewReport.Page_Load(Object sender, EventArgs e)
    at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

     

Children
No Data