I am creating report where I need to random select records to be auditted at a group level. I am generating the random number and creating a integer from it for selection purposes with out problem. When I try to use the integer to select which records to select within the group to be auditted, the random number is being re-generated and a new integer value is being created. Group level calcs done thru formulas.
For example, at group level;
Random Number generated is 0.72 The integer created is 7.
at Detail level;
the 7th record of detail is not marked.
I found that the integer value (formula) created at group level changes because the formula that creates it is tied to the random number formula which changes value each time indirectly accessed.
Does anyone have any suggestions as to how I could lock the group level formulas so I can use them in the record selection process?
Thanks in advance
edchad5533
IP Logged
