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.
You can convert excel file into .CSV file format and then the report processess very fast....
Try this one give more updates...