We have SQL 2008. Also when I export to PDF, I see everything just fine. Also, it work good when I just run the RDL in VS 2008, but when I run it threw reporting services, it bombs www.helixpoint.com

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(); 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() 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 www.helixpoint.com

Check this out http://support.microsoft.com/default.aspx?scid=kb;en-us;959595&sd=rss&spid=12913

Hi Helixpoint, Do you mean when preview the report in Business Intelligence Development Studio, it works fine. However, after deployed it to Report Server and view the report in your application through ReportViewer, it gives you error message? If so, could you please also check the report on Report Manager or Report Server directly to see if it works? In addition, please also post the specific version of the Reporting Services and ReportViewer control. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.