[RESOLVED] VS2010: ASP.Net RDLC Report Question

[rpc86]

Hi guys,

I created a stored procedure (MS SQL Server 2008 R2) with a temporary table and parameters. Need to know on how to create RDLC report with a stored procedure.

Many thanks!

[sapator]

Maybe this can help?
http://myaspdotnettrainings.blogspot...ge-client.html

[rpc86]

Thanks for the link but it didn't answer my question. What I need to know is how to add stored procedure (SP) in the RDLC. My SP has a temporary table from where the results returned.

[brin351]

Step 8 in the article Sapator linked to shows how to programatically attach a datasource/set to the report. Given that you should be able create a dataset from your SP and bind it to the report.

[rpc86]

I found the solution.

SET FMTONLY ON;