We have two Universe databases that I access through ODBC. I need to create a report which combines data from both. I know I can use a subreport but is there a way to access them both at the same time.

I am able to bring in the files in the Data Expert. When I tried running a selection statement based on date I errored out "Cannot setermine the querioes neccesaary to get data for this report.

My selection went sonething like this:

{Date} in {?Current Range} or {Date_1} inn {?Current Range}

where {Date} is from one database and {Date_1} is from another.

Any help is appreciated.

Thanks