Show rows as columns

[syncdba]

Hi All,

I'm trying to create a report in CRXI from table as
Name value
apps time
apps Browser_rd
apps Browser_st
MD1 Browser_rd
MD1 Time
MD1 Browser_st
MD3 Time
MD3 RC3

I want to report to show rows as columns eg:
apps Time Browser_rd Browser_st
MD1 Browser_rd Time Time
MD3 Time RC3

and the number of rows for each field varies. Like for apps number of rows will be 10 or 20...

Any Help!
Thanks.

 

[Bestbegood]

I have printed columns by rows by using Concatenate like
Global StringVar S1;

S1 := S1 + Name +" "+ Browser_rd + Browser_st
+ chr(13)
Else
S1 := S1 + "";

the chr(13) tells it to end the row and start a new one

the code will probably have to be played with but I have printed multiple colummns as row with the same idea
make sure your formula is formatted to can grow so it can expand and show you all the records.

 

[syncdba]

Thanks Bestbegood It gives me an idea. But I'm trying to make rows as columns so that I can export them to excel.