Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Cross tab formatting issues

Posted on 2017-09-09
Low Priority
Last Modified: 2017-09-10
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
Question by:Sailee Govekar
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Assisted Solution

by:Raghavendra Hullur
Raghavendra Hullur earned 1000 total points
ID: 42287512
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.

Author Comment

by:Sailee Govekar
ID: 42287514

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.

Accepted Solution

Raghavendra Hullur earned 1000 total points
ID: 42288768
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.

Author Comment

by:Sailee Govekar
ID: 42288777

Thank you for your explanation. It helped in better understanding.

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question