Columns get shifted in  Excel file exported from a ASP Page using  Crystal Report 9

Posted on 2006-05-24
Last Modified: 2008-03-17
In my ASP application there is a provision for PDF and Excel File Export. This is done with the help of Crystal Report 9. I am Using the same Crystal report file for both PDF export and Excel Export. In PDF export it works fine. But in Excel export the format of columns  get   changed and data comes in improper colums, and it is not same as PDF File. What may be the Problem??.  
Question by:winsoftech
    LVL 77

    Accepted Solution

    Hi winsoftech,
    I guess it's the same problem that everybody else has with exporting to XL from CR.(:-)

    I don't know anything about ASP and CR but in the CR UI there is an option 'Excel (Extended) ' in the export formats; this usually produces a slightly better result than the plain Excel option, and there might be (don't have V9 here at the moment)  a 'Data Only' option, which is OK  for creating a straight rows and columns  output but has no formatting.
    LVL 16

    Assisted Solution

    There is a way to format a CR to export perfectly to excel.  Here are a list of things I do.

    1.  Make sure that all columns are the same width.
    2. Make sure that there is no more than the very minimum space between the cells.  Typically what I see in development is that the columns are just place on the report and expanded to the full lenght of the column.  You do not need to do this if it is going into excel and you are worried about space.  
    3.  If you require a space between two column than apply the following. For CR 9 or low: add a text box>type in the word "space"> then right click>go to the general tab>click on suppress. For CRXI: Insert a blank text box.  
    4. Make sure that everything is left justified.  You may need to modify a column to right but if the above is set up correctly you should not have to worry about this.

    Again the key to excel is everything must match up.  I have found that organizing the report like things helps the application understand where to put the data.

    Hope this helps.
    LVL 100

    Assisted Solution

    To expand on the previous comments, here is a document from Crystal with help on how to format a report for exporting to Excel.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    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. …
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now