Failed to Retrieve Data from Database

illiniben

First of all, just starting to use this program and it is fantastic!

I have 3 reports working perfectly, but my last report gives me the "Failed to Retrieve Date from Database" error.

All the connection strings are matched exactly to each other and to the other reports, so I know they are good.

I'm thinking it may have to do with the fact that this report is using alias tables.

This report is extremely complex and has two of several tables. The second instance is an alias table and the table name is given a "_1" at the end. Example: pub.customer and pub.customer_1. In the Table Name column of the Connections tab it lists the alias name for those tables.

Could it be that this program is looking for the customer_1 table and crashing because it doesn't truly exist?

Just looking for a bit of direction.

Thanks!
Ben