Non-MAS tables in crystal reports

[jeanirene]

I have created a calendar report using a technique I found from tek-tips back in 2008.
I have made a date table in excel for the dates and the data is on the sub-reports from MAS 200 tables.

I have everything working in Crystal Reports, but when I loaded it in to MAS for others to use. I receive an error message that tells me it can't find the dates table which I have in the same folder as the report.

I'm not sure what I have to do to the excel table to have mas find it. Anyone have any ideas?

Jeanirene

 

[tmar]

I'm not sure if this will help but years ago when I used Crystal with multiple data sources I used to use MS Access to combine the data sources and run Crystal off of the MS Access database. We were running reports on data in both a SQL database and ODBC connections into a Unix-based system.

So maybe you can put your Excel info into data table in Access. Link Access to the subreport info you need from MAS200 (if that's possible, I know that providex database is a bit weird) and then see if it'll work for you.