Report Query - Selections > SQL Selection Criteria

[tvrm]

After updating reports from SQL6.5 to SQL7.0, now have to use fully qualified tablename to get reports that include SQL Selection Criteria to work. In this example had to add prodPHS.dbo.apptwl whereas previously alias apptwl worked okay. Any thoughts ?

( apptwl2.waitlist_id = (select min(apptwl3.waitlist_id)
from prodPHS.dbo.apptwl apptwl3
where apptwl3.appt_id = apptwl2.appt_id
and apptwl3.list_add_datetime is not null
and apptwl3.wlprior_id not in (1,16)))

 

[CharlesCook]

I forget the name of the config file i think it is RS_SQL.ini and RS_SQL.txt You may be able to put a section in it to turn this off.

I know I'm not very clear on this I don't have RS on my machine anymore as most of my customers don't use it anymore. But the file would be in your windows directory. Search for RS*.ini and you should find it. Then look in the .txt file that goes with it for an explnation of the settings.

Hope this helps a little CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining