Report Problem

Markandey_Pandey
Markandey_Pandey Member Posts: 178
edited 2009-12-10 in NAV/Navision Classic Client
Hi all

i have designed a report from sales invoice header and line table, here i have line table is indented.

following are property of line table i have set:

DataItemTableView:SORTING(No.)
DataItemLinkReference:<Sales Invoice Header>
DataItemLink:=Sell-to Customer No.=FIELD(Sell-to Customer No.)
TotalFields:=Quantity,Amount,Charges To Customer,BED Amount
GroupTotalFields:No.

Now, I am facing a problem, actually i want to show items grouped for each customer.
its working fine but it is showing one customer more than one time that i dont want.
I want to show one customer only once.

can anybody suggest me the solution.
Markandey Pandey

Comments

  • matttrax
    matttrax Member Posts: 2,309
    Start out with a Customer data item. Then indent Sales Invoice Header below that, and Sales Invoice Line below that.
    Matt Traxinger - ArcherPoint
  • Markandey_Pandey
    Markandey_Pandey Member Posts: 178
    matttrax wrote:
    Start out with a Customer data item. Then indent Sales Invoice Header below that, and Sales Invoice Line below that.


    i want to filter the report based on some fields of header or line table.

    as u are saying i have to use three dataitems, Customer, Sales Inv Header and line then how will i link the data items.
    Markandey Pandey
  • Markandey_Pandey
    Markandey_Pandey Member Posts: 178
    matttrax wrote:
    Start out with a Customer data item. Then indent Sales Invoice Header below that, and Sales Invoice Line below that.


    still i am facing the same problem can u plz help me.
    i have to filter the reports based on,
    customer no, posting date and dimension
    Markandey Pandey
  • sandy_bsil
    sandy_bsil Member Posts: 40
    Instead of grouping on No, do it on Customer no either Sell/Bill.
    Sandeep B
  • sandy_bsil
    sandy_bsil Member Posts: 40
    Markandey Pandey wrote:
    Hi all

    i have designed a report from sales invoice header and line table, here i have line table is indented.

    following are property of line table i have set:

    DataItemTableView:SORTING(No.)
    DataItemLinkReference:<Sales Invoice Header>
    DataItemLink:=Sell-to Customer No.=FIELD(Sell-to Customer No.)
    TotalFields:=Quantity,Amount,Charges To Customer,BED Amount
    GroupTotalFields:No.

    Now, I am facing a problem, actually i want to show items grouped for each customer.
    its working fine but it is showing one customer more than one time that i dont want.
    I want to show one customer only once.

    can anybody suggest me the solution.


    Instead of grouping on No, do it on Customer no either Sell/Bill.
    Sandeep B

Categories