Skip to Content
0

multiple data with multiple groups in crystal report

May 03, 2017 at 09:23 AM

36

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
Former Member

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Jun 05, 2017 at 08:42 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded