Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using SQL db with Excel spreadsheet


I have had success in the past using my SQL db with an Excel spreadsheet for additional data in Crystal Reports.  However, I have a new report which uses an Excel spreadsheet that is quite lengthy, so it processes very slowly and then crashes.

Are there any general tips regarding the design of the report which could help with this issue?  Example:  The order of formulas in the Select Expert (does it matter which db is accessed first, etc.)  Or data link tips?

Any other thoughts?

Your help is appreciated.  Thanks.

Former Member
Former Member replied

Hello warner,

You can convert excel file into .CSV  file format and then the report processess very fast....

Try this one give more updates...

Thanks,

DJ

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question