At 07:03 PM 12/5/2001, you wrote:
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
>We had been using this form for about a month and just discovered that addingCool! The sort is to blame! Thanks, Mike and Olwyn.
>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
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