I've changed my datasource for my CR 10 report from Access to the SQL version of the same database. All the tables are the same in each but when I run the report against the SQL side, it returns no records. When I run it against the Access side, it returns many records. Is there something I should be looking for when making such a switch?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing Datasource from Access to SQL
- Thread starter Seabz420
- Start date
synapsevampire
Programmer
Check the record selection formula, there may be NULLS designated which no longer exist or vice versa.
I would eliminate any filtering criteria from the record selection formulas for testing.
And are you sure that you've correctly repointed the data source?
Are the relationships the same?
Not much to go on, hopefully the above will help.
-k
I would eliminate any filtering criteria from the record selection formulas for testing.
And are you sure that you've correctly repointed the data source?
Are the relationships the same?
Not much to go on, hopefully the above will help.
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question