Click here to Skip to main content
15,916,462 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a table used to store the id and dates as:

group  id       date
--------------------------
  1     1     2013-01-05
  1     2     2013-01-06
  1     3     2013-01-07
  1     4     2013-01-08
  2     3     2013-01-06
  2     6     2013-01-09


I need this data to put into crystal reports horizontally as:

group: 1

    1              2              3             4
2013-01-05    2013-01-06     2013-01-07    2013-01-08


The line stating group:1 is in header section.
The line stating dates and id is in details section.


How to achieve this ? Urgent please help.
Posted

1 solution

I think its not a good idea to display the data in horizantal row as the data is not constant.
For instance, you are displaying four columns if the columns exceeds then it will come to another line which is not a proper method.

You can show the data as follows:

Group : 1
1 2013-01-05
2 2013-01-06
3 2013-01-07
4 2013-01-08
.
.
.
n m
 
Share this answer
 
Comments
Maciej Los 12-Feb-13 6:45am    
Good answer, +5!
Anaya Upadhyay 14-Feb-13 0:40am    
But i needed it that way... any help will be appreciated.

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