Report layout

Hey guys,

I want to create a report called "Report X", which has four reports under it. Assume the following scenario.

1. Report X

1.1. Bar chart report

1.2. Pie chart report

1.3. Matrix report

1.4. Pie chart report

In addition to this, there are about four parameters that should be available for all reports. So my question is: what approach should I follow to implement/design a report for the above requirement. Can anyone give me how to design the report layout.

Any idea is appreciated.

Thank you for your cooperation in advance.

Sincerely,

Amde

You can add the four reports as sub-reports of Report X, and pass in the four parameters from Report X to the sub-reports.|||

Hi Fang,

Thank you for your response. The thing is I don't want to use the sub-reporting concept becuase of the performance issue.And I am looking for if there is alternative way to design the report using data regions insteade of creating sub reports. As you know Data regions provide much of the same functionality and flexibility as subreports, but with better performance.

Sincerlely,

Amde

|||

If you don't want to use subreports, you can just add four dataregions - a bar chart, a pie chart, a matrix and a pie chart, one below the other, to the main report. They can use the same dataset, or you can have multiple datasets in the main report. As for the parameters, just define them on the main report level, and reference them from the individual dataregions.

Can you elaborate a little bit more on the subreport performance issue? Are you concerned with the fact that a separate query needs to be executed for each subreport?

|||

Dear Fang,

Basically, I am not that much concerned on the performance impact that sub reports would bring. I can use sub reports. However, I was just curious to know if there is an alternative way to design the report so that I can select the best one.

By the way, if I add all the four regions in the main report, can I use a list data region to put all of them in the list?

The last but not the least, I want you to provide me your suggestion on which alternative is a good approach and easy to design the report (the sub report or add all data regions in the main report?)

Appreciate your feedback

Sincerely,

Amde