Adding reports to ReportBook in Code-Behind

[juststarting]

Hi,

I have successfully added a class with all my reports to my current project. However I do have a screen where the user can select which reports he/she want to print in a reportbook and save it into a pdf, and mail it to the user.

Currently the routine is as follows:
Select Case ReportSelected
    Case 1
          reportBook.Reports.Add(New Report1())
    Case 2
          reportBook.Reports.Add(New Report2())
    Case ....
End Select

This goes up to 40 at this stage.

What I want to know is if it is possible to this data in a database table and put the system through a loop to retrieve the report name from the database and add it to the reportbook?

Something like this :
While dbReader.Read()
     reportBook.Reports.Add(New dbReader("ReportName"))
End While

[Peter]

Hello Sarel,

You can achieve your requirement in two ways. The first one is to keep in the report the serialized as XML reports or trdx report definitions created with the Report Designer. Then you can deserialize the XML report definitions and add them to the reportbook reports collection.

The other option is to keep in the database the AssemblyQualifiedName. Then you can instantiate the reports with reflection add them to the reportbook reports collection as shown in the following code snippet:

var reportType = Type.GetType(reportName);
var report = (IReportDocument)Activator.CreateInstance(reportType);

Greetings,
Peter
the Telerik team