View Single Post
  #1  
Old 10th February 2017, 10:42
pralash pralash is offline
Member
 
Join Date: Feb 2017
Posts: 62
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Basic Report in ERP Ln

A new blog entry has been added:

Basic Report in ERP Ln

Quote:
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 
Reply With Quote