mibuso.com
Home› NAV/Navision Classic Client
Options

DataItem by another Table in Section of Report

DarkHawkDarkHawk Member Posts: 5
edited 2005-05-24 in NAV/Navision Classic Client
Hi all,

i have a problem with an report.
The Report has as first DataItem "Salces Cycle" The second DataItem is "Sales Cylce Stage" an it is one level indendet.
As third DataItem a have Opprtunity it is two level indendet.

So the reportlist is great sorted by Customer to Sales Cycle Stage, but i have only the information about the Customer name.
I must print the City about the Customer too.

The City about the Customer are stored in Table 5050.

So what can i do, to print the city in the Opportunity Section?
The City must be print in addition to the Customer Name.

Sorry about my english.
Thanks a lot
Regards
Michael Hofmann

Comments

  • Options
    DenSterDenSter Member Posts: 8,304
    In the OnAfterGetRecord trigger of the highest level dataitem that has the same customer, you get the customer into a global record variable, and then you can simply enter any customer field as the SourceExpr of any textbox, by referencing it in the property.

    So add a global variable called 'Customer', type record, subtype Customer. Let's say you have a Customer number in the Sales Cycle, then you would add the following statement to the OnAfterGetRecord trigger: 
    Customer.GET("SalesCycle"."Customer No.");
    And in the section, you would have a text box, and its SourceExpr would be Customer.City.
    Daniel Rimmelzwaan
    RIS Plus, LLC
    MVP - Business Apps
  • Options
    DarkHawkDarkHawk Member Posts: 5
    @DeSter

    wow. It´s work great.

    Thanks a lot.

    Regards
    Michael Hofmann
  • Options
    DenSterDenSter Member Posts: 8,304
    You made it work Mike, I just gave you a little tip 8)
    Daniel Rimmelzwaan
    RIS Plus, LLC
    MVP - Business Apps
Sign In or Register to comment.