polynominal
asked on
Shared Variables and Graphs
I have a report which is laid out as follows.
Jan Feb Mar etc
No of Calls 10 11 25
No of Enquiries 11 10 5
Totals 21 21 30
The report has a sub report. The No. of Enquries uses a shared variable to obtain the values from the sub report. The totals adds the shared variable to the formula used to obtain the No of Calls in the main report.
My problem is I want to use the totals figures in a graph, but cant do so because of using a shared variable.
Is there anyway around this
Thanks
Poly
Jan Feb Mar etc
No of Calls 10 11 25
No of Enquiries 11 10 5
Totals 21 21 30
The report has a sub report. The No. of Enquries uses a shared variable to obtain the values from the sub report. The totals adds the shared variable to the formula used to obtain the No of Calls in the main report.
My problem is I want to use the totals figures in a graph, but cant do so because of using a shared variable.
Is there anyway around this
Thanks
Poly
ASKER
Thanks for the answer
The information is for graphing in the subreport from the main report.
Mine is the other way round, from the subreport to the main report, so does not work.
The information is for graphing in the subreport from the main report.
Mine is the other way round, from the subreport to the main report, so does not work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_charting_print_time_formulas.pdf.asp
mlmcc