Thursday, March 29, 2012
Error Rendering trough Web Service to WebArchivo format
We are using the Reporting Services Web Service, in order to expose some
reports in our Web Application, right now I am trying to enable exporting the
report to the available formats in Reporting Services, and altough everything
seems to be working fine, when I try to render as Web Archive, I get the
following exception:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> The parameter is incorrect.
first I tough it was because of the device info configuration I was using,
since it was the same of the html format (which had things like turning off
the toolbar), thus I instead didnt pass any deviceinfo(null), in both cases
it works fine in all formats but it doesnt in Web Archive.
I have been searching for info about the error, but I havent found any ...
if anyone knows what is happening, I will be thankfull :) ... in the mean
time, I will keep trying, and if I find anything I will post it here.I have continued digging on the problem, I havent found anything on the
internet, and I have cleared out some things about the problem ...
so, here are some aditional info about the problem:
- it isnt only happening when I try to render the report trough the Web
Service, it also happens when I use url access.
- it is happening specifically in this report, there are other reports that
works well
- I am not using any totals/subtotals formulas (I say this, since I have
read this might cause trouble in certain rendering extensions)
- I just found something else (I have 3 reports):
- the report that is working doesnt receive any parameter
- the 2 reports that doesnt work receive 1 parameter, and additionaly have
a list of valid values ...
it looks like it were a bug, something along the lines that rendering
extension either ignores the parameters, or gets confused where there is a
list of valid values ...
Any help will be greatly appreciated ... in the mean time, I will be playing
with the reports definition, in order to find what is exactly happening, if I
dont find a solution soon I will restrict that rendering extension from being
used :(:(:( ...|||I am done with this, I am pretty certain is a bug, just not the type of bug I
tough ...
it is really weird, I played with the parameter options in the report and
the error kept happening, then I decided playing with the report design ...
well, whenever I put a third column in my report, the error happens when I
try to export it to web archive ... I put all types of definition in the
third column, to see if I managed to see anything making it fail, but didnt
arrive to anything, I tried from the simplest one (static text + no
formatting) all trough a "complex" one (formatting + dinamic text ...)
Error rendering to PDF, after installing SP1
error from IE:
"Internet Explorer cannot download Format=PDF from myserver.
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or cannot be found. Please try again later."
Before installing SP1 there were no problems rendering to PDF. Export to
EXCEL and other formats works just fine.
The installation is configured like this:
WEBSERVER:
Windows Sever 2003
Reporting Services Standard Edition + SP1 (Microsoft SQL Server Reporting
Services Version 8.00.878.00)
DBSERVER:
Windows Sever 2003
SQL Server 2000 SP3
The ReportServer, MSSQLSERVER services uses the same Domain account.
I've also seen this problem posted on
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/710/Error-rendering-to-PDF-after-installing-SP1
However there is no solution posted.
Any suggestions on how to resolve this problem would be appreciated
Regards,After hours of testing, i found <Language>no</Language> in the <Style> tag in
one of my textbox... I removed the whole tag and everything works fine. You
need the whole language kode us-en, nb-no etc. search for language in your
xml code
"Jögren Wendel" wrote:
> After installing SP1, reports fails to render to PDF, with the following
> error from IE:
> "Internet Explorer cannot download Format=PDF from myserver.
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or cannot be found. Please try again later."
> Before installing SP1 there were no problems rendering to PDF. Export to
> EXCEL and other formats works just fine.
> The installation is configured like this:
> WEBSERVER:
> Windows Sever 2003
> Reporting Services Standard Edition + SP1 (Microsoft SQL Server Reporting
> Services Version 8.00.878.00)
> DBSERVER:
> Windows Sever 2003
> SQL Server 2000 SP3
> The ReportServer, MSSQLSERVER services uses the same Domain account.
> I've also seen this problem posted on
> http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/710/Error-rendering-to-PDF-after-installing-SP1
> However there is no solution posted.
> Any suggestions on how to resolve this problem would be appreciated
> Regards,
>
Error rendering to PDF, after installing SP1
error from IE:
"Internet Explorer cannot download Format=PDF from myserver.
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or canot be found. Please try again later."
This happened for this specific report only, 10 others rendered to PDF just
as they did before. The mentioned report renders well in all other formats,
including HTML and Excel. And it renders fine on another Reporting Services
server (without SP1).
SQL server has SP3a. Servers do not have _ in their names.
Regards,
Marko PrsicCan you send your rdl and the .rdl.data file for us to investigate?
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marko Prsic" <marko.prsic...kset.org> wrote in message
news:eSwk7U1YEHA.1000@.TK2MSFTNGP12.phx.gbl...
> After installing SP1, a report failed to render to PDF, with the following
> error from IE:
> "Internet Explorer cannot download Format=PDF from myserver.
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or canot be found. Please try again later."
>
> This happened for this specific report only, 10 others rendered to PDF
just
> as they did before. The mentioned report renders well in all other
formats,
> including HTML and Excel. And it renders fine on another Reporting
Services
> server (without SP1).
> SQL server has SP3a. Servers do not have _ in their names.
> Regards,
> Marko Prsic
>
Error Rendering to Excel
following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Onlinehilfe
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Object reference not set to an instance of an object.
Rendering to any other format works fine.
What I found out:
The error happens only, if in the report header or footer is a textbox with
any expression e.g. Globals!PageNumber. If I remove all expressions,
rendering to excel works fine.
But I need this expressions !
Any solution or workaround available ?
Robert WeissWhat type of expression are you using in the Report Header or Footer?
I can't be data from a datasource.
Yosh
"rweiss" <rweiss@.discussions.microsoft.com> wrote in message
news:80FD9EC9-F2DD-46A3-8396-A4787E005977@.microsoft.com...
> Rendering a report to Excel (using Viewer-Export or SOPA-API), I get the
> following error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Onlinehilfe
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Object reference not set to an instance of an object.
> Rendering to any other format works fine.
> What I found out:
> The error happens only, if in the report header or footer is a textbox
> with
> any expression e.g. Globals!PageNumber. If I remove all expressions,
> rendering to excel works fine.
> But I need this expressions !
> Any solution or workaround available ?
> Robert Weiss|||Any expression, for example Globals!PageNumber will do.
In my original report I had a lot of expressions referencing Code and
Parameters, but not the datasource.
I removed everything, now there is only header and footer with some
textboxes left.
As soon as there is any expression other than a literal in one of the
textboxes, the rendering exception occurs.
It's strange, because in other reports there is no problem with expressions
like Globals!PageNumber and rendering to excel.
Robert
"Yoshi" wrote:
> What type of expression are you using in the Report Header or Footer?
> I can't be data from a datasource.
> Yosh
>
> "rweiss" <rweiss@.discussions.microsoft.com> wrote in message
> news:80FD9EC9-F2DD-46A3-8396-A4787E005977@.microsoft.com...
> > Rendering a report to Excel (using Viewer-Export or SOPA-API), I get the
> > following error:
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Onlinehilfe
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > Object reference not set to an instance of an object.
> >
> > Rendering to any other format works fine.
> >
> > What I found out:
> > The error happens only, if in the report header or footer is a textbox
> > with
> > any expression e.g. Globals!PageNumber. If I remove all expressions,
> > rendering to excel works fine.
> >
> > But I need this expressions !
> >
> > Any solution or workaround available ?
> >
> > Robert Weiss
>
>
Error rendering sub-reports
I have a report (ReportA) that is a matrix showing monthly figures for 1 of 20 different items (think of monthly sales figures for 20 different products). In order to obtain a report for all 20 items, it is necessary to generate this report 20 times. To ease generating the reports, I created a new report(ReportB) that has a simple table displaying the recordset of all 20 items. The single cell of the report contains a subreport object tied to ReportA. Each record is passed to the subreport as the parameter of the subreport. The table is grouped by the items and a page break is inserted at the end of each group. This allows for each subreport to appear on its own page.
This all works fine in Report Designer and generates a single report with the matrix repeated once for each of the 20 items. However, when the report is run in Report Manager, problems arise. Although the report appears to render fine on page one, I can't get to page 2. Paging to the next page results in the following error message: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. Object reference not set to an instance of an object.
Oddly enough, exporting to a PDF works just fine.
I need help!!!
What version of RS are you using on the report server?
When you try to render the second page in report manager and it fails, there should be a callstack in the report server logfile. Can you please post that callstack?
-- Robert
|||Using RS2000 SP2
Call stack follows:
aspnet_wp!library!bbc!12/15/2005-09:29:14:: i INFO: Call to GetPermissions:/
aspnet_wp!library!bbc!12/15/2005-09:29:14:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!b54!12/15/2005-09:29:16:: i INFO: Call to GetPermissions:/FISReports
aspnet_wp!library!b54!12/15/2005-09:29:16:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!bbc!12/15/2005-09:29:18:: i INFO: Call to GetPermissions:/FISReports/AllSystemMetrics
aspnet_wp!library!bbc!12/15/2005-09:29:18:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!bbc!12/15/2005-09:29:19:: i INFO: Call to RenderFirst( '/FISReports/AllSystemMetrics' )
aspnet_wp!runningjobs!b78!12/15/2005-09:29:51:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!library!bbc!12/15/2005-09:32:12:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!bbc!12/15/2005-09:32:12:: i INFO: Processed report. Report='/FISReports/AllSystemMetrics', Stream=''
aspnet_wp!library!bbc!12/15/2005-09:33:09:: i INFO: Call to RenderNext( '/FISReports/AllSystemMetrics' )
aspnet_wp!reportrendering!bbc!12/15/2005-09:33:10:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown., ;
Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. > Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.UpdateMatrixMemberHeight(MatrixMember member)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderMatrixMember(MatrixMember matrixMember, Int32 colSpan, Int32 rowSpan, String docMapId, Boolean inDocMap, Int32 borderContext, Boolean updateSize)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderNonSplitMatrixLevel(Matrix matrix, MatrixMember currMember, Boolean& newRow, Boolean partialItem, Int32 level, IntList hiddenColumns, SizeCollection cellHeights, Boolean changableRows, Int32 borderContext, Boolean dirLefRight)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderNonSplitMatrix(Matrix matrix, MatrixMember member, Boolean& newRow, Boolean partialItem, Int32 level, IntList hiddenColumns, SizeCollection cellHeights, Boolean changableRows, Int32 borderContext, Boolean dirLefRight)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderNonSplitMatrixLevel(Matrix matrix, MatrixMember currMember, Boolean& newRow, Boolean partialItem, Int32 level, IntList hiddenColumns, SizeCollection cellHeights, Boolean changableRows, Int32 borderContext, Boolean dirLefRight)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderNonSplitMatrix(Matrix matrix, MatrixMember member, Boolean& newRow, Boolean partialItem, Int32 level, IntList hiddenColumns, SizeCollection cellHeights, Boolean changableRows, Int32 borderContext, Boolean dirLefRight)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderNonSplitMatrixLevel(Matrix matrix, MatrixMember currMember, Boolean& newRow, Boolean partialItem, Int32 level, IntList hiddenColumns, SizeCollection cellHeights, Boolean changableRows, Int32 borderContext, Boolean dirLefRight)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderNonSplitMatrix(Matrix matrix, MatrixMember member, Boolean& newRow, Boolean partialItem, Int32 level, IntList hiddenColumns, SizeCollection cellHeights, Boolean changableRows, Int32 borderContext, Boolean dirLefRight)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderMatrixContent(Matrix matrix, Boolean partialItem, Int32 borderContext, Boolean dirLefRight, Boolean expandLayout)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderMatrix(Matrix matrix, Boolean partialItem, Int32& borderContext, Boolean renderId)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderReportItem(ReportItem reportItem, Int32 borderContext, Boolean renderId)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderCellItems(ReportItemCollection repItemCol, Hashtable partialItems, Hashtable expandItems, PageTableCell currCell, Int32 borderContext, Int32 linkToChild, Boolean layoutExpand)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GenerateTableLayoutContent(PageTableLayout rgTableGrid, Hashtable partialItems, ReportItemCollection repItemCol, Boolean bfZeroRowReq, Boolean bfZeroColReq, String docMapId, Boolean inDocMap, Boolean renderHeight, Int32 borderContext, Int32 linkToChild, Boolean layoutExpand)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GenerateHTMLTable(ReportItemCollection repItemCol, Double dxParent, Double dyParent, PageData pageData, String docMapId, Boolean inDocMap, Int32 borderContext, Int32 linkToChild, Boolean expandLayout)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderSubReport(SubReport subReport, PageData pageData, Int32& borderContext, Boolean renderId)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderReportItem(ReportItem reportItem, Int32 borderContext, Boolean renderId)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderHTMLTableRowCell(TableCell lastCell, Int32 lastColSpan, Boolean firstVisibleCell, Boolean lastVisibleCell, TableContext tableContext)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderHTMLTableRow(TableRow tableRow, String docMapId, Boolean inDocMap, TableColumnCollection columns, TableContext tableContext)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderTableRow(TableRow tableRow, TableAction tableAction, String docMapId, Boolean inDocMap, TableColumnCollection columns, TableContext tableContext)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderTableRowColl(TableRowCollection tableRowColl, TableAction action, String docMapId, Boolean inDocMap, TableColumnCollection columns, TableContext tableContext)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderTableGroup(TableGroup tableGroup, TableAction action, Int32& totalRows, TableColumnCollection columns, TableContext tableContext)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderPartialTable(Table table, Int32 startPage, Int32 endPage, TableAction action, Int32& totalRows, TableContext tableContext)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderTableContent(Table table, Int32 startPage, Int32 endPage, Int32 tableBorderContext)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderTable(Table table, Int32 startPage, Int32 endPage, Int32& borderContext, Boolean renderId)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderPartialItem(ReportItem repItem, PageData pageData, Int32 startPage, Int32 endPage, Int32 borderContext, Boolean isLinkToChild)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderCellItems(ReportItemCollection repItemCol, Hashtable partialItems, Hashtable expandItems, PageTableCell currCell, Int32 borderContext, Int32 linkToChild, Boolean layoutExpand)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GenerateTableLayoutContent(PageTableLayout rgTableGrid, Hashtable partialItems, ReportItemCollection repItemCol, Boolean bfZeroRowReq, Boolean bfZeroColReq, String docMapId, Boolean inDocMap, Boolean renderHeight, Int32 borderContext, Int32 linkToChild, Boolean layoutExpand)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.GenerateHTMLTable(ReportItemCollection repItemCol, Double dxParent, Double dyParent, PageData pageData, String docMapId, Boolean inDocMap, Int32 borderContext, Int32 linkToChild, Boolean expandLayout)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.HTML4Renderer.RenderRectangle(Rectangle rectangle, PageData pageData, Int32& borderContext, Boolean renderId)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderPartialItem(ReportItem repItem, PageData pageData, Int32 startPage, Int32 endPage, Int32 borderContext, Boolean isLinkToChild)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderPage(Int32 index)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderPages()
at Microsoft.ReportingServices.Rendering.HtmlRenderer.BaseRenderer.RenderBody(HtmlTextWriter htmlTextWriter)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerReportArea.RenderBody(HtmlTextWriter outputWriter)
at Microsoft.ReportingServices.WebServer.ContainerControl.RenderBody(HtmlTextWriter outputWriter)
at Microsoft.ReportingServices.WebServer.HTMLViewerPage.Render(HtmlTextWriter outputWriter)
at Microsoft.ReportingServices.WebServer.HtmlArea.Render(HtmlTextWriter outputWriter)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.ViewerReportArea.Render(HtmlTextWriter outputWriter)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension.InternalRender(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
End of inner exception stack trace
at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
aspnet_wp!webserver!bbc!12/15/2005-09:33:15:: e ERROR: Reporting Services error Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. > Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. > System.NullReferenceException: Object reference not set to an instance of an object.
|||
Do you set Height = 0 for any matrix cell in your report? Could you send us the report rdl files, please?
Thank you,
Nico
|||
Further testing seems to point in the following direction:
References in the subreport to either the ReportItems collection or embedded code seems to result in the error. If I remove these references, everything works fine (except the report is no longer accurate ).
NOTE: I tried listing the rdl, but saving the post with the rdl included resulted in an error
sqlError rendering subreport in table
First some informations:
The Report shows informations about server from our customers. There will be one report per customer. One Customer can have 1 or more servers. I get all servers from a customer with DataSet1. The result is one column with one or more rows (example "Server1", "Server2"...).
Its a really big report so i put all objects in subreport and in the "toplevel"-report i repeat the subreport for each row i get and set the column as parameter (which is defined in subreport).
Heres my problem:
if i put the subreport direct into the report and set a fix value for the server-parameter it works fine. if i put the subreport in table i get the followin error:
"[rsErrorExecutingSubreport] An error occurred while executing the subreport ‘subreport13’: Object reference not set to an instance of an object."
There must be a problem using the table. Funny thing is in this subreport i do the same procedure with another subreport and it works fine. I've "copy&past" the table from the subreport to "toplevel"-report. No chance.
Can someone help me?
Thanks in advance, Tobi
Is this RS 2005 RTM? This sounds like an issue which was solved in RS 2005 SP1 (http://www.microsoft.com/sql/sp1.mspx).
-- Robert
|||Hi,
We still have the same problem after applying the SP1 on server and client.
Thnx for an yhelp.
Sbastien
|||If that's the case, then most likely you have a list or table in the main report which contains a subreport. The subreport has not datasets at all and references another subreport.
If this is the case, then try the following workaround: Add a dataset to the subreport. The dataset query can just be as simple as "select 1 as id" - and you don't need to use the dataset anywhere in the subreport. Then delete main and sub reports from the report server and republish - it should work then.
-- Robert
|||Installing the SP1 is not the solution.|||Please read my previous posting in this thread with a suggested temporary workaround.
-- Robert
|||Now I've found the problem.I've got two DataSets in the subreport. Both use an period in where-statement (DateFrom and DateThru). The second DataSet caused the parameters to be set as string-parameter.
I can't comprehend why. The fields in the table are declared as DateTime.
I've no idea.
I solved the problem by doing a UNION in the first DataSet. Both have two columns and I use a third colum for identifiing the queries. There are maximum 100 rows in the result set so performance is no problem.
Hope that helps.
Tobi
Error rendering subreport in table
First some informations:
The Report shows informations about server from our customers. There will be one report per customer. One Customer can have 1 or more servers. I get all servers from a customer with DataSet1. The result is one column with one or more rows (example "Server1", "Server2"...).
Its a really big report so i put all objects in subreport and in the "toplevel"-report i repeat the subreport for each row i get and set the column as parameter (which is defined in subreport).
Heres my problem:
if i put the subreport direct into the report and set a fix value for the server-parameter it works fine. if i put the subreport in table i get the followin error:
"[rsErrorExecutingSubreport] An error occurred while executing the subreport ‘subreport13’: Object reference not set to an instance of an object."
There must be a problem using the table. Funny thing is in this subreport i do the same procedure with another subreport and it works fine. I've "copy&past" the table from the subreport to "toplevel"-report. No chance.
Can someone help me?
Thanks in advance, Tobi
Is this RS 2005 RTM? This sounds like an issue which was solved in RS 2005 SP1 (http://www.microsoft.com/sql/sp1.mspx).
-- Robert
|||Hi,
We still have the same problem after applying the SP1 on server and client.
Thnx for an yhelp.
Sbastien
|||If that's the case, then most likely you have a list or table in the main report which contains a subreport. The subreport has not datasets at all and references another subreport.
If this is the case, then try the following workaround: Add a dataset to the subreport. The dataset query can just be as simple as "select 1 as id" - and you don't need to use the dataset anywhere in the subreport. Then delete main and sub reports from the report server and republish - it should work then.
-- Robert
|||Installing the SP1 is not the solution.|||Please read my previous posting in this thread with a suggested temporary workaround.
-- Robert
|||Now I've found the problem.I've got two DataSets in the subreport. Both use an period in where-statement (DateFrom and DateThru). The second DataSet caused the parameters to be set as string-parameter.
I can't comprehend why. The fields in the table are declared as DateTime.
I've no idea.
I solved the problem by doing a UNION in the first DataSet. Both have two columns and I use a third colum for identifiing the queries. There are maximum 100 rows in the result set so performance is no problem.
Hope that helps.
Tobi
Error Rendering SSRS Reports via SOAP
server. The configuration has been unchanged for approx. 3 weeks. Suddenly
over the last two days, reports being accessed via an ASP.NET 2.0 application
(on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver
became inaccessable. End users received the following error:
********************************************************
Message: An error occurred during rendering of the report. -->
An error occurred during rendering of the report. -->
An error occurred during rendering of the report. -->
An error occurred during rendering of the report. -->
Attempted to read or write protected memory. This is often an indication
that other memory is corrupt.
Stack Trace: 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 IFA.CAP.SQLReportingService.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web
References\SQLReportingService\Reference.vb:line 1319
at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID,
Boolean isDraft, Boolean isCertified) in
C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line
551
at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e)
in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287
********************************************************
A short term resolution has been to perform iisrest on the ReportServer.
However, the problem reappears later at random intervals.
This only seems to be an issue with reports being called using SOAP.
Reports being rendering in the .NET Report Viewer control appear unaffected.
Here is some sample code to illustrate how we call some of our reports from
ASP.NET through the SSRS web service:
************************************************************
Private callback As New
System.Net.Security.RemoteCertificateValidationCallback(AddressOf
RemoteCertificateValidationCallback)
Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
ByVal cert As
System.Security.Cryptography.X509Certificates.X509Certificate, _
ByVal chain As
System.Security.Cryptography.X509Certificates.X509Chain, _
ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean
Return True
End Function
Sub RenderReport()
Dim rs As New SQLReportingService.ReportingService
Dim results As [Byte]() = Nothing
System.Net.ServicePointManager.ServerCertificateValidationCallback = callback
rs.Credentials = New System.Net.NetworkCredential("User", "Password",
"Domain")
results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF",
Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
Nothing, Nothing)
Response.Clear()
Response.Buffer = True
Response.Expires = 0
Response.ContentType = "application/pdf"
Response.AppendHeader("Content-Disposition", "attachment;
filename=Report.pdf")
Response.BinaryWrite(results)
Response.End()
End Sub
************************************************************
Does anyone see a problem with the above code. It has been in production
for 3 weeks now and has been working fine until yesterday. Any help would be
greatly appreciated!Try running memtest: www.memtest.org. You may have bad memory.
"mjorangehawk" wrote:
> I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003
> server. The configuration has been unchanged for approx. 3 weeks. Suddenly
> over the last two days, reports being accessed via an ASP.NET 2.0 application
> (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver
> became inaccessable. End users received the following error:
> ********************************************************
> Message: An error occurred during rendering of the report. -->
> An error occurred during rendering of the report. -->
> An error occurred during rendering of the report. -->
> An error occurred during rendering of the report. -->
> Attempted to read or write protected memory. This is often an indication
> that other memory is corrupt.
> Stack Trace: 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 IFA.CAP.SQLReportingService.ReportingService.Render(String Report,
> String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web
> References\SQLReportingService\Reference.vb:line 1319
> at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID,
> Boolean isDraft, Boolean isCertified) in
> C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line
> 551
> at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e)
> in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287
> ********************************************************
> A short term resolution has been to perform iisrest on the ReportServer.
> However, the problem reappears later at random intervals.
> This only seems to be an issue with reports being called using SOAP.
> Reports being rendering in the .NET Report Viewer control appear unaffected.
> Here is some sample code to illustrate how we call some of our reports from
> ASP.NET through the SSRS web service:
> ************************************************************
> Private callback As New
> System.Net.Security.RemoteCertificateValidationCallback(AddressOf
> RemoteCertificateValidationCallback)
> Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
> ByVal cert As
> System.Security.Cryptography.X509Certificates.X509Certificate, _
> ByVal chain As
> System.Security.Cryptography.X509Certificates.X509Chain, _
> ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean
> Return True
> End Function
>
> Sub RenderReport()
> Dim rs As New SQLReportingService.ReportingService
> Dim results As [Byte]() = Nothing
> System.Net.ServicePointManager.ServerCertificateValidationCallback = callback
> rs.Credentials = New System.Net.NetworkCredential("User", "Password",
> "Domain")
> results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF",
> Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> Nothing, Nothing)
>
> Response.Clear()
> Response.Buffer = True
> Response.Expires = 0
> Response.ContentType = "application/pdf"
> Response.AppendHeader("Content-Disposition", "attachment;
> filename=Report.pdf")
> Response.BinaryWrite(results)
> Response.End()
> End Sub
> ************************************************************
> Does anyone see a problem with the above code. It has been in production
> for 3 weeks now and has been working fine until yesterday. Any help would be
> greatly appreciated!
>|||Actually, it turns out the problem was related to a database image that was
being loaded into the report dynamically. The image control on the report
had a MIME type of jpg but we had a few cases of images that had been
inserted into the database as TIF's. Once we replaced those with JPG
versions the problem went away.
"breno" wrote:
> Try running memtest: www.memtest.org. You may have bad memory.
> "mjorangehawk" wrote:
> > I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003
> > server. The configuration has been unchanged for approx. 3 weeks. Suddenly
> > over the last two days, reports being accessed via an ASP.NET 2.0 application
> > (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver
> > became inaccessable. End users received the following error:
> >
> > ********************************************************
> >
> > Message: An error occurred during rendering of the report. -->
> > An error occurred during rendering of the report. -->
> > An error occurred during rendering of the report. -->
> > An error occurred during rendering of the report. -->
> > Attempted to read or write protected memory. This is often an indication
> > that other memory is corrupt.
> >
> > Stack Trace: 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 IFA.CAP.SQLReportingService.ReportingService.Render(String Report,
> > String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> > Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> > String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> > Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web
> > References\SQLReportingService\Reference.vb:line 1319
> > at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID,
> > Boolean isDraft, Boolean isCertified) in
> > C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line
> > 551
> > at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e)
> > in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287
> >
> > ********************************************************
> >
> > A short term resolution has been to perform iisrest on the ReportServer.
> > However, the problem reappears later at random intervals.
> >
> > This only seems to be an issue with reports being called using SOAP.
> > Reports being rendering in the .NET Report Viewer control appear unaffected.
> >
> > Here is some sample code to illustrate how we call some of our reports from
> > ASP.NET through the SSRS web service:
> >
> > ************************************************************
> >
> > Private callback As New
> > System.Net.Security.RemoteCertificateValidationCallback(AddressOf
> > RemoteCertificateValidationCallback)
> >
> > Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
> > ByVal cert As
> > System.Security.Cryptography.X509Certificates.X509Certificate, _
> > ByVal chain As
> > System.Security.Cryptography.X509Certificates.X509Chain, _
> > ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean
> >
> > Return True
> >
> > End Function
> >
> >
> > Sub RenderReport()
> > Dim rs As New SQLReportingService.ReportingService
> > Dim results As [Byte]() = Nothing
> >
> > System.Net.ServicePointManager.ServerCertificateValidationCallback = callback
> >
> > rs.Credentials = New System.Net.NetworkCredential("User", "Password",
> > "Domain")
> >
> > results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF",
> > Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> > Nothing, Nothing)
> >
> >
> > Response.Clear()
> > Response.Buffer = True
> > Response.Expires = 0
> > Response.ContentType = "application/pdf"
> > Response.AppendHeader("Content-Disposition", "attachment;
> > filename=Report.pdf")
> > Response.BinaryWrite(results)
> > Response.End()
> > End Sub
> >
> > ************************************************************
> >
> > Does anyone see a problem with the above code. It has been in production
> > for 3 weeks now and has been working fine until yesterday. Any help would be
> > greatly appreciated!
> >
Error rendering report as HTML
appears...but only the first page. I notice a small yellow error icon on the
bottom of the page and if I double-click it reads:
Line: 20
Error: 'Report' is undefined
Code: 0
If I view the page source, around line 20 is the following:
function OnLoadReport()
{
var pageHits = null;
var rep = new Report(1, 155, pageHits, false, docMapIds);
if (parent != self) parent.OnLoadReport(rep);
}
What gives? This report works if I render as PDF. What am I doing wrong?
Thanks
- dwdw,
Take a look at the renderstream method: http://tinyurl.com/5q4qb
Bob
"dw" <dw@.discussions.microsoft.com> wrote in message
news:EE900282-8684-44A8-BDD5-780F9B071EF8@.microsoft.com...
> I am rendering a report as HTML4.0 via Web Services interface and the
report
> appears...but only the first page. I notice a small yellow error icon on
the
> bottom of the page and if I double-click it reads:
> Line: 20
> Error: 'Report' is undefined
> Code: 0
> If I view the page source, around line 20 is the following:
> function OnLoadReport()
> {
> var pageHits = null;
> var rep = new Report(1, 155, pageHits, false, docMapIds);
> if (parent != self) parent.OnLoadReport(rep);
> }
> What gives? This report works if I render as PDF. What am I doing wrong?
> Thanks
> - dw
Error Rendering PDF Files
grateful.
I have a web page that shows reports a user can select. The rendering format
I use is PDF. When the user chooses to view the report for the first time,
they get an Adobe error message saying "There was an error opening this
document. The file cannot be found." The second attempt does not generate
this error. I also added a new report and it gets the Adobe error everytime.
If I let the format come out as native SQL Reporting, the error does not
happen at all. The user's would really like to have Adobe instead.
Can anyone tell me why this is happening and how to fix it? Thank you.I found the solution to this problem. Clearing the temporary internet files
enabled the Adobe error to go away.
"Mike Collins" wrote:
> If anyone can offer some suggestions for fixing this, I would be really
> grateful.
> I have a web page that shows reports a user can select. The rendering format
> I use is PDF. When the user chooses to view the report for the first time,
> they get an Adobe error message saying "There was an error opening this
> document. The file cannot be found." The second attempt does not generate
> this error. I also added a new report and it gets the Adobe error everytime.
> If I let the format come out as native SQL Reporting, the error does not
> happen at all. The user's would really like to have Adobe instead.
> Can anyone tell me why this is happening and how to fix it? Thank you.
>sql
Tuesday, March 27, 2012
Error programaticaly rendering a report using Reporting Services Web Services
My sample report has few parameters that must be passed so I pass these parameters with code.
<My code>
ReportServiceExecution.ReportExecutionService rs = new ReportServiceExecution.ReportExecutionService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
string extension, mimeType, encoding;
ReportServiceExecution.Warning[] warnings;
string[] streamID;
ParameterValue[] parameters = new ParameterValue[2];
parameters[0] = new ParameterValue();
parameters[0].Name = "pID";
parameters[0].Value = "6548747";
parameters[1] = new ParameterValue();
parameters[1].Name = "pClass";
parameters[1].Value = "8";
ExecutionHeader header = new ExecutionHeader();
ExecutionInfo executionInfo = rs.LoadReport(reportPayslip.Name, null);
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
rs.ExecutionHeaderValue = header;
rs.ExecutionHeaderValue.ExecutionID = executionInfo.ExecutionID;
byte[] report = rs.Render("PDF", "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>", out extension, out mimeType, out encoding, out warnings, out streamID);
</My code>
Actually, I have several more parameters but I've checked the collection and all the parameters I want are there and have values. Their names match those found in executionInfo.Parameters. But when I run my code I get the following error on Render():
<Error>
"This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. > This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. > This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value."
</Error>
I've double-checked and my parameter array does have the problematic parameter, I passed it a value but when I check executionInfo.Parameters I see that it's the only parameter that hasn't been give a default value after calling SetExecutionParameters(). So my parameters do seem to be passed but one seems to refuse getting a value. If I comment out the SetExecutionParameters() line I get, as expected a similar error but on another parameter (first one in the executionInfo.Parameters collection). So I'm left to beleive that the SetExecutionParameters() has some kind of bug as it works for all but one parameter. I've checked casing, spelling, tried passing phony parameters and from what I've seen I should be getting an error when I pass the parameters if I got something wrong.
Any help would be much appreciated.
I've done some (desperate) tests and changed the following line:
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
to
executionInfo = rs.SetExecutionParameters(parameters, "fr-ch");
I'm currently based in French Switzerland but our reports are written in english, besides, the documentation about this parameter is basically "A .Net language" which is not very helpful. So now it works but I'm afraid if I have to access a server that is of another culture it will fail.
Monday, March 26, 2012
Error Pdf rendering with de language
I have a problem with the pdf rendering.When I try to render the report to
the pdf with diffirent language like "de" or "fr" I give a error.How can I
export the report to the pdf with "de" language'Any ideas'Try to use a specific culture instead of a general one.
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pery" <Pery@.discussions.microsoft.com> wrote in message
news:723265F3-71EF-4AA2-9CC1-868EFEFB230E@.microsoft.com...
> Hi;
> I have a problem with the pdf rendering.When I try to render the report to
> the pdf with diffirent language like "de" or "fr" I give a error.How can I
> export the report to the pdf with "de" language'Any ideas'
Monday, March 12, 2012
Error occurred during rendering of the report. Stack Empty.
I have developed a report in SSRS 2005. When I try to export the output to Excel, it shows an error saying:
Error occurred during local report processing.
Error occurred during rendering of the report. Stack Empty.
Do anyone have any idea what this means and how to fix it?
I can render the report in other formats (Adobe, csv etc) without any problem. My other reports, under same project and using same dataset, are working fine.
Thanks in Advance.
Have you checked your log files for errors?
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles
You may need to crank up the level of tracing to get anything interesting:
http://technet.microsoft.com/en-us/library/ms156500.aspx
Does the report render in Excel for a different dataset? Try faking a dataset using something like:
SELECT 1 AS Age, 'M' AS Sex
UNION
SELECT 7 AS Age, 'F' AS Sex
and see if you render correctly. Make sure you have 'alligned your edges' to reduce the complexity of the resulting Excel. If you want to (are willing/able to) send me your RDL, I will take a look and post the results of my analysis back here.