Page 1 of 1

Passing Parameter to Report

Posted: Fri Jul 08, 2005 4:49 pm
by Robert_(Guest)
I am using ReportWorks Latest version, and vb6__I need to send a character parameter to a report which may__vary each time the report is printed. I am unable to put it in a table__as the system is multi user.__The Control is called Report1.____I have set up a calculated field called Rn2__? How do i send say "Cabbage" to the report__? Report1.ReportName="Rep6"__? Report1.???????????? Rn2 = "Cabbage" (is is something like this?)______Regards Robert

=> RE: Passing Parameter to Report

Posted: Sat Jul 09, 2005 10:50 am
by kfleming
Change the expression of Rn2 in the report to be:__RIPARAM("forRn2")____Then in the control use:__Report1.Parameters(0)="forRn2=Cabbage"____When you execute the report the value of the calculated field will then become Cabbage.____Kathleen__R&R Support__

==> RE: Passing Parameter to Report

Posted: Sat Jul 09, 2005 6:44 pm
by Robert_(Guest)
Kathleen,__Thanks for your help, this worked fine.__Regards Robert