I wrote some code to add filters to my report using StiFilter. I discovered that when I add an Expression I pass the column name as table.field. However, when I add a Value I can only use the field name or it will not work.
In the Filters UI an expression looks like this:
Field Is: Expression
Value: Incident.Category = CategoryParameter
In the Filters UI a value looks like this:
Field Is: Value
Data Type: String
Column: Category (note table name is not present)
Operator: equal to
Value: Hardware
I was wondering what I would do if there were two different tables that had the same field name?
Value Filter does not use table name
-
- Posts: 62
- Joined: Mon Dec 11, 2006 1:43 pm
- Location: U.S.A.
Value Filter does not use table name
In the column property in the Filters Tab you should specify a column which belongs to the DataSource of the DataBand. Each DataBand can has only one table as a DataSource.
If you mean field through Relation, in that case relation name will be added.
If table contains two columns with same names, such report will not be compiled, because class can not exists with members having the same names.
So for two different tables you should specify different DataSources for the DataBand.
Thank you.
If you mean field through Relation, in that case relation name will be added.
If table contains two columns with same names, such report will not be compiled, because class can not exists with members having the same names.
So for two different tables you should specify different DataSources for the DataBand.
Thank you.