Hi
I'm trying to create a product running history report for QA purposes however we have changed computer systems and I need my report to use one datasource (old database) if the date parameter is set to a date (date range) prior to the change, and the new database if set after the change.
The datasets are of very different structure in terms of the tables used and fields, my goal would be to superimpose the fields from each over each other and suppress/unsupress based on the date value.
There will be a problem for date ranges which would give results from both databases.
But without using sections in the details with the results from each db in seperate sections perhaps??? I don't see anyway of getting around this but would save writing 2 seperate reports.
Is what I'm proposing possible?
IP Logged
