• Replies 3 replies
  • Subscribers 336 subscribers
  • Views 172 views
  • Users 0 members are here
Related

Customizing a SSRS report

Joel Freiberg
$organization

I am adding some fields to the Campaign Giving Comparison report from Tessitura.  My updated RDL and Stored Procedure run just fine in Visual Studio BI but when I try to run the report I have customized I get the error below in the Tessitura client. 

Get the same error for any Tessitura SSRS report that I customize but the Element custom SSRS reports are working just fine.

 

--------------

Exception of type 'System.Web.HttpUnhandledException' was thrown.
There was an error processing this request. Please check the details below.
Object reference not set to an instance of an object.
 
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.reports_viewreport_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\live_tessituraweb\0c055225\2f2112d1\App_Web_o12zgeoi.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 Tessitura.Web.Reports.ViewReport.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

-------------------------

Anyone know what I am missing?

Thanks
Joel

Parents
  • $organization

    That was the one I forgot.

     

    Thanks Ryan.

     

    Joel Freiberg

    Ticket Office Manager

    Performing Arts Foundation

    jfreiberg@grandtheater.org

    715-842-0988 x226

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Huber
    Sent: Wednesday, March 23, 2016 11:24 AM
    To: Joel Freiberg
    Subject: Re: [Tessitura Technical Forum] Customizing a SSRS report

     

    You should also check that all parameters have a value in the SSRS Name field in report setup.

    Cheers!

    Ryan

    From: Joel Freiberg <bounce-joelfreiberg7373@tessituranetwork.com>
    Sent: 3/21/2016 2:50:06 PM

    I am adding some fields to the Campaign Giving Comparison report from Tessitura.  My updated RDL and Stored Procedure run just fine in Visual Studio BI but when I try to run the report I have customized I get the error below in the Tessitura client. 

    Get the same error for any Tessitura SSRS report that I customize but the Element custom SSRS reports are working just fine.

     

    --------------

    Exception of type 'System.Web.HttpUnhandledException' was thrown.
    There was an error processing this request. Please check the details below.
    Object reference not set to an instance of an object.

     

    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.reports_viewreport_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\live_tessituraweb\0c055225\2f2112d1\App_Web_o12zgeoi.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 Tessitura.Web.Reports.ViewReport.Page_Load(Object sender, EventArgs e)
    at System.Web.UI.Control.OnLoad(EventArgs e)
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


    -------------------------

     

    Anyone know what I am missing?

     

    Thanks

    Joel

     




    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
  • $organization

    That was the one I forgot.

     

    Thanks Ryan.

     

    Joel Freiberg

    Ticket Office Manager

    Performing Arts Foundation

    jfreiberg@grandtheater.org

    715-842-0988 x226

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Huber
    Sent: Wednesday, March 23, 2016 11:24 AM
    To: Joel Freiberg
    Subject: Re: [Tessitura Technical Forum] Customizing a SSRS report

     

    You should also check that all parameters have a value in the SSRS Name field in report setup.

    Cheers!

    Ryan

    From: Joel Freiberg <bounce-joelfreiberg7373@tessituranetwork.com>
    Sent: 3/21/2016 2:50:06 PM

    I am adding some fields to the Campaign Giving Comparison report from Tessitura.  My updated RDL and Stored Procedure run just fine in Visual Studio BI but when I try to run the report I have customized I get the error below in the Tessitura client. 

    Get the same error for any Tessitura SSRS report that I customize but the Element custom SSRS reports are working just fine.

     

    --------------

    Exception of type 'System.Web.HttpUnhandledException' was thrown.
    There was an error processing this request. Please check the details below.
    Object reference not set to an instance of an object.

     

    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.reports_viewreport_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\live_tessituraweb\0c055225\2f2112d1\App_Web_o12zgeoi.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 Tessitura.Web.Reports.ViewReport.Page_Load(Object sender, EventArgs e)
    at System.Web.UI.Control.OnLoad(EventArgs e)
    at System.Web.UI.Control.LoadRecursive()
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


    -------------------------

     

    Anyone know what I am missing?

     

    Thanks

    Joel

     




    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