Can you have more than one Excel data source in one report?

[susiesunshine]

I am trying to create a linked report from 2 excel spreadsheets. When I go into ODBC, Excel, and select my first spreadsheet, I can add it to the report. Crystal doesn't allow me to go back into the Excel selection and pick another. I added the one to Favorites, closed Crystal and reopened, added the other spreadsheet, the second spreadsheet showed up in Favorites even though I didn't put it there. This made me wonder if you can have more than one Excel database defined.

 

[Guest_imported]

I am trying to export a big report to Excel. Everythings looks OK, but for whatever reason the values of the first column in the report is showing up at the last column, not in the place where it should be displayed. This looks to be OK if I export as
PDF format.

Thanks alot.
John.