Is there any way that the name of database files can be changed within a Crystal Report without having to completely rewrite the report?  We have just installed the Crystal Report server, it will distribute scheduled reports and allow users to request and run reports.  Previously report distribution was happening from my desktop so I am very happy about this improvement.  However, our financial set of reports were pulling the G/L data from a SQL Server (which gets data from a near real-time push  from an antiquated GL system) but I was using an Excel spreadsheet linked to an ACCESS database to direct the placement of each account on the P&L and to determine/designate the subtotals or "groups"(contribution margin, ebitda, total revenues, etc.)  We want to move the Excel spreadsheet to the SQL Server to maximize the performance of the Crystal reports server.  I want to avoid having to rewrite all of the formulas and subtotals in the P&L reports (3report versions all use the same Excel look-up sheet)

Thanks in advance to all who have a failsafe way to tackle this!!!!