Parameters with run time ver 10

[Charlie]

I^m have a problem when I try to use a date parameter linked to a query in my report. The report works when I run it using the report designer (xbase ver 10.0.012)..............however if I use runtime (on the same computer)the report will go through the record selection process but not select any records. __

[kfleming]

Try taking away the query and adding a calculated field with expression:__dateparam=datefield____and see if it returns a T in both designer and runtime.____That might help to spot the difference.____Runtime uses the same code as the designer to process query statements.____Kathleen__R&R Support

[Charlie]

Kathleen____Sorry for the delay, in getting back to you. I have isolated the problem to a calculated field "B_DATE = IIF(ERROR(CTOD(RIPARAM("BeginDate"))),sDate,CTOD(RIPARAM("BeginDate")))". "sDate" is my date set by the report designers "ParameterRR Fields" function and "BeginDate" is a parameter passed by Rapid Runner.____I have set these reports up so that I can run them from designer, prompting for the parameters and rapid runner with parameters for a group of reports. What I was trying to do was to allow other users to access individual reports with the runtime version prompting the user for the parameters.____The run time version of the report does not calculate a value for B_DATE, however the designer version does!____Regards____Charlie__

[kfleming]

Do you have the field B_DATE on the report layout? If not, try adding it to the page header or title.____Kathleen__R&R Support

[Charlie]

I did have the B_Date field in the grand total line, putting it in the page header didn^t help. My original report relates a lot of databases so I created a simple report to test just the B_Date parameters, the B_date does not calculate on the runtime version, hence all the records in the database are selected..........in contrast to my report which relates data bases and does not select any records. Do you want me to email you test report and along with the small database (61 records) I have used for testing?____

[kfleming]

Please send to livesupport@livewarepub.com____Thanks.____Kathleen__R&R Support