Go Premium for a chance to win a PS4. Enter to Win


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
  • 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Loops Section Overview
Suggested Courses
Course of the Month10 days, 3 hours left to enroll

927 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