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
___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