I've got a main query that captures much data, including a case number and a person name. After printing one page with all the data for each person-case number pair, I want to print a summary list of eacy case number and the related person's name. Can I capture the number and the name in a subdataset that the summary will use to produce the list? I can execute the query a second time but I'm trying to make the report faster by executing the query only once.
1 Answer:
Posted on June 10, 2013 at 11:30pm
Simply place a list element in the summary section of your report. Use the main report dataset as input for this list, the query won´t be executed twice.
Cheers, Thomas
