We are migrating from Crystal 8 to Crystal 9 on a VB6 application. For a number of our reports, we create global temporary tables (##) containing the necessary data. Then we would pass the table name to Crystal for report creation.
In migrating to Crystal 9 - when I pass the new table names to Crystal - Crystal comes back indicating the temp table name could not be found. If I go in as SA afterward and Grant all on the temp table to Public - Crystal will see the table and run normally. I can't figure out a way to create a temp table and grant it Public access so Crystal can see it from within VB.
For some reason when I set the location in the new RDC architecture, Crystal can never see the temp tables. I've put some of our code in below.
-- open the report
Set Report = crxApplication.OpenReport(sRptPath & "PayCodesReport.Rpt", 1)
-- here is where we set the location of the temporary table - and where Crystal bombs out
Report.Database.Tables(1).Location = "tempdb.dbo." & tmpPayCodes
Any solutions would be greatly appreciated. Thanks.