I have a Crystal Report set-up against a SQL Server 7.0 database [DATABASE1] with database fields and formula fields set accordingly. I have now been tasked with pointing thr report to a different database [DATABASE1]. My problem is that the data in this new database contains data in different tables. For instance [Field1]. [Field2] and [Field3] were previously pulled from [DATABASE1].[Table1] but now the same fields need to be pulled from [DATABASE2].[Table2].[Field1], [DATABASE2].[Table3].[Field2] and [DATABASE2].[Table2].[Field3] respectively ([Table2] and [Table3] linked). When I 'SetLocation' for the new tables I get a list of unmapped fields but the list of fields to map to (right hand panel) is only for one table - I want to point to another table included in the report. Is this achievable or am I looking at having to recreate the report from scratch (running the risk of missing something in the process) ?
Thanks in advance
Steve
Thanks in advance
Steve