Parameter Field

[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 ")

[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

[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.

[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