Good day, Experts.
I have been experimenting with ways to insert an Excel sheet in a Crystal Report ver. 11
My goal is to insert an Excel sheet on my report that lives in a folder on the share drive at my workplace, and then schedule the Crystal Report and have the data in the Excel sheet on the report reflect the data currently in that Excel sheet on the share drive. (In other words, link the Excel sheet on the report to the source Excel sheet.)
I have THREE questions:
1 - Can you provide a list of steps for inserting the Excel sheet (OLE object?) linked to the original file where the Excel sheet lives so that any updates to the original will be reflected on the Crystal Report?
2 - If a user edits the Excel sheet on the Crystal Report, will that edit also be reflected on the original Excel sheet on the share drive where it lives? My goal is to DISALLOW any changes being made to the Excel sheet on the Crystal Report or the original.
3 - Is there a way to resize the Excel sheet on the Crystal Report so that the whole sheet is visible without having to double click and open the Excel program?
Thank you for any guidance with this project.