Reporter basic+ syntax (OpenInsight Specific)
At 28 OCT 1997 07:30:32AM Michael Moran wrote:
I need some help with Reporter's implementation of Basic+ in query. I know I can do a GETLIST LISTNAME to retrieve a list that I created before executing a report. But how do I then re-sort this keylist.
For example I want to do this :
GETLIST LISTNAME
SELECT BY
Reporter seems to ignore the SELECT. I cant sort using the Sorting option in Query because this is ignored when you do a getlist.
Please help.
Michael.
At 29 OCT 1997 09:52AM Don Bakke wrote:
Michael,
I can't answer your exact question but why don't you sort the select list before saving it then all you have to do is the GETLIST command from Reporter?
At 29 OCT 1997 08:03PM Michael Moran wrote:
Cos I dont want to.
No … the real reason is that I am passing the select list that is created in a window query to reporter, and the sorting may be different depending on the report that they choose to run (and we all know that QBF doesnt allow the BY keyword that was available in Arev).
I know there is a long way of doing it by allowing them to re-sort the select list before executing the report, but I was hoping to put the sorting in the actual reporter report (and the GETLIST seems to override the sorting specified in the report).