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!
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?
Comments
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?
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"
http://www.BiloBeauty.com
http://www.autismspeaks.org