Multiple instance of sub-report (chart)

[liddlem]

Hi all
I have created a chart in a subreport

The parent report is structured as follows
- GROUP - Users info (Grouped by ID_User)
- GROUP - TEST info (Grouped by ID_TestNAme)
- GROUP - ASSESSMENT info (Grouped by ID_Assessment)
- - A bar chart for the ASSESSMENT group is displayed here (and working fine)
- Assessment criteria (detail section)

I want to put a summary chart (my subreport) into the second group. Hence..
- GROUP - TEST info (Grouped by ID_TestName)
- - Insert a bar chart that summarizes the entire TEST info (Averages of ALL the data shown under this TEST)
The subreport is linked via the ID_TestName.

When there is only one ASSESSMENT group, no problem, but if there are 4 ASSESSMENT groups, then my sub-report is displaying 4 times,

How do I display the TEST summary report only once.

 

[arnelgp]

put it in the page header or footer.

 

[liddlem]

Thanks Arnelgp
I guess that its my own fault for not mentioning that I have tried putting the sub-report in ALL sections. No change in any.

I am wondering if I will be forced to have a sub-report for TEST and then a SUB-SUB-Report for criteria. I'd like to avoid this if possible.

 

[JHB]

Post a stripped down version of your database with some sample data in it + name of the report, and also a printscreen of how you want it.

 

[liddlem]

Thanks for input.
I turns out that I had created a badly structured query.
Fixed the query - Now its working as expected.

 

[JHB]

Good you solved the problem.