UNCTarheels
Programmer
I am creating a Inventory Valuation Report, grouped by Product Code. I do not want to display the detail information. I have this part working.
What I need to do now, is to create a percentage field on the group line. The percentage is Extended Cost - Group / Total Extended Cost for Inventory. I need to be able to allow the user to select the Product Code(s) and show the correct percentage. The Grand Total will be for the entire inventory and not just for the Product Code(s) selected.
I tried to use a subreport, but I cannot get access to the grand total of the subreport.
I would appreciate any help!
ps. I know that this is very similiar to at least two new postings, but since they indicate that you need to use a value in a lower band and I do not use that lower band, then I am at a lost. Also, I have not been able to pass a value from a subreport to the main report.
Thanks! A little bit you, a little bit me. [hippie]
What I need to do now, is to create a percentage field on the group line. The percentage is Extended Cost - Group / Total Extended Cost for Inventory. I need to be able to allow the user to select the Product Code(s) and show the correct percentage. The Grand Total will be for the entire inventory and not just for the Product Code(s) selected.
I tried to use a subreport, but I cannot get access to the grand total of the subreport.
I would appreciate any help!
ps. I know that this is very similiar to at least two new postings, but since they indicate that you need to use a value in a lower band and I do not use that lower band, then I am at a lost. Also, I have not been able to pass a value from a subreport to the main report.
Thanks! A little bit you, a little bit me. [hippie]