Problems with a shared variable 1

[Ohioste]

I'm running a report trying to pull in data for sales.

In a subreport that is above the main report, I'm trying to share the sales. However, on the main report, it keeps returning the last piece of data it looked at.

In my sub report, my formula is:

whileprintingrecords;
shared numbervar x := Sum ({SSTRAN00.SSASHQ}, {SSTRAN00.SSSTYL})


In my main report my formula is:

whileprintingrecords;
shared numberVar x := x;

I'm trying to get it to look at x for each SKU that is listed.

I'm sure this is an easy solution. I'm in training with the Crystal "guru" on site and neither of us have used this before.

Hopefully this makes sense to someone! If you need more information, please let me know.

Thanks in advance.

 

[lbass]

Sounds like you need to move the subreport into a SKU group section on the main report, and link on the SKU field.

-LB

 

[Ohioste]

Perfect! Thanks.