cancel
Showing results for 
Search instead for 
Did you mean: 

multiple data with multiple groups in crystal report

Former Member
0 Kudos

I would like to best describe my problem with a simple graphical representation because I may not convey my question very well.

I have a stored procedure that contains data like this

960528011.961.951.961.951.96960528011.961.951.961.951.96

The 1st data is called the header, while the numbers are different data from a table. If I have this query

select a as header,1,2,3,4,5,6,7,8,9,a,b,c,d,e where goal =@goal

where goal could be something like this

select a as header,1,2,3,4,5,6,7,8,9,a,b,c,d,e where goal ='mem'

which may then output the data I illustrated earlier.

I would like to ask, how could i present in crystal reports data like this


1007576|1007577
-----------------
1.780|1.780
1.785|1.786
1.790|1.780
1.791|1.785
1.772|1.785
1.771|1.786
1.770|1.772
1.775|1.788
1.785|1.790
1.790|1.778
1.786|1.800
1.780|1.800
1.772|1.770
1.775|1.775
1.780|1.800

PS. Please do not mind if the data is not equal, I really names the columns as header,1,2,3,4,..

I forgot to mention the things I did before posting this question.

What I did:

I created a nested group, and put it in details section. and I have currently succeeded in presenting data like this

1007576|
---------
1.780|
1.785|
1.790|
1.791|
1.772|
1.771|
1.770|
1.775|
1.785|
1.790|
1.786|
1.780|
1.772|
1.775|
1.780|

However, as you may know, the other data involved is presented in another page.

Former Member
0 Kudos

Well, I just found out multiple columns, how can I set crystal report to add another column on each different group header?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I did use multiple columns, to achieve my preferred result, I have to adjust the length of the section which became the column.

Answers (0)