records grouping in a report (1 Viewer)

[gisash1]

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]

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]

Got it! Thanks a lot