Help on creating reports

anushafdo
anushafdo Member Posts: 32
edited 2013-08-02 in NAV/Navision Classic Client
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

Comments

  • anushafdo
    anushafdo Member Posts: 32
    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
    Kishorm Member Posts: 921
    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
    anushafdo Member Posts: 32
    Thank you
    Wow, now I starting to see...

Categories