Problem in creating matrix query in the report.

[Iloveoracle]

Hi all,


Depencing on the parameters I have to display the tables in the report.Here table columns are not fixed.Some parameter are having less number of tables with less number of coulmns ,but some are having more no. of tables with more no.of coulns .So i wrote matrix query. if the length of the cell value in the matrix is small then the columns are coming verically ,it means there is enough space.If the cell value is too big then ,it has to parse the string ,if so we will get table with all coulmns in order.But in my case some of the tables are having big strings in the matrix cell ,thatswhy first column is coming with all column1 data then next column is coming down to the first coulmn with column2 data.then 3rd column is down to the 2nd coulmn.etc., Even if i make the repeating frame accross/down or accros its not working.Is there any way to parse the string in the row of the table ,then we can get columns next to each other.
Please help me.

Thanks
gp

 

[nagornyi]

Try setting fixed horizontal and variable vertical elasticity for the column fields.

 

[Iloveoracle]

hi,

I changed horizontal and verical elasticity for the column ,but problem is if horizontal is fxed then,the string not looks nice.It wraps too much.Even outer frame and repeating frames are having either variable or expend elasticity,still the table columns are not expanding .

Thanks
Praveena

 

[boniblue]

Hi,
You can adjust how much the field wraps horizontally by adjusting the size of the field in the layout model...the larger the field is in the layout model the less wrapping there will be...

hth,
B
)