Reporting off ADO.NET Dataset

[mubaig75]

I have a .NET Dll function which returns ADO.Net Dataset. I like to design a report off this dataset it. I like to know the procedure of connecting it to Report Designer so that I can get the database fields. I would also appreciate any link to any tutorial or so.

Thanks

 

[randysmid]

Hi,
I had a problem similar to this, and ended up solving it a bit differently. I wrote an FAQ on the topic of passing criteria from a separate form to the ASPX form that contains the report viewer. You can find it at: FAQ766-5471

The key idea is to create the report based on the ADO dataset, but NOT to bind it to the ASPX web page that contains the Report Viewer. Instead, you will see that my code pushes down the request to the database server, creates a dataset out of the returned data, then binds that to the report viewer.


HTH,
Randy Smith, MCP
California Teachers Association