Converting Columns into Rows

May 31, 2007, 07:54 AM

Hi All,

i have 10 columns iwant put alll these 10 columns in to 2 columns i there any workaround please let me know.

thanks,
Kalyan

Thanks,
Kalyan.S
------------------------------------
WebFOCUS 7.1.4, Win XP SP2,
Oracle8i.
------------------------------------

May 31, 2007, 11:34 AM

Jason K.

I don't understand this question.

I think what you're looking for may be a SQL Decode or CASE statement.

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

May 31, 2007, 11:36 AM

Darin Lee

sounds like you're just converting columns to columns. try using a DEFINE. Otherwise, try the McGyver technique or one of the other solutions which have been posted numerous times. You can probably do a find on "columns to rows" and get a bunch of hits.

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

May 31, 2007, 12:57 PM

kalyanswarna

Hi i dont want to convert columns to columns.
i will explain clearly,
TABLE FILE ABCD
PRINT
ABC
COMPUTE aCTUAL/D12=....;
COMPUTE ASD/D12 = ;
COMPUTE DDD/D12=;
BBC
COMPUTE XCTUAL/D12=....;
COMPUTE AXD/D12 = ;
COMPUTE XDD/D12=;
aCROSS VVVV
END

THIS IS THE REPORT I WANT TO ARRANGE THE ABOVE REPORT TO BE LIKE THIS
ACROSS VALUES
------------
ABC ACTUAL 222 222 222
ASD 342 11 11
DDD 234 123 11
BBC XCTUAL 112 332 33
AXD 22 22 35
XXD 121 231 34

I WANT THE OUTPUT LIKE ABOVE.

Thanks,
Kalyan.S
------------------------------------
WebFOCUS 7.1.4, Win XP SP2,
Oracle8i.
------------------------------------