I am a newbie at Crystal reports so be gentle.

 

I am having difficulty with this one darn report. It is actually a financial statement and I need to add a historical performance chart and table to the report.

 

The data exists as an Excel spreadsheet. All the other tables used in the report are SQL database DBF files.

 

Excel has the ability to save as a DBF format so I figured that may be the most efficent way to add the data so I saved them that way. I was able to link the DB, create a subreport with the necessary fields.

 

The problem is, when I run the report, the subreport data is not being populated. It works just fine when I preview the subreport.

 

I was told by some others that have a bit more experience than I that they have had mixed results using Excel spreadsheets but much more consistant results importing the data into an Access DB.

 

Does anyone have any experience similar to what I am trying to acomplish and have some advice or tips???!

 

Thanks in advance!