| :: New Functionality - Version 2.5.67 Released :: (1) | Post a Reply |
 New Functionality - Version 2.5.67 Released | Post a Reply |
from: Washington, DC
Properties
- DefaultFilterFieldIndex
This property can be used to set the default index for the user filter and popup filter screen. e.g.
'to always default to the third field in the drop down
objWiz.DefaultFilterFieldIndex = 3
- DefaultFilterConditionIndex
This property can be used to set the default index for the user filter and popup filter screen. e.g.
'to always default to the first condition in the drop down
objWiz.objWiz.DefaultFilterConditionIndex = 1
New Method
- AddHiddenSqlFilter
This method -AddHiddenSqlFilter(tableName, filterCondition),can be used to programatically add an extra condition to any report/table call by the report wizard. This method is especially usefull in security cases where you always want to hide some confidential data.
For example: to hide all the rows in the employees table that contain upper management information (e.g. salary), you can do the following:
Call objWiz.AddHiddenSqlFilter("Employees","NOT (ReportsTo<2 OR ReportsTo IS NULL)")
The above statement will make sure that whenever, data from the employees table is displayed, only employees who do not report to anyone or report to someone other #1 are displayed.
Note: This method must be called beforeDisplayReports
New Functionality
- Getting distinct records for you filter text.
This means that you can switch from the plain textbox control for your search text value to a drop down list containing only the values present in your table column. To better explain this, consider the image below:
1. In the dialog wizard, at the select filter screen, if you click on the # button, it will switch the search text field into a drop down list containing only distinct values from the selected table field. Click on the same # button will switch the drop down control back to a text box. See the image below:
2. This same functionality is also available to the end-users custom filters. Thje difference is the end-user will have to click in the search textbox and then press the F9 key to switch to the drop down list as shown in the images below:
To switch back to the textbox, select the "Other" option of the drop down list. This option is the last item in the drop down list.
Note: This functionality is not yet available in the PopupFilters
-------------------------
Ghost