Line Item Numbering

[Oran Hamilton]

I am designing a report that requires every line be numbered. It is for an inventory list that can heve several thousand items. I have tried using a calculated field using count as a numeric variable and count = count +1, have tried to add it to detail section actions with xbasic scripting. I keep getting an error message count not found. I am using A5v4.03 build 230. Thank You in advance for any help

[Peter.Wayne]

RE: Line Item Numbering

i don't think you can do what you want in the OnRecord event
of the report detail, much as it seems like it should
be possible.
i think you will have to add a new field to your table,
"line_no", and then, before printing the report, fill the
field in with sequential line numbers using the same
query you use for the report.
e.g. something like
t=table.current()
query.filter="invoice_date>{1/1/01}"
query.order="invoice_number"
query.options="M"
t.query_create()
t.fetch_first()
count=0
while .not. t.fetch_eof()
count=count+1
t.change_begin()
t.line_no=count
t.change_end()
t.fetch_next()
end while
report.preview("inventory_report")
even if there are a few thousand items, the line_no field
should fill in fairly quickly.
- peter

[Peter.Greulich]

RE: Line Item Numbering

I believe you can use the running_count calc function. Just drag & drop a new calculated report on the detail section of the report and find the running_count function and apply a field to it. The genie should more or less walk you through this.

[Peter.Wayne]

RE: Line Item Numbering

you're absolutely right, peter! thank you - i didn't even know
such a function existed.

[csda1]

RE: Line Item Numbering

Peter(& Peter),

In fact, the running count, running total, etc should always be used unless you need the finished number earlier in the report. It is much more efficient than the non-running versions. I'm surprised it is not the default. I generally take a lot of time organizing reports to allow use of running values. The moment you use 1, it will slow down the process for the whole group level it applies to (because it has to make a preprocess pass through the data)

Also the running value checkbox is so hard to notice compared to it's importance.

Regards,

Ira J. Perlow
Computer Systems Design & Associates
[email protected]

[csda1]

RE: Line Item Numbering

Clarification:

The moment you use a non-running value, it forces the pre-processed pass, which slows things up a lot!

Regards,

Ira J. Perlow
Computer Systems Design & Associates
[email protected]

[Larry Ternowski]

RE: Line Item Numbering


I'm trying something similar however in my report, the items are sorted and printed by a category field. I want to number the category lines when the category field changes. The category field is supressed from printing duplicates. Any ideas would be appreciated.

Larry

[peterth]

Re: Line Item Numbering

Peter

Where is the running_count cal function that can user for line item numbering in report?
Is it the default function of Alpha or from where? I cannot find it in Help file.

Thanks
Peter-th

[Tom Cone Jr]

Re: Line Item Numbering

I believe it's an option when defining a calc field in your report layout. Suggest you check the help file topic "Place a Running Count on a Report" The topic title seems pretty close to what you're looking for.