Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Not sure how to deal with this error

Author  Topic 

helixpoint
Constraint Violating Yak Guru

291 Posts
Posted - 2011-04-12 : 08:22:10
This is the error
An error occurred during rendering of the report.
An error occurred during rendering of the report.
Object reference not set to an instance of an object.


I can run the report in visual studio, but when I try to run it in the report viewer, on the site, I get this error.

It seems to run threw my code and never gives me an error in the code, just on the viewer. Not sure what to look at. Here is my code:

                        NameValueCollection NVC = (NameValueCollection)System.Configuration.ConfigurationManager.GetSection("SecureSettings");
                        viewerParams[0] = new ReportParameter("lettertypeid", LetterControl);
                        viewerParams[1] = new ReportParameter("Batch", "1");
                        ReportViewer1.ServerReport.ReportServerUrl = m_ReportServerUrl;
                        ReportViewer1.ServerReport.ReportPath = string.Format("{0}{1}", m_ReportDir, "LetterControl");
                        ReportViewer1.ServerReport.ReportServerCredentials = new ReportServerCredentials(NVC.Get(0), NVC.Get(1), "");
                        ReportViewer1.ServerReport.SetParameters(viewerParams);
                        ReportViewer1.ServerReport.Refresh();


Dave
Helixpoint Web Development
http://www.helixpoint.com

helixpoint
Constraint Violating Yak Guru

291 Posts
Posted - 2011-04-12 : 09:02:46
Here is my Log

library!ReportServer_0-31!7dc!04/12/2011-08:16:42:: Using folder E:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files.
reportrendering!ReportServer_0-31!7dc!04/12/2011-08:16:45:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: , Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.ReportIntermediateFormat.TextBox.GetTextBoxImpl(OnDemandProcessingContext context)
at Microsoft.ReportingServices.ReportIntermediateFormat.TablixMember.ResetTextBoxImpls(OnDemandProcessingContext context)
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.MemberHierarchy`1.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Tablix.SetNewContextChildren()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegion.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItemCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSectionCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Report.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixCell.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetCellsNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.MemberHierarchy`1.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Tablix.SetNewContextChildren()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegion.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItemCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSectionCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Report.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixCell.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetCellsNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixDynamicMemberInstance.SetInstanceIndex(Int32 index)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.SetTablixMembersInstanceIndex(TablixMemberCollection rowMembers, Int32 level, List`1 instanceState)
at Microsoft.ReportingServices.Rendering.SPBProcessing.PageItemContainer.CreateChildrenFromPaginationState(ReportItemCollection childrenDef, PageContext pageContext, PageItemContainerHelper itemHelper, Boolean isSimple)
at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportBody.CalculatePage(RPLWriter rplWriter, PageItemHelper lastPageInfo, PageContext pageContext, PageItem[] siblings, RepeatWithItem[] repeatWithItems, Double parentTopInPage, Double& parentPageHeight, Interactivity interactivity)
at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportSection.CalculatePage(RPLWriter rplWriter, Int32 page, Int32 totalPages, Int32 regionPageNumber, Int32 regionTotalPages, Boolean firstSectionOnPage, Boolean lastSection, Interactivity interactivity, Double heightToBeUsed, PageItemHelper& lastBodyInfo, Boolean& delayedHeader, Boolean& delayedFooter, Boolean& lastSectionOnPage)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Report.NextPage(RPLWriter rplWriter, ReportSectionHelper& lastPageInfo, Int32 page, Int32 totalPages, Interactivity interactivity, Boolean hasPaginationChunk)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.PaginateReport(Int32 startPage, Int32 endPage)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.UpdateRenderProperties(Hashtable& renderProperties)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.ServerRenderer.UpdateRenderProperties(Hashtable& renderProperties)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension.InternalRender(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition)
--- End of inner exception stack trace ---;
library!ReportServer_0-31!7dc!04/12/2011-08:16:53:: i INFO: Exception UnhandledReportRenderingException dumped to: E:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles flags= ReferencedMemory, AllThreads, SendToWatson
library!ReportServer_0-31!7dc!04/12/2011-08:16:54:: w WARN: Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.ReportIntermediateFormat.TextBox.GetTextBoxImpl(OnDemandProcessingContext context)
at Microsoft.ReportingServices.ReportIntermediateFormat.TablixMember.ResetTextBoxImpls(OnDemandProcessingContext context)
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.MemberHierarchy`1.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Tablix.SetNewContextChildren()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegion.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItemCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSectionCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Report.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixCell.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetCellsNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.MemberHierarchy`1.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Tablix.SetNewContextChildren()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegion.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItemCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSectionCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Report.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixCell.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetCellsNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixDynamicMemberInstance.SetInstanceIndex(Int32 index)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.SetTablixMembersInstanceIndex(TablixMemberCollection rowMembers, Int32 level, List`1 instanceState)
at Microsoft.ReportingServices.Rendering.SPBProcessing.PageItemContainer.CreateChildrenFromPaginationState(ReportItemCollection childrenDef, PageContext pageContext, PageItemContainerHelper itemHelper, Boolean isSimple)
at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportBody.CalculatePage(RPLWriter rplWriter, PageItemHelper lastPageInfo, PageContext pageContext, PageItem[] siblings, RepeatWithItem[] repeatWithItems, Double parentTopInPage, Double& parentPageHeight, Interactivity interactivity)
at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportSection.CalculatePage(RPLWriter rplWriter, Int32 page, Int32 totalPages, Int32 regionPageNumber, Int32 regionTotalPages, Boolean firstSectionOnPage, Boolean lastSection, Interactivity interactivity, Double heightToBeUsed, PageItemHelper& lastBodyInfo, Boolean& delayedHeader, Boolean& delayedFooter, Boolean& lastSectionOnPage)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Report.NextPage(RPLWriter rplWriter, ReportSectionHelper& lastPageInfo, Int32 page, Int32 totalPages, Interactivity interactivity, Boolean hasPaginationChunk)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.PaginateReport(Int32 startPage, Int32 endPage)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.UpdateRenderProperties(Hashtable& renderProperties)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.ServerRenderer.UpdateRenderProperties(Hashtable& renderProperties)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension.InternalRender(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.HandleRenderingException(ReportRenderingException rex)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition)
at Microsoft.ReportingServices.Library.RenderLive.CallProcessingAndRendering(ProcessingContext pc, RenderingContext rc, OnDemandProcessingResult& result)
at Microsoft.ReportingServices.Library.RenderStrategyBase.ExecuteStrategy(OnDemandProcessingResult& processingResult)
webserver!ReportServer_0-31!7dc!04/12/2011-08:16:54:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.ReportIntermediateFormat.TextBox.GetTextBoxImpl(OnDemandProcessingContext context)
at Microsoft.ReportingServices.ReportIntermediateFormat.TablixMember.ResetTextBoxImpls(OnDemandProcessingContext context)
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.MemberHierarchy`1.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Tablix.SetNewContextChildren()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegion.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItemCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSectionCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Report.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixCell.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetCellsNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.MemberHierarchy`1.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Tablix.SetNewContextChildren()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegion.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItemCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportSectionCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.Report.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixCell.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetCellsNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext()
at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext)
at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixDynamicMemberInstance.SetInstanceIndex(Int32 index)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.SetTablixMembersInstanceIndex(TablixMemberCollection rowMembers, Int32 level, List`1 instanceState)
at Microsoft.ReportingServices.Rendering.SPBProcessing.PageItemContainer.CreateChildrenFromPaginationState(ReportItemCollection childrenDef, PageContext pageContext, PageItemContainerHelper itemHelper, Boolean isSimple)
at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportBody.CalculatePage(RPLWriter rplWriter, PageItemHelper lastPageInfo, PageContext pageContext, PageItem[] siblings, RepeatWithItem[] repeatWithItems, Double parentTopInPage, Double& parentPageHeight, Interactivity interactivity)
at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportSection.CalculatePage(RPLWriter rplWriter, Int32 page, Int32 totalPages, Int32 regionPageNumber, Int32 regionTotalPages, Boolean firstSectionOnPage, Boolean lastSection, Interactivity interactivity, Double heightToBeUsed, PageItemHelper& lastBodyInfo, Boolean& delayedHeader, Boolean& delayedFooter, Boolean& lastSectionOnPage)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Report.NextPage(RPLWriter rplWriter, ReportSectionHelper& lastPageInfo, Int32 page, Int32 totalPages, Interactivity interactivity, Boolean hasPaginationChunk)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.PaginateReport(Int32 startPage, Int32 endPage)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.UpdateRenderProperties(Hashtable& renderProperties)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.ServerRenderer.UpdateRenderProperties(Hashtable& renderProperties)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension.InternalRender(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.HandleRenderingException(ReportRenderingException rex)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition)
at Microsoft.ReportingServices.Library.RenderLive.CallProcessingAndRendering(ProcessingContext pc, RenderingContext rc, OnDemandProcessingResult& result)
at Microsoft.ReportingServices.Library.RenderStrategyBase.ExecuteStrategy(OnDemandProcessingResult& processingResult)
at Microsoft.ReportingServices.Library.ReportExecutionBase.InternalExecuteReport()
at Microsoft.ReportingServices.Library.ReportExecutionBase.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.ExecutionDisposerProxy.ExecuteReport()
at Microsoft.ReportingServices.Library.RenderReportAction.PerformExecution()
at Microsoft.ReportingServices.Library.RenderReportAction.Render()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

Dave
Helixpoint Web Development
http://www.helixpoint.com
Go to Top of Page

helixpoint
Constraint Violating Yak Guru

291 Posts
Posted - 2011-04-12 : 09:24:03
Here is the SP

ALTER PROCEDURE [PubWebdbo].[usp_PASORT_Read_LetterControl]
@Batch varchar(150),
@lettertypeid varchar(150),
@addressid varchar(150)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

SELECT dbo.offender.sid,
dbo.offender.firstname,
dbo.offender.middlename,
dbo.offender.lastname,
dbo.offender_type_lkp.offender_type_code AS sotype,
dbo.ncic_offenderstatus.DESCRIPTION AS status,
CONVERT(VARCHAR, dbo.offender.last_verified_date, 101) AS
lastverificationdate,
dbo.offender.offenderid,
dbo.offenderaddress.addressid,
dbo.offenderaddress.TYPE,
lt.letter_type_lkp_id,
CASE
WHEN @Batch = 1
AND @lettertypeid = 5
AND dbo.offenderaddress.TYPE = 'Primary' THEN 'AOJ'
WHEN @Batch = 1
AND @lettertypeid = 6
AND dbo.offenderaddress.TYPE = 'Primary' THEN 'AIJ'
ELSE lt.letter_type
END AS letter_type,
1 AS copynumber,
@lettertypeid AS lettertypeid
FROM dbo.offender
LEFT OUTER JOIN dbo.ncic_offenderstatus
ON dbo.offender.offenderstatus = dbo.ncic_offenderstatus.id
LEFT OUTER JOIN dbo.offender_type_lkp
ON dbo.offender.offender_type_lkp_id =
dbo.offender_type_lkp.offender_type_lkp_id
LEFT OUTER JOIN dbo.offenderaddress
ON dbo.offender.offenderid = dbo.offenderaddress.offenderid
INNER JOIN dbo.letter_type_lkp AS lt
ON lt.letter_type_lkp_id = @lettertypeid
WHERE dbo.offenderaddress.addressid in (SELECT Item
FROM PASORTdbo.SplitQuotedString(@addressid)) AND (dbo.OffenderAddress.IsCurrent = 1)
END

Dave
Helixpoint Web Development
http://www.helixpoint.com
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site