Essentials: Crystal 8.5
Database(s): Access97, DB2
I have a bunch of reports I created on my test database (Access 97). Now, I want them to hit my "active" DB2 database. All the field names are the same. I use the Set Location and Convert Database Driver commands to correspond to my new tables and driver, respectively....and when I go to refresh the report I get no records. There's nothing in the select statement that falls away or is changed in the convert.
If I start from scratch, I get data from the DB2 no problem.
Can someone please give me a quick outline on what I am missing or what to check? The thought of rebuilding all these reports is well, not a pretty one.
Thanks for your help,
Andy
Database(s): Access97, DB2
I have a bunch of reports I created on my test database (Access 97). Now, I want them to hit my "active" DB2 database. All the field names are the same. I use the Set Location and Convert Database Driver commands to correspond to my new tables and driver, respectively....and when I go to refresh the report I get no records. There's nothing in the select statement that falls away or is changed in the convert.
If I start from scratch, I get data from the DB2 no problem.
Can someone please give me a quick outline on what I am missing or what to check? The thought of rebuilding all these reports is well, not a pretty one.
Thanks for your help,
Andy