Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting Cross Tab to Excel

Status
Not open for further replies.

052780

Programmer
Nov 5, 2007
17
0
0
PH
Hi,

I have a cross tab report that I want to export to excel. During export, if the horizontal page expands to multiple pages, I always get this extra blank column. Is there a way to remove this?

I'm using CR XI R2. Thank you :)
 
Any update, did u solved this problem,
any suggetions
Even now I am having same problem, user should delete rows and column lines from excel as I am suppresing the summary Total
Any help apprecaited

Thanks
 
I have used Crosstabs and they never export well to Excel. How are you exporting them, using the Data only option? See if "Maintain Column Alignment", or "Maintain Relative Object position" is checked, in the Excel Format Options window when you go through the exporting process. One of those may be the culprit.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top