Report multiple headings per column

[Edgarr8]

Hi,
Is there any way i can create a report, in which the heading appear under the same group?


for example: Josh, Joey, Mary, Aaron all sell Product A on Oct 15,

and Paul, Frank, Joey sell Product B on Oct 18.

Is there any way i can get a report with a group by date, *Then a Heading listing all the names for that day, and finally in the details the product they sold?


Date: Oct 15

Reps: Josh, Joey, Mary, Aaron

Product: Product A


Date: Oct 18

Reps: Paul, Frank, Joey

Product: Product B

Thank you

 

[Kryst51]

This should be easy to do in the design view of your report, right click anywhere and select sorting and grouping. From there you can add headers for each group and sort them too.

 

[Edgarr8]

Well I have done that, but it doesnt show my heading the way i want it it does it like this

Date: Oct 15

Rep: Josh

Product: Product A

Date: Oct 15

Rep: Joey

Product: Product A

Date: Oct 15

Rep: Frank

Product: Product A

and so on, but it does not do the joey, frank, etc in the grouping

 

[Kryst51]

Is there something you can post that we can look at?