Reporting Services Returned Data

Hey guys :)

I am not sure i have titled this post correctly or even if i have posted it in the correct forums, so please accept my apologies if i have done either wrong.

Does anyone know of a way to return the underlying data that produces a report from within c#

I am using the report viewer component and the Reporting Services SOAP service.

I am currently using the GetReportDefinition(string ReportPath) function to return the entire xml definition of the report and then parsing out the CommandText and ConnStr fields and the running these as you normally would to return a DataSet :), but obviously this means double the processing time on the server if the user firstly runs the report and i dont really want to have to do this.

Any help would be much appreciated :)

oops i failed to mention, not all the reports use shared data sources :( so i cant use them.

Merry Christmas

Scott Blood

you can tie the returned xml directly to a datagrid and then display the data on the grid and then print the same or you can also tied the data to a data grid and then use response object to display the same data on the excel.

|||

abdulbq:

you can tie the returned xml directly to a datagrid and then display the data on the grid and then print the same or you can also tied the data to a data grid and then use response object to display the same data on the excel.

Abdul,

Thanks for replying to this question. However i am not sure how to access the returned xml of a report. Can you point me in the right direction on how to get this data.

Thanking you in advance.