Report Format Help? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

Topic

New Reply

The attached DB is in a97 format

Open frm_SBF_PrintCheckDialog and click EOB button

The attached report prints OK with exception of it printing two copies each for two patients who have multiple claims, there should only be one page for both claims.

The test DB is printing 37 EOB’s, I want it to print only 35, see page 5 & 6 and 8 & 9, what do I have to change to print only one page (with both claims) for Renee Beam & Marie Heine

Thanks, John

Reply | Quote

Replies

The design of the report is so convoluted that it’s very difficult for me to understand what it does, but you should either change the record source to a query that groups by the relevant field(s) so that there are no duplicates, or group the report by the relevant field(s) and place the controls in the group header instead of in the detail section.

Reply | Quote

Reworking the query did the trick, thanks for your help

John

Reply | Quote