Hi,

I would like to get your help to avoid data to be sent more than once. Current data send to display on report at UI script is using rprt_send().


My desired report output:
--- Detail section -----

Customer Order Num
Cust001 Ord-1001

---after.field section----
DO-1001
DO-1002
DO-1003


Program coding:
function read.main.table()
{
Select * from whinh800
Where whinh800.custno = "Cust001"
selectdo
OrderNo = whinh800.ordno
endselect

DisplayDONumber()
}

function DisplayDONumber()
{
Select * from whinh900
Where whinh900.OrderNo =:OrderNo
selectdo
DO_num = whinh900.do_num
rprt_send()

endselect
}


But system display as:
--- Detail section -----
Customer Order Num
Cust001 Ord-1001
Cust001 Ord-1001
Cust001 Ord-1001

---after.field section----
DO-1001
DO-1002
DO-1003


Looks like the customer & Order Num display followed by the no.of DO return. How to avoid this and control only display once? I did set the field to "suppress", it's still the same.


Thanks.

Best Regards,
Grace

Hi,

I would like to get your help to avoid data to be sent more than once. Current data send to display on report at UI script is using rprt_send().


My desired report output:
--- Detail section -----

Customer Order Num
Cust001 Ord-1001

---after.field section----
DO-1001
DO-1002
DO-1003


Program coding:
function read.main.table()
{
Select * from whinh800
Where whinh800.custno = "Cust001"
selectdo
OrderNo = whinh800.ordno
endselect

DisplayDONumber()
}

function DisplayDONumber()
{
Select * from whinh900
Where whinh900.OrderNo =:OrderNo
selectdo
DO_num = whinh900.do_num
rprt_send()

endselect
}


But system display as:
--- Detail section -----
Customer Order Num
Cust001 Ord-1001
Cust001 Ord-1001
Cust001 Ord-1001

---after.field section----
DO-1001
DO-1002
DO-1003


Looks like the customer & Order Num display followed by the no.of DO return. How to avoid this and control only display once? I did set the field to "suppress", it's still the same.


Thanks.

Best Regards,
Grace

Hello,

can't find tables whinh800 , whinh900 in my LN6.1 FP6 environment.
Are these customized tables ?

Regards

To supress identical fields only works if the fields are sort fields. Make them part of the sort and it should work. Or make them part of a sort and then part of a header layout - either way should work.

hi Bernd,
Yes, these are the customized tables.

in report input field, sort accordingly:-
whinh800.custno - assending - sort seq 1
whinh800.ordno - assending - sort seq 2
whinh900.do_num - assending - sort seq 3

the layout which is placed in detail section has to be placed in before.field whinh800.ordno section. and the after.field section has to be in detail section.
so the output will be-

---before.field section----
Cust001 Ord-1001

----detail -------
DO-1001
DO-1002
DO-1003

Hi kishoremeher & all,

Thanks your help, I got to solved it. :)

Does anyone know the source that inserts record in the Shipment Header Extension table (whinh900)

This is not a standard Table!
I think this can only be from own or third party programming.