[_includes/top.htm]

HowTo for Argos Free-Type Filters and Sorts (from the Argos Listserv)

Post From: Raju (Lakshmikara R. Padmaraju)
Oper Support Serv Spec IV
Eastern Illinois University

We allow the DataBlock designer to put a "placeholder" in the SQL for where these sorts and filters will be put.  If a user creates a report with a custom sort or filter, Argos will simply replace the placeholder with their custom SQL.  Robert Hagmaier

Hello Argos’rs,

Place holder is possible only with Free type SQL not with Visual Design. This is the limitation.

  This feature available in Argos from nov07 onwards. I used this features extensively.

 1st screen shot - Here is the Report query with place holders for Filter(--$addfilter) as well as for sort(--$beginorder --$endorder).

Place the cursor inside the query after the From clause wherever you have add place holder and press   and you get screen like bellow(2nd screen shot) where you can add new filter ( for whole where clause), ADD filter ( single line like AND or OR clause), Begin order and end order( this should always at the end of Select statement).

3rd screen shot shows how I added Filter to the report design use Filters TAB( only active if there is place holder in Report query otherwise grayed out)

4th  screen shot shows how I added sort to the report design use Sort TAB( only active if there is place holder in Report query otherwise grayed out)

Simply you can type it or you can move from left side window to right window and choose ascending or descending.

 

1.


2



3

 

4

 

This is an internal use page maintained by Bruce Knox ( bknox at uaex.edu ) documenting a single University of Arkansas, Division of Agriculture, Cooperative Extension Service IT project. 

[_includes/bottom.htm]