firstly can i say thank you for all your help on previous questions! i have another basic report basically showing the records for a particular date and another"boolean" option. i have set the report to run for these criteria, and count the lines. what would be useful if i could also include in the report are the total number of records for that date (ie regardless of whether they are ticked or not) so that i can produce a % eg : for date 06/02/04 i have 19 “ticked” records overall there are 97 records giving a % of 20% (very approx!) i dont want the report to show all items, only those which are ticked. i was thinking along the CurrReport ShowOutput etc etc, but not sure if this is the correct way! Again thanks to all!
You could define a new Record variable pointing to the same table as your Report’s DataItem. Then, in the OnPreReport trigger, you could do: NewRec.COPY(DataItemRec); NewRec.SETRANGE("Boolean Field"); This will make your NewRec variable take exactly the same filters as your DataItem but clearing the filter on the Boolean field. For the ratio calculation simply design a control with a SourceExpr of COUNT / NewRec.COUNT.