I have a very complicated report that contains 4 sub-reports. Upon migrating to a SQL back-end I needed to set up views in order to filter the requested data. I then created pass-thru querys to return data for each of the sub-reports but am getting an error stating that I cannot use pass-thru's for sub's. Any way around this?
Oh - I use pass-thru's instead of linking directly to the view in order to set the ODBC timeout. The default for linked view's is 60 sec's and cannot be altered.
Thanks in advance....