Table1: SalesPerson Fields: ItemCode,ItemName Table2: Category1 Field: CatName1 Table3: Category2 Field: CatName2 Table4: Item Field: CatName1, CatName2 Table5: Value Entry Fields: SalesPerson Code, ItemCode,InvoicedQty Report FOrmat: ----------------------------------------------------- Sales Person.Code Sales Person.Name ----------------------------------------------------- Category1.CatName1 ------------------ Category2.CatName2 InvoicedQty Category2.CatName2 InvoicedQty Category2.CatName2 InvoicedQty Category1.CatName1 TotalInvoicedQty ----------------------------------------------------- Sales Person.Code Sales Person.Name ----------------------------------------------------- Category1.CatName1 ------------------ Category2.CatName2 InvoicedQty Category2.CatName2 InvoicedQty Category2.CatName2 InvoicedQty Category1.CatName1 TotalInvoicedQty -----------------------------------------------------
Comments
For your sections I would go with something like the below (see my inserted text). Then you should try to figure out more from there.
Report FOrmat:
Sales Person.Code Sales Person.Name (Salesperson, Body)
Category1.CatName1 (Category1, Body)
Category2.CatName2 InvoicedQty (Value Entry, Body)
Category2.CatName2 InvoicedQty
Category2.CatName2 InvoicedQty
Category1.CatName1 TotalInvoicedQty (Category1, Footer)
[/quote]
My Blog - nav.education
Unfortunately, there is no relation between SalesPerson table and Category Tables.
Therefore, I cannot figureout a way to LINK these two tables.
A friend of mine suggested to use Integer tables for looping in reports. I never used this and is this possible?
What is the real purpose of using Integer tables in report?