At 08:37 AM 4/4/2014, Matthew Brock wrote:
Is there a way to call a dialog like the Where Builder from code?
I have a group of reports that i want to give the user the ability
to set sorting and expressions like what is done in the Where
Builder. And I do not want to have to create my own dialogs for
each report.
You can certainly design a cool user interface to use the #WHERE
clause in R:BASE.
If you know the Primary Table name associated with that report,
you can use the following simple example to achieve your goal.
Using the RRBYW18 sample database ...
Report Name: ColumnarReport
Table Name: Customer
-- Example
CLS
SET VARIABLE vWhereClause TEXT = NULL
CHOOSE vWhereSortClause FROM #WHERE IN Customer +
OPTION THEMENAME Longhorn
IF vWhereClause = '[Esc]' THEN
GOTO Done
ENDIF
-- vWhereClause will contain all selected parameters
-- Do what you have to do with the vWhereClause here
LABEL Done
CLEAR VARIABLES vWhereClause
RETURN
Having said that ...
2014 R:BASE eXtreme 9.5 (32/64) Sample Applications include a
custom designed, universal "R:Report Print Manager", ready to
use with any database(s), that looks like this ...
www.razzak.com/sampleapplications/files/RRPM_01.jpg
www.razzak.com/sampleapplications/files/RRPM_02.jpg
www.razzak.com/sampleapplications/files/RRPM_03.jpg
www.razzak.com/sampleapplications/files/RRPM_04.jpg
www.razzak.com/sampleapplications/files/RRPM_05.jpg
www.razzak.com/sampleapplications/files/RRPM_06.jpg
www.razzak.com/sampleapplications/files/RRPM_07.jpg
www.razzak.com/sampleapplications/files/RRPM_08.jpg
www.razzak.com/sampleapplications/files/RRPM_09.jpg
www.razzak.com/sampleapplications/files/RRPM_10.jpg
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
