Beat me to it Colin, was just about to put ink on email
'ow's the rugby going? damn Eye-rish Hope everything is going well over your side. Bye Brian _____ From: [email protected] [mailto:[email protected]] On Behalf Of Colin Roberts Sent: Wednesday, 21 September 2011 3:48 PM To: [email protected] Subject: Re: [Dataperf] Totalling Report Variables Hi again, Before someone replies to the previous email, I've actually got this working by creating a separate field in the items panels to capture the discounted amount (or the non-discounted amount for the items not discounted) by using the "Store report variable in Field" and then running "Keep a total" on that field which stores the Total in a newly created field in the Header page. >From that total I can then print the total on the Quotation. I had thought this was going to be a bit unwieldy - but it's actually worked out quite well. The report can be run multiple times and the figures from the last time the report is run are showing for both the items and the total in their respective panels and the Orig figures are available as well. So unless there's a real simply way of doing this within just the report itself, that I've overlooked, I think I'm all OK Cheers Colin ----- Original Message ----- From: Colin Roberts <mailto:[email protected]> To: [email protected] Sent: Wednesday, September 21, 2011 2:14 PM Subject: [Dataperf] Totalling Report Variables 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
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
