Parameter problem in R&R9 SQL

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Morris_Evans_(Guest)
Posts: 11
Joined: Tue Oct 10, 2017 12:44 pm

Parameter problem in R&R9 SQL

Post by Morris_Evans_(Guest) » Wed Nov 06, 2002 8:57 am

Set up a character Parameter in R&R9, have a filter testing a field against the Parameter, preview the report... The report comes out with the default value of the Parameter instead of the supplied value.__Yet if the Parameter is displayed on the report, the supplied value is shown. (with the default value used in the filter.)____Hope that makes sense to someone !____Is there a workaround / Fix ?____Morris.______

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Parameter problem in R&R9 SQL

Post by kfleming » Wed Nov 06, 2002 3:55 pm

Are you using 9.0.009?____Kathleen__R&R Support

Morris_Evans_(Guest)
Posts: 11
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Parameter problem in R&R9 SQL

Post by Morris_Evans_(Guest) » Thu Nov 07, 2002 9:55 am

Yes, already fully patched to .009____Where to next ?____Morris.

Neeraj_Kamat_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Parameter problem in R&R9 SQL

Post by Neeraj_Kamat_(Guest) » Fri Dec 06, 2002 9:28 pm

Create a calculated field as:____Calculated_field = RR(ParameteRR_field)____Use the calculated field in the filter.____Then the report will bring back data with the new value input while executing the report.

Post Reply