Vtg 5 PO form problem

At 07:03 PM 12/5/2001, you wrote:
>We had been using this form for about a month and just discovered that adding
>this sort causes the @Total field to not include the Misc. Charges. Since the
>calculation is lengthy and I didn't have time to debug, I've changed it
>back to
>the old, confusing way but at least we now have everything included in the

Cool! The sort is to blame! Thanks, Mike and Olwyn.

I had added a sort on porel.DueDate in V4 to correct the out of sequence
releases everyone gripes about. For some reason, removing the sort made
the total correct again.

A couple of the calculated fields the total uses have a
WhilePrintingRecords in them. From what the help file says, this is
supposed to cause the field to be evaluated for every record, even if the
calculated field does not print on the report? Maybe since the sort
requires an extra pass through the data before printing, it throws off the
logic? I don't know enough about Crystal to say if it's a bug or a
feature. If Troy or any other Crystal experts know, I'd be curious to hear.

As for the releases... they're now printing in correct date order even
without the sort (this is 5.00.332) Maybe they fixed Vantage so it sorts
them prior to exporting?

-Wayne
Must have deleted the original message but since I just encountered this
yesterday thought I would respond.

I recently modified POFORM.rpt (we're still on version 4.0) to sort the releases
by release date instead of the (yes, very confusing) RelNum.

We had been using this form for about a month and just discovered that adding
this sort causes the @Total field to not include the Misc. Charges. Since the
calculation is lengthy and I didn't have time to debug, I've changed it back to
the old, confusing way but at least we now have everything included in the
total.

Haven't had a chance to review further but when I do will forward a solution to
the group...that is unless someone beats me to it.

Mike Lowe
Connor Manufacturing Services

____________________Reply Separator____________________
Subject: RE: [Vantage] Vtg 5 PO form problem
Author: <vantage@yahoogroups.com>
Date: 12/5/2001 11:38 PM

Wayne

#1 Our release 4 standard PO form (UK) has always had these problems with
the miscellaneous charges not being added into the total - most people seem
to use modified forms so are possibly not aware that the standard is
incorrect. We only use the standard form sets so have had to have a version
modified by Ryan in support to correct this - he could maybe help you with a
fix for this one.

#2 We are also still waiting for a fix to the releases being out of
sequence - apparently when support checked they are not sorted at all
(neither release sequence or date sequence) so can appear in entirely random
order when printing. Our suppliers have found it confusing and have
complained that they may miss required dates. Support have tried several
solutions - sorting the releases by date would seem to give a fix but when
they tried this we lost the printed data relating to job numbers for sub
contract purchases to a job so had to revert back to the incorrect version
as the lesser of 2 evils!!

If anyone has a "standard" UK form with all these aspects fixed we would be
grateful to have a copy - it has been going on for a while now. Also would
be interested to know if these issues have been fixed in 5.0 or 5.1.

Many thanks

Olwyn Emery

Hallam Plastics
olwyn@...



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/