Hello,

I would like to generate a report from a table that has the following columns: Id Name Age Sex Date_of_birth

I can set it up so that my entry html form has a text box to read in the Rlist cmd:

And in my inet_report (request)

I can can process the Rlist_txt and call :

rtext=Inet_QueryParam(request, 'RLIST_txt')

varHtml=Inet_rlist(request,rtext)

return varhtml

This process is great, but I am limited to making only 1 command line before the report is returned to the html browser.

For example if I typed in this command in my html text box :

"LIST tableA with or with and with age ] 20 and with sex=F' "

When hitting summit I get a report that has 1 column of keys that match that filter criteria.

What I want is to be able to enter :

"LIST tableA with or with and with age ] 20 and with sex=F' "

AND

"List tableA by Name by age Name Age Sex"

So ideally, I would have the report return a table that has 3 columns:

Name Age Sex.

Where Name is the primary sort, and Age is the secondary sort

Any help will be much appreciated!

Your current Command String:

]]

"LIST tableA with or with and with age ] 20 and with

sex=F' "

AND

"List tableA by Name by age Name Age Sex"

]]

Should read

"List tablea (with or with 20) and (with sex=F') by Name by age Name Age Sex"

Note that this is a single select, sort and output specification all in one buffer.

HTH

Don Miller

C3 Inc.

Thanks for your help Don!

View this thread on the forum...