I have now tried to create several reports using Alias Tables, with very limited success.
I am using Crystal 8.5 with an SQL Database. I have had no such trouble previously when using CRW5, 6 or 7 with a paradox database.
In the latest example, I am trying to print details of a hotel booking using 4 tables.
Table 1 has the Details of the booking, the hotel, the bookee’s ID and his/her guest ID
Table 2 has full details of the main delegate, ID, Name etc
Table 3 has full details of his/her guest, ID, Name etc
Table 4 has details of Dietary Requirements.
I link Table 1 to both Table 2 and Table 3. Table 4, in order to show full details of both the Guest and Bookee’s dietary requirements, has to be inserted twice, once from Table 2 and once from Table 3. I assign the table an Alias to do so.
Now, this is where it gets weird.
I can print out the Bookee Name, Guest Name, and Bookee Dietary requirements. This works fine.
As soon as I insert a field from the Guest Dietary table, it all goes wrong. The guest’s dietary requirements ARE shown, but the list of the bookees dietary requirements changes, and now match those of the guest. This change reverts back to the original (and correct) list if I remove fields from the Alias table.
Any help that could be offered would be much appreciated!!
Many thanks
I am using Crystal 8.5 with an SQL Database. I have had no such trouble previously when using CRW5, 6 or 7 with a paradox database.
In the latest example, I am trying to print details of a hotel booking using 4 tables.
Table 1 has the Details of the booking, the hotel, the bookee’s ID and his/her guest ID
Table 2 has full details of the main delegate, ID, Name etc
Table 3 has full details of his/her guest, ID, Name etc
Table 4 has details of Dietary Requirements.
I link Table 1 to both Table 2 and Table 3. Table 4, in order to show full details of both the Guest and Bookee’s dietary requirements, has to be inserted twice, once from Table 2 and once from Table 3. I assign the table an Alias to do so.
Now, this is where it gets weird.
I can print out the Bookee Name, Guest Name, and Bookee Dietary requirements. This works fine.
As soon as I insert a field from the Guest Dietary table, it all goes wrong. The guest’s dietary requirements ARE shown, but the list of the bookees dietary requirements changes, and now match those of the guest. This change reverts back to the original (and correct) list if I remove fields from the Alias table.
Any help that could be offered would be much appreciated!!
Many thanks