I want to know how query is to be written in a program script to generate a report using filters like inrange
Pls explain with example for a sample report.

I want to know how query is to be written in a program script to generate a report using filters like inrange
Pls explain with example for a sample report.

Hello,
do not double post, please.

Search the forum with "inrange" and you'll get a lot of hints.

Regards

hi,
you can refer this example

choice.cont.process:
on.choice:
execute(print.data)

choice.print.data:
on.choice:
if rprt_open() then
read.main.table()
rprt_close()
else
choice.again()
endif


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

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


|****************************** function section ******************************

functions:

function read.main.table()
{
select tdpur400.*
from tdpur400
where tdpur400._index1 inrange {:orno.f}
and {:orno.t}
order by tdpur400._index1
selectdo
rprt_send()
endselect
}

Does LN have a session to "generate sessions" like 4c4? I almost always run that to give me a starting session for maintaining or printing a table. On 4c4 it is ttadv2290m000 - you can generate a session on a table and see the script it builds and the reports it builds.