This is a migrated thread and some comments may be shown as answers.

Combine paramertized reports in Report Book problem

5 Answers 218 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

VanirDev asked on 12 Jun 2009, 10:57 PM

Hi,
Lets suppose that Region consists of multiple Areas
I have two reports: RegionReport and AreaReport that I would like to combine into one report book.
RegionReport takes one non-mergable parameter, integer - regionId, that I use in NeedDataSoruce in my db query.

In my report book I am trying to achieve the following:
RegionReport - ie California
AreaReport - Sacramento
AreaReport - LA
RegionReport - ie Texas
AreaReport - Dallas
AreaReport - Huston

To achieve this I construct the report book in the following way:

    
            reportBook = new ReportBook(); 
        
            for (int i = 0; i < regionList.Count; i++) 
        
            { 
        
                RegionReport regionReport = new RegionReport(); 
        
                regionReport.ReportParameters["RegionId"].Value = regionList[j]; 
        
                reportBook.Reports.Add(regionReport); 
        
                for (int j = 0; j < areaList.Count; j++) 
        
                { 
        
                    AreaReport areaReport = new AreaReport(); 
        
                    areaReport.ReportParameters["AreaId"].Value = areaList[j]; 
        
                    reportBook.Reports.Add(areaReport); 
        
                } 
        
            }

When processing the reports, in NeedDataSource event, the value for the RegionId paramenter in the following code is always of the last value added. In other words it is not preserved from one RegionReport to another.

    
            private void RegionReport_NeedDataSource(object sender, EventArgs e) 
        
            { 
        
                Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender; 
        
                //If I had two RegionReport reports added to the book, RegionId parameter's value would be always of the last one added. 
        
                int param = Convert.ToInt16(this.ReportParameters["RegionId"].Value); 
        
                ...

What is the proper way of preserving individual reports paramenters' values in a report book ?
Thank you
Pawel Mozdzen

5 Answers, 1 is accepted

answered on 15 Jun 2009, 02:29 PM

webapplication1.zip

Hello Pawel,

I was not able to replicate the problematic behavior you've described. Please find attached a sample web application that mimics your code and works as expected. Give it a spin and let us know if further help is needed.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 16 Jun 2009, 06:03 PM

Hi Steve,
I am afraid your workaround is not going to work.
In out proc session mode the report class gets instantiated several times. Here is an example:

    
            ReportBook reportBook = this.ReportViewer1.Report as ReportBook; 
        
            string[] regionList = new string[4] { "2008", "2009", "2010", "2011" }; 
        
            for (int i = 0; i < regionList.Length; i++) 
        
            { 
        
                Report1 report = new Report1(); 
        
                report.ReportParameters["Year"].Value = regionList[i]; 
        
                ... 
        
                reportBook.Reports.Add(report); 
        
            }

The Report1 class gets initialized, as it should, at line 6 but also when I go through reports in report viewer. Before first page is displayed Report1 gets initialized 4 times (number of projects in the report book) and on any subsequent page, when Next Page button is clicked, it gets initialized all four times.
Any attempt to modify or add a parameter will not work.
Any other ideas on how to manage parameters are welcomed.

How can I track this issue's bug status?

Thank you,
Pawel Mozdzen