Page 1 of 1

R & R Doesn^t work

Posted: Fri Jul 27, 2001 2:42 pm
by GS_(Guest)
I am trying to pass a char string parameter from VB 6 using the R & R OCX control for version 9.____R & R doesn^t receive the parameter..____The lasterror message says "undefined job control variable: empId"__These are the steps I have taken...____1. create a calculated field:__a: calculated field name = "employeeid"__b: expression = RIPARAM("empId")____2. Under Database .. Query, I created a query where I set the employee_id = employeeid____... everything checks so far____3. Using the OCX, I set ParametersString = "empId = 101"__4. run the report using RunReport (2) .. ____The empId of 101 is not being passed into the report so therefore nothing prints.____What am I doing wrong??? Did I leave anything out??__

=> RE: R & R Doesn^t work

Posted: Mon Jul 30, 2001 9:29 am
by kfleming
This code worked in my test VB application____RRReport1.ReportName = "C: estEmpTest.rrw"__RRReport1.ParametersString = "EmpId=101"__RRReport1.Destination = 1__RRReport1.Action = 1____Kathleen__R&R Support

==> RE: R & R Doesn^t work

Posted: Tue Jul 31, 2001 7:32 am
by GS_(Guest)
That worked.____I had to remove the spaces in..____ParametersString = "Empid = 101"____TO:____ParametersString = "Empid=101"