Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005

    Unanswered: Group data AFTER formula fields have been calculated

    I'm working with a table of data that is NOT normalized: it is a log file stored as a database table but changing the way data in the table is stored is not an option.

    Before I can group the rows in a way I want, I have to run a few formula fields to derrive certain information for each row. Now my problem is that when I group the rows, I find the results of the formula fields are different (because the order in which the rows appear is different. ie: row A under heading B in the logfile might be displaced to fall under heading C after the rows have been grouped).

    Is there anyway to get Crystal to go through the whole recordset, and calculate all the formula fields, then go back and group the rows?

    Any help much appreciated,

  2. #2
    Join Date
    Jul 2006
    Try putting the Whilereadingrecords; evaluation expression in your formulas.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts