[Webinar] Streamline your web hosting managementRegister Today


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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

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

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. …
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.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

591 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