July 23, 200619 yr Newbies I am trying to create a report that has subheadings based on a particular field, that field only prints once--not for each record, but several different values can be on a page. Each record has several fields including FIELD1. I want a report that looks like: HEADER ---start body--- FIELD1=A Record with FIELD1=A Record with FIELD1=A . . . FIELD1=B Record with FIELD1=B Record with FIELD1=B . . . etc. I can do it if FIELD1 is allowed to only have one value per page by setting up a sub-summary break, but I can't figure out how to do it if I have more than one value of FIELD1 per page. I don't want FIELD1 to print for each record--only once as a heading. Any thoughts?
July 23, 200619 yr Drag the Part button from the left bar while in layout mode --> place it above or within the body. Then, when a dialog appears asking you to specify the type of part you want it to be, choose "Sub-summary when sorted by" and choose field1 to be the field. Place field 1 in your new subsummary part, the rest of your details in the body, then sort by Field1.
Create an account or sign in to comment