DataSets with reportViewer?

[pencil151]

Hi I want to generate multipule reports from different datasets. So for example I have two different datasets:

1. Student DataSet
2. Classes DataSet

The Student DataSet contains these columns:
1. First Name
2. Last Name
3. Address
4. Email
5. Social #


The 2nd DataSet contains these columns
1. Class number
2. Class Description
3. Class Time

I would like to generate multipule reports with one reportViewer control/one .rdlc file into the Microsoft's local report engine. I do not want to create multipule .rdlc's for each output. Is there a way to dynamically display the current dataset into a .rdlc, then generate the report?

This is one of the examples I was looking at but you have to create the columns statically, drag/drop those fields into the report viewer control "table."

http://www.c-sharpcorner.com/Upload...bject04172007111636AM/ReportViewerObject.aspx

I want to be able to have different datasets and have the reportviewer generate a new report automatically without having to edit the .rdlc file. I couldn't find a good easy example of how to approach this, thanks!

 

[jmeckley]

a report is just a GUI, like a webpage or windows form. in this case it's readonly and a report. when you design forms/webpages you create a specific object for each view. the same would be true of reports.

each report should fulfill a specific requirement. therefore each report should be it's own unique object. You would have 1 report viewer, which could display any of the reports.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[pencil151]

thanks for the reply.

so for each different report i would need to customize a .rdlc report? yes i understand that i only need one ReportViewer control to display all the different .rdlc's, i thought i could have a single .rdlc report that can dynamically change to accommodate multiple different dataTables.

 

[jmeckley]

that is how I would handle the reports.

Jason Meckley
Programmer
Specialty Bakers, Inc.