Newbies BigTimeDave Posted July 23, 2006 Newbies Posted July 23, 2006 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?
Genx Posted July 23, 2006 Posted July 23, 2006 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.
Newbies BigTimeDave Posted July 23, 2006 Author Newbies Posted July 23, 2006 Thanks, very much! (I should have known that.)
Recommended Posts
This topic is 6699 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now