This is driving me nuts.
I have a subreport placed in a detail line of my mainreport. My layout of my mainreport is like this:
[tt]
GpH1 ==> Item number
det ==> Qty Loc#1 (subreport for unit cost)
det ==> Qty Loc#2 (subreport for unit cost)
GpF1 ==> Total Qty times unit cost to get Total cost for item
[/tt]
Now I realize I don't have to get the cost twice for the same item number but if I place the subreport anywhere else it either comes back with a value of zero or the value of the previous item. I even tried placing it in a det(a) underlaying det(b) where I placed the Qty fields. I get the correct values this way that I am doing it but the person I am doing the report for does not have to see all the differnt Loc's for the same item, just the total for the item and the extended cost. If I attemp to suppress the detail sections of the mainreport my shared variable comes back as zero and my extended costs calculate to $0.00.
Thanks for your help
Mark
Email: markanas333@hotmail.com
I have a subreport placed in a detail line of my mainreport. My layout of my mainreport is like this:
[tt]
GpH1 ==> Item number
det ==> Qty Loc#1 (subreport for unit cost)
det ==> Qty Loc#2 (subreport for unit cost)
GpF1 ==> Total Qty times unit cost to get Total cost for item
[/tt]
Now I realize I don't have to get the cost twice for the same item number but if I place the subreport anywhere else it either comes back with a value of zero or the value of the previous item. I even tried placing it in a det(a) underlaying det(b) where I placed the Qty fields. I get the correct values this way that I am doing it but the person I am doing the report for does not have to see all the differnt Loc's for the same item, just the total for the item and the extended cost. If I attemp to suppress the detail sections of the mainreport my shared variable comes back as zero and my extended costs calculate to $0.00.
Thanks for your help
Mark
Email: markanas333@hotmail.com