| :: Version 2.5.40! - LocaleFile, TextReplacement... :: show all messages | Post a Reply |
 Version 2.5.40! - LocaleFile, TextReplacement... | Post a Reply |
from: Washington, DC
This version features an updated
LocaleFile handler, a new TextReplacement tag and an updated Filter tag. New Properties
- CanFilter:
This property sets whether the use can filter the displayed report. If set to false, the report's filter/ pop up filter button will disappear. This property was requested in the post - Popup Filter
objWiz.CanFilter = False ' will hide the filters TextReplacement Update
The [sql] tag has been introduced to the
TextReplacement field format of the report wizard. Basically, any data within the [sql] tags will be processed at the database level. e.g.
1. [sql]Filed1 * Field2[/sql]
2. [sql]Price*Quantity[/sql]
3. [sql]'$'+CAST((Price - Cost) AS NVARCHAR(12)) [/sql] ' SQL Server
This tag has been introduced as an atempt to solve the issue - Summary and Filters in a Column and also to increase the flexibility of the report wizard by using database level resources
Note::
All statements between the [sql] tags must have valid SQL Syntax for the database in question.
Locale File Update
You can change these text labels by editting/adding the following Locale entries:
<!-- popup filter labels -->
<FilterFieldText>Field</FilterFieldText>
<FilterConditionText>Condition</FilterConditionText>
<FilterValueText>Value</FilterValueText>
<FilterUseORText><![CDATA[ Use <b>OR</b>]]></FilterUseORText>
Click the link below to download the latest copy of the Report Wizard.
http://www.aspwebsolution.com/products/report_wizard/download.htm
Click below to download/view the latest Locale File
http://www.aspwebsolution.com/products/report_wizard/locale_en.xml
Filters Update
The filters have been updated to deal with the issue posted in Summary and Filters in a Column
You can now filter for a group of records such as:
where Product Name is 'Milk' or Product Name = 'Cheese' etc.
This can be done by use of the IS IN filter option
All you have to do is enter a group of values separated by commas for the field value as shown in the image below:
-------------------------
Ghost