"Formatting page, press ctrl+Break to stop"

[Lmens]

Hello,
I have a report based on a UNION query. The report has DSum() and DLookup() functions. The query works fine, but when I run the report it just hangs on "Formatting Page press Ctrl + Break to stop". Cheers for any help!Thank you.

 

[boblarson]

You just have to wait long enough. Putting a bunch of domain aggregates and then into a union query is sure enough to slow your stuff down to breakneck "snail speed." Especially if you have any code, groupings, etc. on the report.

 

[Lmens]

Thank you Bob.