asked on

report shifting on page 2 of crosstab

I have a report that is attached that is eliminating the first row description and shifting everything to the right where page two starts. I can't figure out why. I export in Excel 2003 and have tried several options but can't get it to correct so that it displays correctly..

Your help is needed urgently.

Andy
DTI-COMPLAINTREPORT-Boston-Consolida.xls

Mike McCracken

I can't tell very much from the spreadsheet. Can you upload the report file?

mlmcc

spudmcc

ASKER

Here is the actual Report.
DTI-COMPLAINTREPORT-Boston-Consolida.rpt

spudmcc

ASKER

I've attached a report saved with data. The first one I had not. Wasn't sure if this would help more.
DTI-COMPLAINTREPORT-Boston-Consolida.rpt

Mike McCracken

WHat version of Crystal?

What version of Office?

How are you exporting?

I exported it to Excel 2010 from Crystal 2008 and it exported just fine. I don't see your issue.

mlmcc

spudmcc

ASKER

Crystal 2011, Office 2010
I am exporting using Excel (97-2003)

Were you able to see what it was doing on the attachment I originally included (the excel sheet). You could see where Page 2 on Excel kind of shifted to the left and the group description disappeared. It looked perfect on what would be page 1.

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

spudmcc

ASKER

Not sure why this started working but your comments caused me to go back and review the layout and column widths.
This seemed to fix the issue.