chthomas
Registered User.
- Local time
- Today, 07:17
- Joined
- Feb 8, 2000
- Messages
- 32
Hi,
I have a Cost Revenue report which attached alongwith and is working fine right now. Am grouping
the Cost Categories and summing it up. But my client wants the report to be printed out with some
changes only in the Budget Amount column.
Change1
-----------
"Budget Amount" for Cost Category "H01 Sales Budeget" which appears after "Cost Sum" should be
[(-1)*COST SUM AMOUNT]-[SALES BUDGET]
ie Instead of the present Sales Budget -215.5 shown in the report, it should be
[-1*49730]-[215.5] which equals to -49945.5
Change2
-----------
HOwever "Turnover sum" now showing as -215.5 which is the original "Sales Budget" should be shown as -215.5 itself.
The trick is if i accompolish Change1, then "Turnover sum" should be shown as -49945.5
Change3
-----------
"Grand Total" which is now showing as 49514.5 (Turnover+Cost) should also be shown as the original Sales Budget whcih is -215.5
Though its shown that the report picks data from table its actually from a query which i converted as a Table for the ease of posting to the discussion.
I tried to convince my client that the report gets the data as a result of grouping and summing, but in vein.
Is there any way to do this? Any ideas or suggestions will be highly appreciated.
Regards,
Charley
I have a Cost Revenue report which attached alongwith and is working fine right now. Am grouping
the Cost Categories and summing it up. But my client wants the report to be printed out with some
changes only in the Budget Amount column.
Change1
-----------
"Budget Amount" for Cost Category "H01 Sales Budeget" which appears after "Cost Sum" should be
[(-1)*COST SUM AMOUNT]-[SALES BUDGET]
ie Instead of the present Sales Budget -215.5 shown in the report, it should be
[-1*49730]-[215.5] which equals to -49945.5
Change2
-----------
HOwever "Turnover sum" now showing as -215.5 which is the original "Sales Budget" should be shown as -215.5 itself.
The trick is if i accompolish Change1, then "Turnover sum" should be shown as -49945.5
Change3
-----------
"Grand Total" which is now showing as 49514.5 (Turnover+Cost) should also be shown as the original Sales Budget whcih is -215.5
Though its shown that the report picks data from table its actually from a query which i converted as a Table for the ease of posting to the discussion.
I tried to convince my client that the report gets the data as a result of grouping and summing, but in vein.
Is there any way to do this? Any ideas or suggestions will be highly appreciated.
Regards,
Charley
