Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
17%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
17%
1500 - 2000 GB
17%
> 2000 GB
22%
Total votes: 18

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 6th July 2011, 13:05
Grace Cheong Grace Cheong is offline
Member
 
Join Date: Jan 2011
Posts: 43
Grace Cheong is on a distinguished road
Baan: 6 - DB: Oracle - OS: Windows 7
How to avoid data send in redundant values?
Baan: Other/Unknown
C/S: None/Unknown

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
Reply With Quote
  #2  
Old 6th July 2011, 13:16
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,724
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Is it a customization ?

Quote:
Originally Posted by Grace Cheong View Post
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
__________________
//Bernd

Last edited by bdittmar : 6th July 2011 at 13:17. Reason: Add tables
Reply With Quote
  #3  
Old 6th July 2011, 14:36
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,125
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
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.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.

Last edited by mark_h : 7th July 2011 at 14:38.
Reply With Quote
  #4  
Old 7th July 2011, 02:32
Grace Cheong Grace Cheong is offline
Member
 
Join Date: Jan 2011
Posts: 43
Grace Cheong is on a distinguished road
Baan: 6 - DB: Oracle - OS: Windows 7
hi Bernd,
Yes, these are the customized tables.
Reply With Quote
  #5  
Old 7th July 2011, 05:44
kishoremeher kishoremeher is offline
Junior Member
 
Join Date: Apr 2007
Location: India
Posts: 24
kishoremeher is on a distinguished road
Baan: baan4, baan LN - DB: Oracle - OS: UNIX
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
Reply With Quote
  #6  
Old 7th July 2011, 07:31
Grace Cheong Grace Cheong is offline
Member
 
Join Date: Jan 2011
Posts: 43
Grace Cheong is on a distinguished road
Baan: 6 - DB: Oracle - OS: Windows 7
Thumbs up

Hi kishoremeher & all,

Thanks your help, I got to solved it.
Reply With Quote
Sponsored Links
  #7  
Old 18th September 2018, 21:15
Terry.McCollum Terry.McCollum is offline
Junior Member
 
Join Date: Jul 2010
Posts: 3
Terry.McCollum is on a distinguished road
Baan: B40_C4 - DB: Oracle - OS: UNIX
Shipment Header Extension table (whinh900)

Does anyone know the source that inserts record in the Shipment Header Extension table (whinh900)
Reply With Quote
  #8  
Old 26th September 2018, 13:01
vahdani's Avatar
vahdani vahdani is offline
Guru
 
Join Date: Aug 2002
Location: Cologne, Germany
Posts: 438
vahdani is on a distinguished road
Baan: all - DB: all - OS: Unix / Win2K
This is not a standard Table!
I think this can only be from own or third party programming.
__________________
May the force be with you!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Application data dictionary vs. run-time data dictionary NPRao Tools Development 5 7th July 2009 08:16
send data to different sections mig28mx Tools Development 6 22nd December 2007 05:04
Audit file structure baan_user Tools Development 8 4th May 2007 14:32
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38


All times are GMT +2. The time now is 01:06.


©2001-2018 - Baanboard.com - Baanforums.com