Converting rows to column in a Report 1

[spattewar]

Hi,

Thanks in advance for your help.

I have data in the following format in a table
No SecID Cur MarketValue
1 abcd USD 100
2 abcd EUR 150

But on the Report I want the fields to look like

SecID Cur(local) Cur(Base) MV(Local) MV(Base)
abcd USD EUR 100 150

Is there a way to approach such scenario. Like building 2 queries with different conditions...or something.

Thanks again.

$wapnil

 

[spattewar]

Hello.

Anyone to help.

Thanks!
$wapnil

 

[blom0344]

I'd say, 2 queries (one for the USD currency and another for the EUR currency) and join them on the SecID..

Ties Blom

 

[spattewar]

Thanks for the input Ties. It is little cumbersome but works as expected!