Hi All, I have two subreports that i am placing on main report footer. My both subreports are calclulating Inventory quantities of different size like 2cm and 3 cm.I am doing this 2 subreports because my data are in rows in my universe and I need to display those data in columns on my report. I have sort of completely done my report except couple of issues.
My first Issue: I need to get a column of total quantity of both of these subreports quantities. I tried shared variable but can't get it to work. Please suggest me if there are other way to accompolish my goal.

2nd issue: I need to display a column for ranking in main report. And this ranking is base on avearage Sales amount of inventories sold. Tried this also with shared variable can't get it to work. Please suggest me any other ways.

Thanks in advance

Thank you, DBlank for quick response. I tried cross-tab too. My issue with cross tab was again couple of more calculated fields that i need to add for each size 2cm and 3cm. Or simply the format that i have for the report, cross-tab doesn't support. Though cross -tab is great to display row data into column information.

My data in subreport is on GF1 for both. And I have inserted a new report footer in my main report where i placed my shared variable but doing so I only see only last record from each subreport. Which is not really I wanted to see. I wanted to see each total for each record that subreport returns in main report. what do you think I am missing to do that this shared variable is not returning all records.

DBlank, this is the formula I have in my each subreport.
First subreport:
formula Test1:
sum({23051.Pricing Quantity},{23051.Item Description})
formula Test2:
Shared numbervar Amount1;
Amount := {@test1};
2nd subreport:
formula Test3:
sum({23051.Pricing Quantity},{23051.Item Description})
formula Test4:
Shared numbervar Amount2;
Amount2 := {@test3};

And in my main report. I have formula placed in 2 report F.
formula name test 5:
shared numbervar Amount1;
Amount1
formula name test6
shared numbervar Amount2;
Amount2

What do you think need change in my above formula?

Edited by visit2me - 28 Jun 2011 at 7:20am

note i don't like variables, i prefer running totals (which won't work here) so I hope I got this correct

thanks lockwelle!