I have 4 subreports on my main report, each presenting different data (some of these I have had to write SQL commands to get the exact data I was looking for). The main report has a group (SAMPLE.GROUP_NAME) in which each subreport is placed in the group footer of this group.
e.g. GF2A = samples not released
GF2B = samples not reviewed etc....
I have used shared variables to give me a grand total of each of these subreports placed in the Report Footer of the main report. This is calculating perfectly fine. Problem: I need to chart these values
i tried using that Charting for print time formulas technical document but it doesn't work for me because I don't have anything in my details section in my report. I tried placing the chart in my main report footer and all I see are zeros. I tried placing a chart in the Group Footer of my main report and was hoping to suppress all other reports except for the final one where I would have a grand total but it is always off the first set of numbers. e.g. dataset 1 = 9, dataset 2 = 7--- it starts with 7. I understand I am tricking the system using whileprintingrecords when it needs to use whilereadingrecords first etc.... regardless i can't get this work and I cannot find anything within this forum that is similar to my situation that actually has an answer attached to it.
Any help is much appreciated. I have attached a screenshot of the design view
Thx
J
e.g. GF2A = samples not released
GF2B = samples not reviewed etc....
I have used shared variables to give me a grand total of each of these subreports placed in the Report Footer of the main report. This is calculating perfectly fine. Problem: I need to chart these values
i tried using that Charting for print time formulas technical document but it doesn't work for me because I don't have anything in my details section in my report. I tried placing the chart in my main report footer and all I see are zeros. I tried placing a chart in the Group Footer of my main report and was hoping to suppress all other reports except for the final one where I would have a grand total but it is always off the first set of numbers. e.g. dataset 1 = 9, dataset 2 = 7--- it starts with 7. I understand I am tricking the system using whileprintingrecords when it needs to use whilereadingrecords first etc.... regardless i can't get this work and I cannot find anything within this forum that is similar to my situation that actually has an answer attached to it.
Any help is much appreciated. I have attached a screenshot of the design view
Thx
J