Import data into excel from crystal reports

H

hcd

New member

Joined

Nov 8, 2018

Messages

5

Reaction score

0

Points

0

Excel Version(s)

2013

• Nov 8, 2018

• #1

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.

 

AliGW

Administrator

Joined

Nov 8, 2015

Messages

1,843

Reaction score

8

Points

38

Location

Ipswich, Suffolk, England

Excel Version(s)

MS 365 (Beta Insider Channel)

• Nov 8, 2018

• #2

Can you attach a sample crystal report file?

 

H

hcd

New member

Joined

Nov 8, 2018

Messages

5

Reaction score

0

Points

0

Excel Version(s)

2013

• Nov 8, 2018

• #3

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

View attachment sales-report.pdf

 

AliGW

Administrator

Joined

Nov 8, 2015

Messages

1,843

Reaction score

8

Points

38

Location

Ipswich, Suffolk, England

Excel Version(s)

MS 365 (Beta Insider Channel)

• Nov 8, 2018

• #4

I can't test a PDF. Please upload the .csv file - if necessary, change the file extension to .xls just to get it uploaded.

 

H

hcd

New member

Joined

Nov 8, 2018

Messages

5

Reaction score

0

Points

0

Excel Version(s)

2013

• Nov 8, 2018

• #5

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

 

Attachments

• sales-report.zip

  11.8 KB · Views: 22

H

hcd

New member

Joined

Nov 8, 2018

Messages

5

Reaction score

0

Points

0

Excel Version(s)

2013

• Nov 8, 2018

• #6

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

 

alansidman

Member

Joined

Oct 1, 2018

Messages

402

Reaction score

6

Points

18

Location

Steamboat Springs

Excel Version(s)

O365

• Nov 8, 2018

• #7

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/crystal_reports/data_export_to_csv.htm

 

Last edited: Nov 8, 2018

H

hcd

New member

Joined

Nov 8, 2018

Messages

5

Reaction score

0

Points

0

Excel Version(s)

2013

• Nov 8, 2018

• #8

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.

 

alansidman

Member

Joined

Oct 1, 2018

Messages

402

Reaction score

6

Points

18

Location

Steamboat Springs

Excel Version(s)

O365

• Nov 8, 2018

• #9

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.