Report Help needed for Newbie

slmaluwa

hi
I am relatively new to navision reporting and have been developing report in small scale. But, now I am asked to give a report which seems as a VERY complex to me.
Already spent few hours in R&D and cannot find a way out.
Below are the details:
Nav 4 SP3 - Native DB

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

-----------------------------------------------------

The Table1, Table2 and Table3 has relation between them.
In Value Entry table, the Table2 & Table3 inforation does not exists.

How can create a report like this? A sample report of this type would be of much use for me.

Thank you all in advance

Maluwa

matttrax

Well, as a start you should read the reporting chapters in the Dev 1, Dev 2, and Application Designer's Guide. They're not too bad.

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]

slmaluwa

Thank you for the reply matttrax

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?