I need to display data in table like format, in 4* 10 table format, so total 40 field need to be shown.

In my datasource, there are 10row * 4 columns data return, each row have day, month, year, minutes columns, and each row represent one id(id1->id10).

 

I had draw the table using line tool in crystal report, the problem now is how should i design my report to create only one data source, but display all data? shuld i use any select expert? i know i can create 10 datasource in this case:

select day, month, year, minutes from tbl where id = 1,  

select day, month, year, minutes from tbl where id = 2,

select day, month, year, minutes from tbl where id = 3,

select day, month, year, minutes from tbl where id = 4,

.

.

.

.

 

select day, month, year, minutes from tbl where id = 10

 

which i dont think is a good idea.

Anyone can help me? Your comments is highly appreciated.:)

 

Appreciate your help.