I am using Crystal Reports 2008 and have deployed the merge modules 12.1 with my application and if any of my reports access tables with spaces in the table names, it causes the Crystal runtime engine to prompt for login credentials to the database (like it cannot find the table)
The reports work fine on my computer with the full version of 2008 installed. So it sounds like a bug with the merge modules. I am using version: 22.214.171.1242 of the crystal merge module.
The reports were written agains ADO.XML files generated from .Net datasets... so crystal is connecting to a single XML file (with the Schema saved in the XML file)
I have tried the SetDataSource against the entire dataset and individual tables... I get the prompt either way on client computers using the merge modules. The data source is exactly the same on my computer as it is on the client computers using just the merge modules.
So the only solution I can come up is to remove spaces from the table names. Is there any newer merge module that has this bug fixed? Does nobody use spaces in table names?