Prev: Setting Credentials and Language in Reportviewer
Next: MS SQL 2000 Reporting Services Excel Export - Show Grid Lines in Excel
From: Andrew Hayes on 13 Jun 2007 04:25
Anyone used these methods, as well as the LoadReportCompleted /
RenderCompleted events, to successfully render a report through the
ReportExecutionService so that the user isn't sitting there waiting for a
large report to be generated?

Also, if you have used these methods, why is it that the first time I call
the web service it returns an exception when executing this line:

execInfo = rs.GetExecutionInfo();

"A first chance exception of type
'System.Web.Services.Protocols.SoapException' occurred in
System.Web.Services.dll
<detail><ErrorCode
xmlns="http://www.microsoft.com/sql/reportingservices">rsMissingSessionId</ErrorCode><HttpStatus
xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message
xmlns="http://www.microsoft.com/sql/reportingservices">The session identifier
is missing. A session identifier is required for this operation.
</Message><HelpLink
xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsMissingSessionId&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3054.00</HelpLink><ProductName
xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server
Reporting Services</ProductName><ProductVersion
xmlns="http://www.microsoft.com/sql/reportingservices">9.00.3054.00</ProductVersion><ProductLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem
xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation
xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesWebServer</Source><Message
msrs:ErrorCode="rsMissingSessionId"
msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsMissingSessionId&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3054.00"
xmlns:msrs="http://www.microsoft.com/sql/reportingservices">The session
identifier is missing. A session identifier is required for this operation.
</Message></MoreInformation><Warnings
xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>"

But subsequent calls work fine and create a seperate window containing the
exported PDF (although the user has to wait for the export to finish, so it's
not really executing in an asynchronous manner).

It would probably be more useful if either of these methods were in BOL, but
they're not. There is nothing in MSDN, TechNet nor Google about
LoadReportAsync (except for it being the same name as someones custom
function), and very little about RenderAsync (except for a similiar question
that never got an answer). Are they unsupported methods?
 | 
Pages: 1
Prev: Setting Credentials and Language in Reportviewer
Next: MS SQL 2000 Reporting Services Excel Export - Show Grid Lines in Excel