Global Variables and Main/Sub Reports Sums

[driman]

I have a main report which summarizes stored global variables from three sub reports for the week, month, year sales volumes, all of which comes from muliple data sources. Using the global variable function, I am calling the group summaries into the main report.

However if the Values of the Summary = 0 for example order file, I get the same value from the previous records rather then a zero.How can I eliminate the pickup of the last > 0 value for future records.

 

[driman]

Since I have not recivied a response, I will try to word differently.

I am using CR 8.5 via a dbf connction.
Here is an example:

The one Subreport contains records...
Sales Week 1 Week 2 Week 3 Week 4 Week 5 Week 6
50k 50k 60K 128K 0 0

In the main report when I pass those values via the WhilePrintingRecords, I am getting sales in Week 5 and Week 6 for 128K (which are weeks 4 Values) eventhough there were no sales in that period, because it retains that last record.