ParameteRR Help for RR SQL 9

[srappaport]

[updated:LAST EDITED ON Feb-14-02 AT 00:07 AM (EST)]I^m a newbie and nonprogrammer, so please be patient as I try to learn the basics. I^ve read the manual and helpfiles, but I can^t get the report viewer to load correctly, modify the dates in the filter and run the report.____Control File: C:Program FilesR&R SQL Report WriterTemplate swrunsample.txt____The control file has parameters set for:____RI_Report=Employer and Job Order.RSW__RI_Printer=D__RI_WTOP=100__RI_WLEFT=100__RI_WHEIGHT=400__RI_WWIDTH=560__RI_WBORDER=2__RI_WMAX=T__RI_WMIN=T__RI_WCTRL=T__RI_WPARENT=__RI_DISPERR=T__RI_STATUS=T__RI_QUERY=?____The rdbms I use is mySQL. My datasource is named CWE_BOTJ. I connect to it successfully with the myODBC driver. ____I have two tables, JobOrder and Employer that are related on the EmployerID field. ____I want to filter for Open joborders between user-specified dates and then run the report. I created two ParameteRR fields, rptStart and rptEnd for the start and end dates. The filter expression is as follows:____JOBORDER.EmployerID = EMPLOYER.EmployerID __and ((JOBORDER.Status = ^Open^ and JOBORDER.DateOpened >= ^rptStart^ and JOBORDER.DateOpened <= ^rptEnd^)) ______I would like to run the viewer with this control file on a Windows workstation. Please advise on any errors above and on how to run the viewer and control file successfully. ____Thanks very much!______

[kfleming]

You do not need to set RI_QUERY to a ?__Because the report already uses parameteRR fields in the query, you will automatically get the parameteRR dialog at runtime.____The only other suggestion I would make is to create a calculated field with expression:__RR(JOBORDER.DateOpened) __and use this calculated field instead of the actual database field JOBORDER.DateOpened in your saved filter in the report.______Kathleen__R&R Support

[srappaport]

Kathleen, ____Thanks. You got me on track and got it to work. I^ve learned a lot from this exercise.