Click here to Skip to main content
15,997,487 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I want to create a report with 2 columns and 3 files with option "Format with Multiple Columns" the problem is when grouping by "Id" the "subjects", I get one record(subject) per detail section, what I need is ALL records by ID per detail.

I need something like this:

ID1 ID2
-------- ---------
subject1 subject1
subject2 subject2
.... ....

ID3 ID4
-------- ---------
subject1 subject1
subject2 subject2
.... ....

ID5 ID6
-------- ---------
subject1 subject1
subject2 subject2
.... ....

And what I now get is:

ID1 ID1
-------- ---------
subject1 subject2

ID1
--------
subject3

Thanks!
Rocio(Spain).
Posted
Comments
RDBurmon 31-Jan-12 3:48am    
Could you please share the table structure and data and select query which you have used for this report ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900