Skip to Content
avatar image
Former Member

Crystal report export issue

Hi, there.

I write this email to get some pieces of advice for my issue.

I use Crystal report (I did not purchase, I use it as bundle version) in VisualStudio 2008.

When I export the data with “Excel Data Only” format like attachment file. (please refer to the link here cusersf608261desktopattachment.png), and created excel file displays last line of header part even though there are more lines!!!

(Please refer to figure 2,4)

** Since it is dummy data, masking process is not done. The language is Korean.

As you can see, there is only last line shows with a few information.

You can see more lines at figure 2.

I want all data in red box in third page. Please give me some advise to solve this issueT___T

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 21, 2017 at 09:10 AM

    Its been my experience that if you use Export - Excel data only That is what happens. It compresses header into a single row.

    If you want to use data only then you must design your report accordingly.

    If you want to see all header info then you must use standard export. However, Crystal exporting to excel is quite precise.

    All field cells must be vertically aligned (otherwise blank columns will appear), I use guide lines and make sure they are all snapped to relevant guides, all cells must be aligned horizontally and the same size, you must not have any white space or additional blank rows will be introduced.


    Add comment
    10|10000 characters needed characters exceeded

  • Mar 21, 2017 at 01:58 PM

    There may be ways around this. Here are a couple of options to try:

    1. If you're putting the labels in the page header, try turning off "Simplify Page Headers and Footers" when you export. This may or may not work.

    2. Create an outer group (Group1) on some data that only appears once on the report. Move all of your header info into that group header instead of using the page header. For the group, turn on "Repeat Header on Every Page".


    Add comment
    10|10000 characters needed characters exceeded