Skip to Content
0
Former Member
Dec 12, 2006 at 05:43 AM

"This field name is not known", Details: errorKind, Error in formula

144 Views

<p>I receive this error when running a report in our C# .NET windows form viewer hitting an oracle data source. If I run the exact report against a MSSQL data source, it works fine. If I run the exact report in Crystal Designer against the same oracle data source it runs fine. </p><p>At runtime, in our viewer using crystal&#39;s .NET SDK (XI R2) we change the database connection info. If the user is connected to MSSQL, then we set the connection information with MSSQL parameters. If the user is connected to Oracle, then we set the connection information with Oracle parameters. If I remove the formulas from the report and run in our viewer hitting an oracle database, the report does not get this error. </p><p>If I run this report in our viewer which is point to a Oracle server from Crystal designer without modifying the runtime database connection, it works fine. </p><p>This tells me that the connection information is being set incorrectly at runtime, but I have double checked all the properties and attributes at runtime with what is stored in the report and they are exactly the same. We are using Table.ApplyLogOnInfo to apply the connection changes at runtime.</p><p> Any help would be appreciated.</p>