Customer

Navi_Learner · 2008-11-06

I tried to add salesperson to the top customer list, but it will not retrieve the correct info. There are three dataitem, integer(heading), customer, integer(print loop).
Any advice? Thanks!

jversusj · 2008-11-06

are you just trying to show the salesperson code on the report? you can get the information from the customer record.
since this is a ranking report there is probably an array being built with the customer number, name, sales volume and that is what is output in the print loop. you would have to expand the array dimensions, write the slsp code into the array, and then add that array dimension to the output.

you might be able to cheat and put some code on the OnPreSection of the report to get a copy of the customer record using the array dimension holding the customer no., and then display that as a control.

a little vague, but maybe enough to get you started?

Savatage · 2008-11-06

Openthe report View the Sections
On Print Loop, Body (1) add

OnPreSection()
Customer.GET(TopNo);

Add a textbox on On Print Loop, Body (1)
with SourceExp = Customer."Salesperson Code"

really should change the orig TOPIC NAME to something better than juast Customer

Perhaps "Add Salesperson Code to Customer Top X List"

Navi_Learner · 2008-11-06

Thanks very much

Customer

Comments

Categories