how to print the date in Horizontal way in query................

[Former Member]

Hiu2026u2026

I have created a query using SQVIu2026The output is likeu2026

Zone | Customer Group | Customer Name | Date | Value(Rs)

East | ABC/JPR | ABC pvt ltd | 01.08.2011 | 50,000

West | LMN/Delhi | LMN pvt ltd | 02.08.2011 | 1, 50,000

South | PQR/Haryana | PQR auto sales p l | 03.08.2011 | 1,00,000

My problem is i have to print the date in the format like

Zone | Customer Group | Customer Name | 01.08.2011 | 02.08.2011 | 03.08.11 | 04.08.2011 |..............31.08.2011|

East | ABC/JPR | ABC pvt ltd | 50000 | 150000 | 100000 | | |

Thanks&Regards,

Pranitha.

[raviahuja]

Hi,

I don't think you can achieve this through SQVI. But you can download your output in excel and can then convert into the required format using formulas like convert rows to columns.

Thanks.

Ravi

[Former Member]

Hi Pranita,

You could try with logic:

CONCATENATE LINES OF itab INTO warea SEPARATED BY '|'.

BR

Dep

[Former Member]

Hi

Go through the below link

http://help.sap.com/saphelp_sm32/helpdata/en/d2/cb41d4455611d189710000e8322d00/frameset.htm

Shiva