Hi all, and thanks for the nudge Colin.
No words can describe what this last year has been like. Things appear to be stable now, however it's a bit disheartening driving through the central city and seeing rubble and vacant lots where businesses used to. There was no loss of life by anyone in my immediate family or friends. One of the buildings that got flattened housed a business that we would have been working for had the company not cancelled their contract last year. My staff could have easily been in that building on the day of the quake had it not been cancelled. Every cloud has a silver lining. Colin, I imagine that the few shocks you guys have felt in Auckland were a bit unnerving because it never shakes in Auckland. Minor compared to Chch. But then Chch devastation was minor compared to what Charles felt with the World Trade Centre devastation. I guess it's all relative. Oddly enough was in a data centre on the Feb 22 Quake negotiating rack space for online backup servers, and instantly changed my mind about housing online backups anywhere in the city. 100 meters away buildings were trashed. Opening up a data centre 75 minutes out of Chch. Anyway onwards and upwards. Regards Eric Donn From: [email protected] [mailto:[email protected]] On Behalf Of Colin Roberts Sent: 22 September 2011 17:44 To: [email protected] Subject: [Dataperf] Totalling Report Variables Hi Brian, Yes the Irish game was a bit of a surprise - credit to them though they adopted a very clever game plan. We have the French on Saturday - a replay of the RWC quarters last time when they tipped us out - (not a knockout round this time :-). Business is very quiet but still holding head above water. When the Christchurch rebuild kicks in the Building Industry will probably be the main benefactor of what has been a tragedy for the people of Christchurch . Spending alot of time and for the rest of this year getting the factory ship- shape, to be able to make the most of the opportunity. Rebuild is still in reality another 18 months away before the insurance and finance issues get resolved. The place is still not stable enough (and the liquifaction) to build on. They've had another four so called "after shocks" just today (3.6, 2.7, 3.0, 2.6) had 9 in similar range yesterday and 8 the day before that - 3 of them were 4.2, 4.1, and 4.3. They are a pretty staunch lot down there but must be a nightmare for many of them - just checked they have had 8647 shocks since 4th Sept 2010, 29 over magntude 5, and 903 over 3.5 - that averages over 20 per day in the last 12mths, and no local Rugby World Cup games either as their Stadium was destroyed - you gotta feel for them, just can't imagine what that is like - perhaps Eric can give you all a local perspective. Catch ya Colin ----- Original Message ----- From: Brian Hancock <mailto:[email protected]> To: [email protected] Sent: Wednesday, September 21, 2011 7:31 PM Subject: Re: [Dataperf] Totalling Report Variables 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 ______________________________________________________________________________ This email has been scrubbed for your protection by SMX. For more information visit http://smxemail.com ______________________________________________________________________________
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
