Two of same Report in one ReportBook, different parameters

[Tristan]

I'm trying to create a compilation of several instances of the same report using a ReportBook. 

 The issue I'm having is that although I'm instantiating separate instances of the report and setting the date parameter for each, all the reports are returning data for the same date, rather than for their individual parameter dates.

 

My code:

ReportBook reportBook = new ReportBook();

reportBook.Reports.Add(new TestReport());
reportBook.Reports.Add(new TestReport());

reportBook.Reports[0].ReportParameters["date"].Value = new DateTime(2015, 10, 1);
reportBook.Reports[1].ReportParameters["date"].Value = new DateTime(2015, 10, 2);


var instanceReportSource = new InstanceReportSource();
instanceReportSource.ReportDocument = reportBook;
reportViewer.ReportSource = instanceReportSource;

reportViewer.RefreshReport();

I'm working in C#; the report is included in the Visual Studio project as an object (not a seperate .trdx), with an ObjectDataSource using an externally referenced Entity Framework repository; the DataMember is a method of the EF repository that is essentially 'GetThingsForDate(DateTime date)'.

 

Any insight much appreciated!

[Tristan]

I'm not sure if it's the "correct" way to solve the issue above, but I managed to get this working as I wanted by manually defining a new ObjectDataSource for each instance of the report:

var report1 = DeserializeReport(@"Reports\Test Report.trdx");
var objectDataSource1 = new ObjectDataSource(typeof(EntityFrameworkRepository), "GetThingsForDate");
objectDataSource1.Parameters.Add("date", typeof(DateTime), new DateTime(2015, 10, 1));
report1.DataSource = objectDataSource1;

var report2 = DeserializeReport(@"Reports\Test Report.trdx");
var objectDataSource2 = new ObjectDataSource(typeof(EntityFrameworkRepository), "GetThingsForDate");
objectDataSource2.Parameters.Add("date", typeof(DateTime), new DateTime(2015, 10, 2));
report2.DataSource = objectDataSource2;

ReportBook reportBook = new ReportBook();
reportBook.Reports.Add(report1);
reportBook.Reports.Add(report2);

var instanceReportSource = new InstanceReportSource();
instanceReportSource.ReportDocument = reportBook;
reportViewer1.ReportSource = instanceReportSource;

reportViewer1.RefreshReport();

 

That's also using the DeserializeReport method posted by one of the admins elsewhere on these forums, to allow for the report to be included as a .trdx rather than a class object, as recommended in the best practices section of the documentation:

public Report DeserializeReport(string path)
{
    System.Xml.XmlReaderSettings settings = new System.Xml.XmlReaderSettings();
    settings.IgnoreWhitespace = true;

    using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(path, settings))
    {
        Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();
        Telerik.Reporting.Report report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);

        return report;
    }
}

[Nasko]

Hello Tristan,

Telerik Reporting provides a mechanism known as parameter merging. If the Name and Type of two (or more) parameters from different reports are the same, then they are considered equivalent and are displayed as a single parameter in the parameters area. When one or more parameters are merged the UI settings (and value) of the first one are used for displaying it in the parameters area.
You can control parameter merging via the Mergeable boolean property of the report parameter. The default value of the Mergeable property is true. Set the Mergeable property to false if you want to prevent a parameter from being merged with its equivalent ones.
Additional information is available in the Report Book  help article.

Regards,
Nasko
Telerik

[Tristan]

A big thank you to you Nasko!

This is what I needed to generate a report book with multiples of the same report with different parameters.