Crystal 9 - Exported to Excel - Filter fails due to inconsistent Cell Sizes

Have specified a Report putting individual fields onto a Report in a 'tabular' type style (this appeared to be the best way to handle other difficulties).
 
In Excel the Filtering fails due to inconsistent Cell Sizes. Obvious differences have been removed, but we still get the same problem.

I will have a good look at this to fix this. If anyone's got some helpful tips as to easiest overcome this type of difficulty that would be appreciated and save me some time.

(The output file is fairly complex and therefore we cannot heavily edit it each time we create it).

Thankyou.
     
TJPRIMEAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wykabryanCommented:
When you say "In excel the filtering fails due to inconsistent cell sizes."  Are you using the auto filter?  This is the problem when the cells are merged together.  This happens when the report is not formatted correctly.  

There are ways to lock a column into place.  I prefer to use the tick method.  In the top rule and side rule you can put little carrots. You want to make sure that every column in ticked in the upper left corner from both the top and side rule.  Then you but the other column up next to it.  In Crystal 9, if you need a blank do an insert text field. Type something in the text field and then suppress it.  Make sure it aligns between the ticks as well.  Attached is an example that will help you understand what I written.  I believe this will take care of your issue.
crystalticks.jpg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
Here is a document that explains how to format the report for easy export to Excel.
http://support.businessobjects.com/communityCS/TechnicalPapers/cr10_export_excel.pdf.asp

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.