Hi , I have selected some records from Database from some tables .
I want to convert the row data into column data .
eg.
I have selected the following records
Col CUST_ID PLAN_NAME PLAN_JURIS
values ABC 100 minutes Domestic
ABC 500 minutes International.
I want to display in the report , something like this
Cust ID Domestic plan name , International plan name
ABC 100 minutes 500 minutes.
How can I achieve this , In the dataprovider I have 2 rows which I want to display as columns based on value of a field (PLAN_JURIS). I have defined 2 new variables , but the problem is that the values of International name will be NULL when the Plan_Juris is “Domestic” , still the data gets displayed in 2 different rows.
Thanks
jatinr (BOB member since 2004-05-27)