Harley
11th August 2003, 09:39
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

mohan05
11th August 2003, 09:55
Hi

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

-Mohan

RobertB
11th August 2003, 10:24
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:

extern domain tcdate date.f, date.tThen, in your ascript, you can use the variables in (for instance) your SQL query:
select xxyyy.* from xxyyy where xxyyy.idat between :date.f and :date.tHTH,
Rb

Harley
11th August 2003, 12:08
Great, It's work

Thanks for your help
Harley