on 05-03-2017 10:23 AM
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.
I did use multiple columns, to achieve my preferred result, I have to adjust the length of the section which became the column.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.