Liveware Publishing Support Forum

I have searched for a Guide on RI_WHERE syntax and i have struggled to find said items - can anyone send me a URL.____Thanks

Anything that you enter in RI_WHERE is sent as a WHERE clause in the SQL statement that R&R sends. So the exact syntax depends on the platform you are using.__so if your current select is __SELECT EMPNO from EMPLOYEE____adding an:__RI_WHERE=LASTNAME="FLEMING"____would change that SELECT to__SELECT EMPNO from EMPLOYEE WHERE=LASTNAME="FLEMING"____RI_WHERE works along with RI_INCLUDE ____Here is the information from the Help file.____The optional RI_WHERE parameter enables Report Viewer to insert a WHERE clause in the SQL statement for an Auto-SQL report. If you or your users are proficient in SQL, you may want to use this parameter instead of RI_FILTER and RI_INCLUDE to select records. Since the WHERE clause is evaluated directly by the SQL software, using RI_WHERE can improve performance and enable you to make use of any WHERE clause supported by your SQL software.__The WHERE clause specified with this parameter always affects the report, regardless of whether a filter was saved with the report. If you have also used RI_FILTER and RI_INCLUDE to select records, the effect of RI_WHERE is as follows:____If RI_INCLUDE is S for "Saved," both the filter saved with the report and the clause in RI_WHERE are used to select records.__If RI_INCLUDE is O for "Override," both the filter expression in RI_FILTER and the clause in RI_WHERE are used to select records.__If RI_INCLUDE is E for "Entire," only the RI_WHERE clause is used to select records.__If RI_INCLUDE is a question mark (?) to allow the user to enter a filter interactively, both the user_s filter expression and the RI_WHERE clause are used to select records.____Note:_ RI_WHERE values are not applied to User-SQL reports. To override the selection conditions for a User-SQL report, use the RI_REPLACE parameter.______Kathleen__R&R Support__