1537776 - How to display charts in different group levels in one group header section side by side

• Report contains groups with multiple group levels
• Display charts in different group levels in one group header section side by side.

Product Version: Crystal Report XI Release 2.

Operating System: Windows XP SP2.

1) Create a sample report based off Xtreme Sample database.

2) Select the Customer table.

3) Filter the Countries by using Select Expert and select Customer.Country is one of Australia, Canada, and Germany.

4) Insert first Group on Customer.Country and second group on Customer.Region.

5) For Group Header #1 insert three sections below and suppress all the remaining sections.

6)Go to 'Section Expert' and select Group Header #1a and write a condition for suppression as following : GroupName({Customer.Country})<>"Australia".

7) Now select Group Header #1b and write a condition for suppression as following: GroupName ({Customer.Country}) <>"Canada".

8) Then select Group Header #1c and write a condition for suppression as following: GroupName ({Customer.Country}) <>"Germany".

9) Insert a chart in Group Header #1a section and select Customer.Region-A under the option On change of and Select 'Last Year Sales' under the option Show Values.

10) Repeat the same procedure for Group Header #1b and Group Header #1c.

Work around for displaying charts in same section of the report horizontally one after other is as follows:

1) Create two different instances of the same report (i.e. save the same report with two different names say a and b).

2) Go to newly created first instance of the report (report a) and suppress all sections except Group Header #1b.

3) Go to newly created second instance of the report (report b) and suppress all sections except Group Header #1c.

4) Now go to original report where you want to display charts in same section.

5) Go to Insert from the Menu and insert sub report, select Choose an existing sub report and then select report 'a' which is newly created.

6) Insert this sub report in Group Header #1a section of the main report next to existing chart.

7) Go to Insert from the Menu and insert a sub report, select Choose an existing sub report and then select report 'b' which is newly created.

8) Insert this sub report in Group Header #1a section of the main report next to existing chart and sub report.

9) You will see three charts with different values based on different group values in one section next to one another.

Charts, Different Group Levels, Same Section. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem