cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Using Excel as Datasource in Crystal Reports 8.5

Go to solution
Former Member

on ‎03-11-2009 2:55 PM

0 Kudos

I have never used Excel as a source for Crystal data and I am having a bit of an issue I believe. I have an Excel file on my desktop that I am using as the datasource. Eventually it will be out on a network drive. I set up all my reports as blank reports so I do that. When it brings up the Data Explorer pop up I choose ODBC ---> then Excel Files and choose the file. I then add the sheet to the report, close the data explorer window and start designing my report. I drag the fields I want on there, but when I go and preview I don't see any data at all. I have also tried it with the Report Wizard, no go there either. Is there something special I need to get the data to show up on there? Does it need to be formatted a certain way? Is it just easier to convert it over to an Access database? Any help anyone could suggest would be wonderful!

Thanks

Jami Benson

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎03-11-2009 5:40 PM
0 Kudos

Hi Jami,

Try to create report using report wizard, while doing it, select on Create New Connection under new connection select Access / Excel (DAO), now choose your excel file and select file type as excel. Now you can see sheet1,sheet2,sheet3. Select the appropriate one and place the fields on your report.

Thanks,

Sastry

Show replies
Show replies
Former Member
‎03-11-2009 5:59 PM
0 Kudos

Hi Sastry. Thanks for responding. I have tried it that way as well. The headings show up, but not the data. Is there something within the Excel sheet itself that could be causing it? I would be more than glad to post the Sheet if it would be of any assistance.

Many Thanks!

Jami

Former Member
‎03-11-2009 6:03 PM
0 Kudos

I just checked something out and I figured out what I was doing wrong myself. It would seem that I was choosing the wrong sheet. One of the sheets, sheet 1, appears twice in the list. Once with the name of the whole spreadsheet, and once as just sheet 1. I was using the one with the name. It has the headings just no data. The other has the data and headings, just no name. Once I choose it, all seems to be well. '

Jami

Former Member
‎03-11-2009 6:05 PM
0 Kudos

Good to see your post..

Thanks,

Sastry

Answers (0)

Ask a Question