In Arev when using RList you could use the following in a statement

?"input data"?

which would act as a run-time variable (the user would type in the selection criteria).

i.e. sort orders with order_month=?"input data"?

Does anyone know if there is a similar function in the Selection Criteria part of the Query in I.O. Reporter or any work around solutions?

Many thanks.

Ian

[notag]By far the easiest work around is to do all of the selection in R/BASIC then save the list and use a GETLIST in the reporter query.

[<A HREF="http://www.sprezzatura.com" onMouseOver="window.status='Click here to visit our web site?';return(true)">The Sprezzatura Group</A>]

[<I>World Leaders in all things RevSoft</I>]

[<img src="http://www.sprezzatura.com/zz.gif">]

[<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0";}end hiding from non-JS browsers –></script>] [<FORM ACTION "" METHOD=GET NAME="TOCNavigator" <SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()"> <OPTION>Pull down this menu to choose whereabouts on the Sprezz site to go <OPTION VALUE="http://www.sprezzatura.com">Home Page <OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New (Thanks Mr Clark) <OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL <OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST <OPTION VALUE="mailto:[email protected]">Send mail to support at Sprezzatura <OPTION VALUE="mailto:[email protected]">Send mail to sales at Sprezzatura </SELECT> </FORM>][/notag] </QUOTE> —- === At 26 NOV 2001 03:05PM Don Miller - C3 Inc. wrote: === <QUOTE>See Sprezz's general response (use R/BASIC and GetList in Reporter). You'll be glad to learn that it isn't supported in OI's version of R/LIST and only partly supported in Sprezz's S/LIST (only one LIMIT clause allowed in S/LIST (unless the smart guys fixed it). Also, unless they have my changes to their parser, interactive ?…? don't work in LIMIT clauses. Don </QUOTE> —- === At 27 NOV 2001 01:07AM Donald Bakke wrote: === <QUOTE>Ian, As Don Miller and Sprezz have pointed out, this can't be done using the reporting tools by themselves. FWIW, the ability to use inline functions was discussed at some length several years ago with Jim Aquaviva. I was attempting to point out that AREV's R/List had to create symbolic fields (i.e. functions) on-the-fly in order to support this feature. Therefore, the OpenInsight runtime restriction against functions being written by the application was in conflict with this feature… …then Jim pointed out that inline functions did not exist in OpenInsight. Whether this was done to support the license restriction or simply because it was more than they wanted to do at the time I don't know. But there you go. [email protected] SRP Computer Solutions, Inc. </QUOTE> —- === At 27 NOV 2001 02:15AM The Sprezzatura Group wrote: === <QUOTE>[notag]You CAN actually do it in reporter using the hybrid reporter basic and dialog boxes. It then does go off and generate symbolics on the fly if required. It's just that it's easier to do it in R/Basic <g>. [<A HREF="http://www.sprezzatura.com" onMouseOver="window.status='Click here to visit our web site?';return(true)">The Sprezzatura Group</A>] [<I>World Leaders in all things RevSoft</I>] [<img src="http://www.sprezzatura.com/zz.gif">] [<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0";}end hiding from non-JS browsers –></script>]

[<FORM ACTION "" METHOD=GET NAME="TOCNavigator"

<SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()">

<OPTION>Pull down this menu to choose whereabouts on the Sprezz site to go

<OPTION VALUE="http://www.sprezzatura.com">Home Page

<OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New (Thanks Mr Clark)

<OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL

<OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST

<OPTION VALUE="mailto:[email protected]">Send mail to support at Sprezzatura

<OPTION VALUE="mailto:[email protected]">Send mail to sales at Sprezzatura

</SELECT>

</FORM>] [/notag]

You CAN actually do it in reporter using the hybrid reporter basic and dialog boxes. It then does go off and generate symbolics on the fly if required.

I figured the dialog boxes and such could be done with Reporter's language support. However, I did NOT know that it created symbolics on the fly. I wish I had known that at the time as this was all pre-reporting license (aka The Dark Ages).

[email protected]

SRP Computer Solutions, Inc.

[notag]That was our big argument about S/List at the time. If you look in the dictionary after a reporter report you'll see all these temporary items %%thisand that. We maintained that if a runtime Reporter could do it, a runtime S/List ought to be able to.

Fortunately the new management are much more reasonable to deal with on these issues and actually seem to wish to implement [<i>fair</i>] licensing policies.

[<A HREF="http://www.sprezzatura.com" onMouseOver="window.status='Click here to visit our web site?';return(true)">The Sprezzatura Group</A>]

[<I>World Leaders in all things RevSoft</I>]

[<img src="http://www.sprezzatura.com/zz.gif">]

[<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0";}end hiding from non-JS browsers –></script>] [<FORM ACTION "" METHOD=GET NAME="TOCNavigator" <SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()"> <OPTION>Pull down this menu to choose whereabouts on the Sprezz site to go <OPTION VALUE="http://www.sprezzatura.com">Home Page <OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New <OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL <OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST <OPTION VALUE="mailto:[email protected]">Send mail to support at Sprezzatura <OPTION VALUE="mailto:[email protected]">Send mail to sales at Sprezzatura </SELECT> </FORM>] [/notag] </QUOTE> View this thread on the Works forum...