Hi, I have reports that produce quotations. The header page has a "Keep a Total" field. I have been using a Report Variable (RV) with a prompt to discount each item in the report when required, and also apply the same RV to the total so the discounted total is printed at bottom. No data gets updated within the database panels - just the report shows the discounted amounts and the discounted total. Benefit is the the report can be used to generate different quotations offering a different discount structure each time it is run (eg for different customers) and the Data in the database remains as per Original.
We now want to be able to only discount some items within the quotation. That is working OK with individual items - the slightly more complex RV sorts the discounted items from the non discounted items and we are printing the correct amounts against ea item. The problem is being able to get the correct total to the quotation. Obviously the old simple way of applying the same RV discount cannot be applied to the total on the Header page as before. We need to somehow keep a rolling total of the RVs like the count items scenario eg Set rv1 = zero and then RV1 + 1 but this is like a RV1 + RV1 carried from item to item. Is there a way to achieve this without say creating a new field in the items panel (say P3F78) which will hold the discounted/non discounted amounts and then use the RV1 set to zero and RV1 + P3F78 to get the required discounted total I looking to achieve this solely within the report if possible - any suggestions welcome Regards Colin Roberts
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
