Cross tab formatting issues

Can you please suggest me on can grow functionality w.r.t cross tab. For example, if the data in one cell is large, then it gets trimmed off instead of wrapping it and enlarging of cell.
Even while exporting cross tab to excel it's not the exactly what was designed in the crystal report. Any solution to achieve this?
While exporting to excel, I select Following steps to export crystal report cross tab to excel:
  • Export Report
  • Microsoft-Excel (97-2003)
  • In Excel Format Option I select "Show Gridlines" field
PurchasingExportAnalysisTabReport_34.xls
Sailee GovekarStudentAsked:
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.

Raghavendra HullurSoftware DeveloperCommented:
Hi,
In the output you have attached, I don't see any trimming.
And as for as the Excel export type, I think the one you have used (Microsoft-Excel (97-2003)) is the best one as the output data is wrapped to the cell width and not truncated.
Let us know If you still have any queries with regards to this.

And regarding your other query with "Can Grow" option for crosstab fields, as we discussed in other question, "Can Grow" is not supported for Crosstab fields and hence, either we have to adjust the column width to the largest values of a column field or we have to go for a workaround of including a mockup crosstab if feasible, where in we need to ensure there are fixed number of columns as we build the crosstab manually.
Check below link for more details on a mockup crosstab.
http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/10c4c9c3-a275-2b10-bfa6-87b265d5a0d9
1
Sailee GovekarStudentAuthor Commented:
Hi,

In report I have kept extra space for each cell of cross tab so that if data is large then it should be properly displayed in that defined cell.

That's the reason the excel export is looking fine.

In my cross tab, the width of Serial number is 0.5 cm, but when I export the cross tab to the excel, then the width of the serial number is not the same. Extra unwanted width is displayed on the excel export.
0
Raghavendra HullurSoftware DeveloperCommented:
Hi,
There is nothing much content on internet to explain the difference of width of a column in Crystal and Excel as for as crosstab is concerned.
But, what I observed is, the width of non summary columns in crosstab always fixes to the column with more width.
You can try reducing the width of Part Description (2nd column used in crosstab) and then verify the output.
If you increase the width of any non summary column, all other non summary columns will have the width of that field.

In the output shared by you, the width of Part Description more and hence, Row Number and Quantity columns width is aligned to that.

There might be better explanations, but this is what I have observed.
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
Sailee GovekarStudentAuthor Commented:
Hi,

Thank you for your explanation. It helped in better understanding.
1
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.