Change column to row in report for detail section only

[Sandrine]

Hello,

I have a subdatasheet in a table with items (A,B,C) for specific ITEM. I am
displaying the subdatasheet information in a report like this.

ITEM 1 A
B
C

ITEM2 A
ITEM3 A
B
C
E
F
G
H
What should I do to have the report display the information as below
ITEM1 A B C
ITEM2 A
ITEM3 A B C
D E F
G H
In design view, I have a separate header and detail sections for the
subdatasheet info. I changed the NewRowOrColumn in the detail section
property window to different settings but it does give me the result I want.

Thank you for your help.
Sandrine

SANDRINE

 

[Duane Hookom]

I would build a main report based on the unique ITEMs and a multi-column
subreport to display the A, B, C,...

 

[Sandrine]

THANKS A LOT! IT WORKS.