Returning data from SQL Server reporting web service call
Posted
by user79339
on Stack Overflow
See other posts from Stack Overflow
or by user79339
Published on 2009-03-18T07:20:01Z
Indexed on
2010/03/17
5:01 UTC
Read the original article
Hit count: 250
Hi, I am generating a report that contains the version number. The version number is stored in the DB and retrieved/incremented as part of the report generation.
The only problem is, I am calling SSRS via a web service call, which returns the generated report as a byte array.
Is there any way to get the version number out of this generated report? For example to display a dialog that says "You generated Status Report, Version number 3". I tried passing in an output parameter and setting it inside the storedproc. Its modified when i execute it in sql management studio, but not in the reporting studio. Or atleast i can't seem to bind to the modified, post execution value (using expression "=Parameters!ReportVersion.Value").
Of course, I could get/increment the version number from database myself before calling the SSRS webservice and pass it along as a parameter to the Report, but that might cause concurrancy problems.
On the whole, it just seems neater for the storedproc to access/generate a version number and return it to the ReportingEngine, which will generate the report with the version number and return the updated version number to the WebService client.
Any thoughts/Ideas?
© Stack Overflow or respective owner