Page 1 of 1
Parameter Field
Posted: Thu Jun 22, 2006 11:04 am
by KingFu_(Guest)
I am passing a value to my parameter field named ^MyParam^. Created a calculated field with the systax below and wanted to print it^s value on the report but the calculated field prints blank. Why?__riParam("MyParam ")
=> RE: Parameter Field
Posted: Thu Jun 22, 2006 4:01 pm
by kfleming
Your runtime control table would need to set the value for MyParam.__If it is a text control file you would include a line that says:____MYPARAM=MYVALUE____and the report would print "MYVALUE" when run via runtime.____Note that you can use ParameteRR fields directly in a report in place of the older RIPARAM() syntax.____Kathleen__R&R Support
==> RE: Parameter Field
Posted: Thu Jun 22, 2006 4:28 pm
by KingFu_(Guest)
I selected SQL Select from the Database menu and enterd__ _<<@MyParam = ^1/1/06^>>____I added a calculated file named MyValue and entered the expression:___RIPARAM("MyParam")____And then inserted the field MyValue to the report.____But, the report prints blank.
===> RE: Parameter Field
Posted: Fri Jun 23, 2006 10:00 am
by kfleming
Is what you really want to do is to pass a date field as part of a SQL select WHERE clause?____Kathleen__R&R Support