Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cognos 8.4 Report Studio Filter [field] does not start with 1

Status
Not open for further replies.

CrystalLion

Programmer
Jan 3, 2007
113
US
I am new to Cognos Report Studio. I am trying to create a filter something like the following.

([Database View].[A_ALM_HISTORY_VW].[DIM_FILED_NAME]
does not start with('Auto','Con','Other')
what is the correct syntax for this.

Thanks[bigears]
 
Code:
([Database View].[A_ALM_HISTORY_VW].[DIM_FILED_NAME]not like('Auto%')
and
([Database View].[A_ALM_HISTORY_VW].[DIM_FILED_NAME]not like
('Con%')
and
([Database View].[A_ALM_HISTORY_VW].[DIM_FILED_NAME]not like
('Other%')

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top