Joined: 09 Aug 2012
Online Status: Offline
Posts: 57
Topic: Chart from differents sub rep Posted: 12 Oct 2012 at 9:24am
I have a reports with 3 sub reports. I have to add chart to compare data from the all reports. They are standard ones. It has a column title Description and the name of each month of the year, data amounts given as a credits.
Joined: 06 Aug 2012
Location: United States
Online Status: Offline
Posts: 75
Posted: 15 Oct 2012 at 4:50am
To create chart in main report based on sub report results, Approach 1: use same tables needed for chart and do calculations using formulas/ running totals to get data amounts, etc. (like complete different report. if it is not possible or performance issue, try the other)
Approach 2: create shared variable in sub-report and call that variable in to main report, where you creating chart, but I guess there are some restrictions for this to work, like shared variable(sub report) should be placed above the chart section. in sub-report create: WhilePrintingRecords; Shared NUMBERVar AMOUNT := formula (or field) in Main-report Call: WhilePrintingRecords; Shared NUMBERVar AMOUNT; AMOUNT
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged