Best Way to Put charts on reports

[manix]

Hi All,

I have a report, that has a detail section that shows an amount of records dependant upon the results of a query. Pretty straightforward, but I have no idea of the best place to put a could of graphs that I want to show on the same report!

I can't put them in the detail section or they'll display with every record and and if I put them in the footer they will appear on every page! How can I create a section for the graphs, so that they are only on one page, regardless of the amount of records shown?

I tried to create a new group called graphs, but this for some reason, means when I open the report, it asks for criteria for "Graphs"! Sorry I don't understand the significance of these grouped sections!

How can I do this?

TIA

 

[KenHigg]

Can you use independant sub reports?


ken

 

[manix]

I see what you saying, but where do I put them? If the subreport is put in the detail section of the main report, it will be dplicated with every record?! I.e. I get a subreport for every record shown. I don't want that.

 

[Brianwarnock]

How about the report footer as a kind of appendix.

Brian

 

[manix]

Na It needs to be on this first page. I cannot believe you just can't create a section for these graphs! Why does it have to be bound or ordered by something, why can't you just ahve a section of your report that you can place objects on? A bit like a header of footer, but in the body of the report!!!!

 

[KeithG]

Or you can use the report header so that the user see's the chart ( it will be the first page) then the actual data. Or if you use grouping in your report I like to the a chart in the group header so that the chart contains data for the particular group.

 

[KenHigg]

I would think you do the chart in the main report and the list stuff in the sub report


ken

 

[manix]

I would think you do the chart in the main report and the list stuff in the sub report


ken

That's the one....needed a bit of "jiggery pokery", but done it.

Thanks all. Ken you get the golden stick!

 

[KenHigg]

Send cash



ken