Results 1 to 9 of 9

Thread: Import data into excel from crystal reports

  1. #1
    Seeker hcd's Avatar
    Join Date
    Nov 2018
    Posts
    5
    Articles
    0
    Excel Version
    2013

    Import data into excel from crystal reports



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am importing crystal reports data into excel 2013 spreadsheet. In crystal report I have 'sum' subtotal, and total formulas. When I import into Excel, all those total formulas turns into fixed numbers.

    I would like to import the data as is with formulas.
    Can you I get some help to do this please. Thank you.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,051
    Articles
    0
    Excel Version
    Office 365 Subscription
    Can you attach a sample crystal report file?
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker hcd's Avatar
    Join Date
    Nov 2018
    Posts
    5
    Articles
    0
    Excel Version
    2013

    Import data into excel from crystal reports

    When I tried to upload, it is giving me err msg. saying invalid file, though it is crystal report file.

    sales-report.pdf

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,051
    Articles
    0
    Excel Version
    Office 365 Subscription
    I can't test a PDF. Please upload the .csv file - if necessary, change the file extension to .xls just to get it uploaded.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Seeker hcd's Avatar
    Join Date
    Nov 2018
    Posts
    5
    Articles
    0
    Excel Version
    2013

    Import data into excel from crystal reports

    Thank you for your time. I zipped crystal file, hope this helps.
    Attached Files Attached Files

  6. #6
    Seeker hcd's Avatar
    Join Date
    Nov 2018
    Posts
    5
    Articles
    0
    Excel Version
    2013
    I did this with Crystal Reports version 11.5

    I what I am looking for (exporting with formulas),
    Is latest version exporting with formulas ?
    Thanks

  7. #7
    Acolyte alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    39
    Articles
    0
    Excel Version
    2016
    I am unable to open a .rpt file. I have not worked with Crystal for many years, but I recall that you can export a report as an excel file. Is this not an option any longer?

    Here is a tutorial on how to export as a .csv file which is readable by Excel

    https://www.tutorialspoint.com/cryst...ort_to_csv.htm
    Last edited by alansidman; 2018-11-08 at 05:18 PM.

  8. #8
    Seeker hcd's Avatar
    Join Date
    Nov 2018
    Posts
    5
    Articles
    0
    Excel Version
    2013
    Yes, crystal exports to excel, csv, etc.. Since years this option did not changed.
    I am trying to export with formulas as is from crystal to excel.

    Example, if I have @sum(c5.c20) in crystal, want to see same @sum(c5.c20) in excel aslo,
    after importing into excel.

  9. #9
    Acolyte alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    39
    Articles
    0
    Excel Version
    2016
    I believe that you will need to export from Crystal to Excel as an excel sheet. This will allow the reports to maintain the formulas. If you export as a .pdf or as a Crystal .rpt you will be stuck with no formulas but fixed data. This is the way Crystal has designed its reports.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •