RIPARAM and SQL version

[Sue_(Guest)]

I am running with SQL version version 10.1.003. I am having problems with passing parameters. __1. I have tried passing a RI_FILTER and finally ended up having to send the RI_WHERE clause instead is this a SQL issue as well and how do I tell if it is part of the select statement or considered a filter?__2. Now I have a calculated field param_disp = IIF (RRUNIN(),RIPARAM("PDISP"),"FALSE") in my report band line for the detail line I have param_disp if True display this band. I have the param_disp on my footer line and can see how it is passed, but the display of the detail line does not change. I have tried sending True/False,T/F etc. Any ideas? __3. Normally I will not be able to use the ParameterRR fields but I was trying to get this to work and I am not sure if it is the type of field that is the problem or having more than one ParameterRR field. RR prompts me for the 3 fields but it tells me that I have a column problem - think that is when it is trying to create the SQL statement. Is this one that you can^t do with SQL but can with XBASE?__If I just use one field it works so I am not sure if it is passing the text field correctly or ???__

[kfleming]

An RI_FILTER is always evaluated locally and not by the SQL engine.__An RI_WHERE is sent directly to the SQL engine as part of the WHERE clause is the SELECT and will generally be faster than using RI_FILTER.__The results of an RIPARAM calculation are always sent to the report as a character string.__If you want to use an RIPARAM to control the printing of a line, you can set__PDISP=T__in your control file.__Then in your report, create a calculated field with the expression:__RIPARAM("PDISP")="T"____This calculated field will then return a logical true when PDISP in set to T and a logical false when it is not.__You can then use this calculation to control the printing of a line in your report.____If you are using a ParameteRR field and not an RIPARAM calculation, then you would define the default value of the parameteRR as either .t. or .f. to make it a logical and then use this field as the field to control printing of the band line. The user will then see a radio button prompt in the ParameteRR value entry screen where they can then select True or False.____Regards,__Kathleen__R&R Support________