Is it possible in the design of a report to only look at form instances that are open. If possible I will probably do a first page that shows “open” instances and a second page that shows “closed” instances.
Yes, totally possible you could do it by setting a filter in your datasources (one for ‘stage = closed stagename’ another for ‘stage <> closed stagename) or even run a set filter script on the ‘page is opened’ events for each page
Thanks – one possible problem. I have a variable flag in my forms called “Stage” which basically gets changed as the form goes through its various signing off stages. With hindsight probably a bad choice of naming a variable. Is this likely to cause any conflict?