Skip to Content
0
Former Member
Jul 02, 2007 at 05:30 AM

Divide column data .....

20 Views

Post Author: achaithanya

CA Forum: General

I'm getting data from actuate stored procedure and the whole data is in single column.How do i split it into different and display in my report.

Sample data is shown here

How i get it from Stored procedure.

A

a

b

c

d

e

1/2/07

1

2

3

4

5

1/3/07

5

8

3

2

4

1/4/07

...........

How i should display it is

A a b c d e Total Average

1/2/07 1 2 3 4 5 15 3

1/3/07 5 8 3 2 4 22 4.4

1/4/07 .....................................

......................................

Total ....................................................

Average ....................................................

This is how i need to display in my report and i have one more issue this should come in single page and in next page u need to get data from B.

1st page data is A

2nd page data is B this fileds u have in A is 5 but it may differ in B.

So now how to split this data and display in this format.....