Problems with reports

lilianatavares
lilianatavares Member Posts: 39
edited 2004-09-01 in NAV/Navision Classic Client
Hello,

I need to do a report that shows the lines of the table Job Budget Line for a Job contained by phases and at the end of each phase she wanted to see the lines of the table Job Ledger Entry of the same Job that are not associated to the budget (field Related to Budget=False). The model of data that I am to use is:
Job
>> Job Budget Line
>> Job Ledger Entry

It will be that this model is correct. And which the sections to use to see the lines in the way that I want.

Thank's

Comments

  • afarr
    afarr Member Posts: 287
    This seems roughly right. I guess you want to group Job Budget Line by Phase Code i.e. view the Properties, and put

    GroupTotalFields --> Phase Code

    also

    DataItemLinkReference --> Job
    DataItemLink --> Job No.=FIELD(No.)

    In JobLedgerEntry data item you can set

    DataItemTableView --> Related to Budget=CONST(No)

    The simplest thing to do is probably to use the JobBudgetLine and JobLedgerEntry sections to print your information.

    Alastair
    Alastair Farrugia

Categories