Crystal 9 crosstab export to excel (peoplesoft 8.9)

Hi

We are on Crystal 9 (9.2). I am running the report from PeopleSoft 8.9 (People Tools 8.46).

My crystal uses crosstab. When I run the report online (peoplesoft) choosing the output option 'xls', report is generated with the following formatting issues. Please help me if you figured this out already.

1) Report column width is too big. How to reduce it? Same problem with Row height.

2) The label 'Total' for each group is displayed in the column next to it. I want to print this label in the same column.

3) Row headings are repeated on every page. But they are diplayed after one row of data. Is there any way to suppress these two headings that are displayed through out the report.

4) If I have a 3 columns under a comomn group name and if one of those columns has no data, is there a way to suppress that column? Or is there a way to keep the column headers as in their place?

5) column data spans in multiple columns. How do i keep them in one column?

Your help is greatly appreciated.

Thanks
Sreedevihi,

Do u have any idea about how we can import data's from Excel Pivot table to crystal report (cross-tabs).

Thanks|||Sreedevi, read them in CR help file
Also read
http://support.businessobjects.com/