Jump to content

Filter on Calculated Column in Information Designer

Shri G

Recommended Posts

The filter in Information designer is used like the "Where" Part of a TSQL query. Depending on what your Database type is it could change the filter. An example would be If on the filter I wanted only those Accounts that are customers.

You could bring in the field that has the Type Customer, then under the expression, you would put

%1 = 'Customer'

You can make filters with additional columns also. They would be under the alias up top (%2, %3).

Once you save the filter you would add the filter to the Information link as a column.

Is the above what you wanted to know

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...