Baanboard.com

Go Back   Baanboard.com > Blogs > pralash's blog

User login

Frontpage Sponsor

Main

Poll
When will you move your ERP to the cloud?
We are on the cloud already!
20%
Next year
8%
from 2-3 years
8%
from 4-5 years
16%
Never!
48%
Total votes: 50

Baanboard at LinkedIn


Reference Content

 
Basic Report in ERP Ln
By pralash at 10 Feb 2017 - 10:42

Hi,

 

I'm freher to ERP Ln... I am create a Report and also execut it successfully.

But i can't get the clear idea of the following codes in the programming script. 

 

|****************************** declaration section ***************************

declaration:

 

  table   ttfedu710 | testing table 3 employee

 

   extern  domain  tfedu.inte       emid.f

   extern  domain  tfedu.inte       emid.t 

 |****************************** field section *********************************

field.emid.f:

when.field.changes:

   emid.t = emid.f

 

functions:

 

function read.main.table()

{

    select tfedu710.*

    from tfedu710

    where   tfedu710._index1 inrange {:emid.f}

                                    and {:emid.t} 

    order by tfedu710._index1

   selectdo

       rprt_send()

   endselect

While i execute the sesion, i'm getting two text box for getting initial and last employee id....

But in the previous script, the value of emid.f is assigned to emid.t....

So how can i get the report from 1 to 5 (if i give 1 and 5 are the first and last value)...

 Anybody please guide me....

 

Thanks

Pralash 

 

 

 

 


0
No votes yet

by manish@erpln on February 13, 2017 - 1:28pm
Hello Pralash,

It's a default value of "last employee" that is coming due to the below code written in your script i.e. whatever the value will entered in first employee field will be assigned to last employee input field as well.

field.emid.f:
when.field.changes:
emid.t = emid.f


So you can change the value of Last Employee input field.

For example :-
Put 1 in first input field , press tab and then put 5 in second input field( or change the value of second field).

Thanks,
Manish Kumar


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


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