View Full Version : records grouping in a report


gisash1
08-31-2004, 11:35 AM
I have a table like this:
___1___________2____
1020-10 green
1020-20 green
1020-30 green
1030-20 red
1030-40 red
ls5060-60 brown
ls5060-80 brown

in the report it looks absolutely the same but I need to group records by field 2 and put a deviding line or just a space between those groups. Should be like this:

___1___________2____
1020-10 green
1020-20 green
1020-30 green

1030-20 red
1030-40 red

ls5060-60 brown
ls5060-80 brown

does anybody know how to do that?

Thank you in advance

cstahlberg
08-31-2004, 12:07 PM
When you set up the report in the wizard, make sure you include field 2 as the group level. The report wizard will set everything up for you. Then when you get to the actual report, drag the textbox for field 2 from the portion of the form labelled 'Field 2 header' and put it into the form detail. You can draw a line or whatever in the 'Field 2 header' - this will be the break you wan tin the report.

gisash1
08-31-2004, 12:11 PM
Got it! Thanks a lot