Help on creating reports

anushafdo

First post. Hope I am welcomed here!
I am asked to design a report, like a 116 customer statement. I have already added customer and two more tables as data items and intended.
Sample:

Header Customer Details
- Cust. ledger Entry details
- Totals
- Custom Table details
- Totals.
Footer Customer Summary

I have the report. It runs perfects for individual customers. But, when we run for a range of customers, the footer details in printed on the last page only. but, i need to have it printed for each customer.
Thought I have knowledge in .NET etc, I am very new to NAV reporting and customer still uses 4.0SP3 (with 5.0SP1 exe). I dont understand how the Integer table used in standard report 116.

Please help me learn the correct method to do this type of reports.

Anu

anushafdo

I am trying to follow a method suggested in this post.
http://www.mibuso.com/forum/viewtopic.php?f=32&t=56981&hilit=report+116
But, cant understand which section to put the summary in. If I put it in customer footer, it will go the last. if put footer of other sub tables and IF NO data from that table for that customer, then it will NOT print.


confused

Kishorm

You could add an Integer dataitem (set Number filter =1) as follows and then use the footer section of this new dataitem...

Customer
- Cust. ledger Entry details
- Totals
- Custom Table details
- Totals.
- Integer

anushafdo

Thank you
Wow, now I starting to see...