Is there a way to have a report number each line. From the TCL window writing a list etc. report is there a command that will number each line 1 2 3 etc.

One simple approach is to add a symbolic column to your report, LINENUM, whose formula is as follows:

@recur0 += 1

@ans=@recur0

@recur0 starts with a null value everytime you create a TCL line, and thus is properly initialized. In other circumstances, the TCL command:

EVAL @RECUR0='

will force the reset prior to running the LIST statement.

If you email me at [email protected], I can offer you some insights on an earlier problem you raised here.

Very clever piece of work, John.

Don Miller

C3 Inc.

You could also add LINENUM to DICT VOC with

@[email protected]

and use for any LIST statement.

Tried the formula but it only numbers the first line as 1. Maybe I am missing something.

The problem is that none of the above solutions can effectively deal with the problems of Mv's, Svm, Tm issues, particularly if you use constructs like LIMIT. About the only way you can deal with the Mv issue is to explode the data by sorting on an Mv field that contains the number of values in the report. Even then, unless your line-counter variable is specific to the file and is delimited in the same way, it won't work. The line counter variable will get incremented whether the data is output or not.

You're probably not interested in Gen'd code, but that's about the easiest way to do it.

Don Miller

C3 Inc.

For reports without MV fields try a symbolic in dict of VOC with RETURN @REC.COUNT or similar.

I vaguely recall this working in 2.x of AREV….

Steve

View this thread on the forum...