Matthew,
The below code lets you choose a view, select columns and use the where builder. Just run this from the R: Prompt to see what it does. Can be called from eep. It will open up a whole range of things you can do. Just substitute for your needs. You can also build a form with 2 date pickers and choose a date range if necessary for reports. CHOOSE VTAB FROM #VIEWS AT 4 10 TITLE 'Select View' LINES 30 CLS CHOOSE VCOL FROM #COLUMNS IN &VTAB AT 4 10 CHKBOX TITLE 'Choose Columns' LINES 30 CHOOSE VWH FROM #WHERE IN .VTAB AT 4 10 LINES 30 BROWSE &VCOL FROM &VTAB &VWH CLEAR VAR VTAB VCOL VWH CLS RETURN Hope this helps. Larry Forck CMU From: [email protected] [mailto:[email protected]] On Behalf Of Matthew Brock Sent: Friday, April 04, 2014 7:38 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Where Builder 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. Thanks, Matthew D. Brock
