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

Avoid empty reports in a reportbook

2 Answers 82 Views

General Discussions

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

Peter asked on 08 Mar 2012, 02:50 PM

I have created a reportbook which shows sales information at the highest level of a client. If a client-structure contains several departments, a sales report for each department is created, and will be added to the reportbook.

The structure of a client is stored outside telerik, in an AD-database. The parameters are passed to the report in the code-behind (department is item in a list of departments items):

foreach (var item in items)

{

RptAnalyseOmzetTotaal rptAnalyseOmzetTotaal = new RptAnalyseOmzetTotaal();

rptAnalyseOmzetTotaal.ReportParameters["customer"].Value = item.TrimStart('0');

rptAnalyseOmzetTotaal.ReportParameters["year"].Value = year;

rptAnalyseOmzetTotaal.ReportParameters["periodFrom"].Value = periodFrom;

rptAnalyseOmzetTotaal.ReportParameters["periodTo"].Value = periodTo;

reportBook.Reports.Add(rptAnalyseOmzetTotaal);

}

The problem is if a department doesn't have sales for the asked period, an empty report is added to the reportbook.
I need to do a check if a department contains data. Does the report-class rptAnalyseOmzetTotaal have a method to check if it contains data for the given parameters?

I'm using Reporting Q1 2012 in a Umbraco Portal.

Avoid empty reports in a reportbook

2 Answers, 1 is accepted