Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
33%
Installation Wizard into new VRC
39%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 49

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 11th August 2003, 08:39
Harley's Avatar
Harley Harley is offline
Member
 
Join Date: Jul 2003
Location: Jakarta
Posts: 39
Harley is on a distinguished road
Baan: Baan Vc - DB: MSSQL7 - OS: Windows
Question How to add "from date" and "to date" information in report header?

Hi all,

I have created one new session in Baan Vc using generate session to print inventory movement transaction by period of time and made some modification in the session-program script.

But then I found a difficulty when I would like to add information about "from date" and "to date" in the header of my report.

Does somebody know How to add those information?

Thanks & Regards,
Harley
Reply With Quote
  #2  
Old 11th August 2003, 08:55
mohan05's Avatar
mohan05 mohan05 is offline
Member
 
Join Date: Jan 2003
Location: India
Posts: 76
mohan05 is on a distinguished road
Baan: Baan IV c4 - DB: Oracle 8 - OS: Win NT
explore yourself

Hi

you can make this form field variables as INPUT field for report & place on report layout where you want.

-Mohan
Reply With Quote
  #3  
Old 11th August 2003, 09:24
RobertB's Avatar
RobertB RobertB is offline
Senior Member
 
Join Date: Jul 2002
Location: S. Germany
Posts: 130
RobertB is on a distinguished road
Baan: Baan 5.0c, sp15 - DB: MS SQL Server 7, sp3 - OS: Win XP + 2000, RedHat 7.3
Hi Harley,

As Mohan says, just create a couple of new fields (call them date.f and date.t) on your report, with domain tcdate. Then, in your Program Script, define two variables with the same names as external:

Code:
extern	domain	tcdate        date.f, date.t
Then, in your ascript, you can use the variables in (for instance) your SQL query:
Code:
select	xxyyy.* from xxyyy where xxyyy.idat between :date.f and :date.t
HTH,
Rb
Reply With Quote
  #4  
Old 11th August 2003, 11:08
Harley's Avatar
Harley Harley is offline
Member
 
Join Date: Jul 2003
Location: Jakarta
Posts: 39
Harley is on a distinguished road
Baan: Baan Vc - DB: MSSQL7 - OS: Windows
It's work

Great, It's work

Thanks for your help
Harley
Reply With Quote
Sponsored Links
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 10:12.


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