Divide column data .....

[Former Member]

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.....

[Former Member]

Post Author: achaithanya

CA Forum: General

Hi,

Data what i am getting is Dynamic and it varies from Page to page.I need to even fit the data to that particular page.The data is coming from Single column.

I have done the things what you have mentioned above still i get output like this

eg: 1st Page

A a b c d e

1/2/07 1 2 3 4 5

1/3/07 5 8 3 2 4

2nd Page i get

B y k l 1/2/07 1

2 3 1/3/07 5 8 9

1/4/07 3 4 7

Thanks

Chaithanya.

[Former Member]

Post Author: V361

CA Forum: General

You may want to try inserting a section, you can format the section differently that may resolve the issue.

[Former Member]

Post Author: achaithanya

CA Forum: General

Hi,

Thank you for your suggestion it works for me and i have one more problem here that is

for 1st page data is

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 .....................................

for the second page wat i have is

B y k l

1/2/07 1 2 3

1/3/07 5 8 9

1/4/07 3 4 7

this is varying for the 1st line if u set up Width in select expert it is varying for each page how to over come this.

1st page is ok.i'm getting it like this in 2nd page if i set width and Width in Details,Layout tab

B y k l 1/2/07 1

2 3 1/3/07 5 8 9

1/4/07 3 4 7

This is why Bcoz i have set width in deatils section for 1st page so it is set to 6 rows.But how i need it is it should vary from page to page.

[Former Member]

Post Author: V361

CA Forum: General

Oh, Sorry, as far as the second question, do you have something you could group on, once you get the groups set up you can force page breaks using the groups.

[Former Member]

Post Author: V361

CA Forum: General

go to details section, select section expert, look for format with multiple columns, check that box, at the top "tab list" you should see layout pop up, click on that tab, you can setup the size of the box, the direction of the layout, and format groups with multiple columns if needed.