I've created a sub summary report which from a script finds a subset of 32 records from 20,000 and performs various summary calculations on them. In addition, I have some static pre calculated data which appears on each of the 32 rows coming in from a warehouse table. This report works fine, takes a couple of seconds to load and due to some of the calculations is a little lumpy when scrolling up and down through the 32 records, but it's acceptable.
I've been asked to include a field which would allow end users to exclude a record prior to printing/PDF'ing. My first thought was to simply put a text field with Y/N field on each row with a button script to simply flick between Y and N. After this is set, the user would refresh and an Omit script would remove the N's.
However, the report really goes slow after I change the first Y to N. I get the 'Windows blue circle of doom' when trying to move down the 32 records which previously, before changing the Y to N, I could do easily.
What on earth is FM doing here?!
Before I change the text field, it works fine. After I change the text field, it's stalled and useless.
Any help really appreciated on this one.