Report Problem

Markandey_Pandey

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.

matttrax

Start out with a Customer data item. Then indent Sales Invoice Header below that, and Sales Invoice Line below that.

Markandey_Pandey

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

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

sandy_bsil

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

sandy_bsil

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.