Columns in Crystal

hey

is it possible to create columns under crystal ... so instead of the values going vertically, for them go to horizontally ...

eg. when you put the value 'icecream'

it is going to show you all the possible icecream types

eg:
vanilla
chocolate
strawberry
etc

now would you be able to show them like this :

vanilla chocalate strawberry etc .....Even I would like to know if it is possible, right now I m using temp tables to achieve this.|||hey

well i have found a way that it can be done. under the details section in crystal, select 'Format with Multiple Columns'. tt should display the values going horizontally rather than vertically. but there are still some issues outstanding like formatting of the actual values. you do not seem to be able to move the field after you have selected the 'Format with Multiple Column'.

hope it helps.

cheers

milos|||Hey

yes its me again ... Well there is a better way than the one described previously.

By Inserting a Cross-Tab, you have the option of selecting values to show as Columns and Rows. Its a VERY useful feature for those who need to add columns in their reports.

Any questions, feel free to ask ...

Cheers

Milos