i have to generate a report of the following format… salesperson code, Name, quantity,amount. the reference tables are- salesperon/purchaser, sales header and sales line. i am using sales header as a intermediate table between salesperon/purchaser and sales line. so how i must do that
hi… In report you can easily correlate Sales Header and Sales Line via No. and Document No. and take a variable of type record Salesperson/purchaser table and one variable of type text to store the Salesperson/Purchaser name. So, OnAfterGetRecord event of Sales Header you can filter the record variable via Salesperson/Purchaser Code of Sales Header table. I think it will work… No need to define Salesperson/purchaser as a DataItem in reports. ok… Tejas
i didnt get wht u said…as i am a fresher to this field. so could u tell me in detail. i did wht u said but it is still not working
Simple…need to get trained in report Designer.