Virusim,

Note that this applies to CR 7.0: The code won't work for previous version


>Thank for your advise on CR. As I am new to CR. There are 02 questions that I had doubts with in CR, please kindly help me on it. Thank a lot

>01) Do my VFP DBF files need to have all the required field inside it for CR to
work, can I just use any public variable from VFP inside CR like VFP report designer do. Please advise.

You can define parameter fields with a report. IF you give them the same name of the variables used in your program, you can use the following code to pass the values of the VFP variables to the Report:

WITH crReport.ParameterFields
FOR nT= 1 TO .Count
cName=.Item(nT).ParameterFieldName
IF TYPE(cName) # "U"
.item(nT).SetCurrentValue(EVAL(cName))
ENDIF
ENDFOR
ENDWITH

02) Can I use CR to do index for VFP DBF files.

You can. However I did discover some difficulties with relations and CDX files. IDX indexfiles seems to do the job well.

I strongly suggest making a class to handle communication with CR reports.

Walter