Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th June 2017, 23:20
lotius81 lotius81 is offline
Junior Member
 
Join Date: Nov 2016
Posts: 25
lotius81 is on a distinguished road
Baan: Infor LN 10.4 - DB: SQL Server - OS: Windows Server 2008
From and To in LN Query Data
Baan: ERP LN 6.1 FP10 (Infor ERP 10.4)
C/S: None/Unknown

So I'm building a query for someone in the Query Data session (along with some custom edits to the resulting report) and I'm running into something that's stumping me. On other reports that have a form I'm able to add the "From" and "To" ranges of the various inputs to the report layout. Am I able to do this from a Query Data report as well? I've added a Date range picker to the form so that when they Execute Query they can choose a date range and get the correct records, but I'm not sure how to get those date values to the report itself.

Code:
whinh312.ardt >= whinh312.ardt.f and
       whinh312.ardt <= whinh312.ardt.t
Those are the date range values that were added via EasySQL. I tried adding ardt.f and ardt.t to the input fields and then to the report layout, but nothing comes through. Totally stuck

Thanks for any help!

Rich
Reply With Quote
Sponsored Links
  #2  
Old 20th June 2017, 10:02
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 728
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
See this thread: http://www.baanboard.com/baanboard/s...ad.php?t=68101 .
Reply With Quote
  #3  
Old 20th June 2017, 14:37
lotius81 lotius81 is offline
Junior Member
 
Join Date: Nov 2016
Posts: 25
lotius81 is on a distinguished road
Baan: Infor LN 10.4 - DB: SQL Server - OS: Windows Server 2008
Perfect! Thank you very much
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


All times are GMT +2. The time now is 21:17.


©2001-2017 - Baanboard.com - Baanforums.com