Author Topic: Creating an expression in Report Studio  (Read 118 times)

0 Members and 1 Guest are viewing this topic.

Offline h2obubbler

  • Full Member
  • *
  • Posts: 228
  • Karma: +0/-0
  • Life is like a box of chocolate.
    • View Profile
Creating an expression in Report Studio
« on: October 14, 2008, 05:26:10 PM »
How to create an expression in reportnet.

I have two expressions that work, but I need to combine parts of the two. I have worked with database stuff for awhile, but am new to Cognos stuff and can\'t seem to get it quite right. This one works:

CASE  WHEN [JOB].[EMAIL_JOBS_E].[EMAIL_TYPE] IN  (10,9,8) or [LIST_ID] IN (1,2,3,4,5) THEN [JOB].
    .
[DESCRIPTION] ELSE \'N/A\'  END

This one works:

CASE WHEN [JOB].[EMAIL_JOBS_E].[EMAIL_TYPE] = 11
THEN \'E-Mail\'
ELSE [JOB].[List Description]
END

I need to combine parts of the two and make it so that

(WHEN [JOB].[EMAIL_JOBS_E].[EMAIL_TYPE] IN  (10,9,8) or [LIST_ID] IN (1,2,3,4,5) THEN [JOB].
    .
[DESCRIPTION]) or (WHEN [JOB].[EMAIL_JOBS_E].[EMAIL_TYPE] = 11) THEN \'E-Mail\'
ELSE \'N/A\'  END



Any idea?

Techronnati | where technology never sleeps

Creating an expression in Report Studio
« on: October 14, 2008, 05:26:10 PM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
78 Views
Last post April 02, 2009, 05:43:44 AM
by MrSpecialist
3 Replies
187 Views
Last post September 10, 2014, 08:02:09 AM
by CyborgRepublic
2 Replies
110 Views
Last post August 23, 2017, 11:08:16 AM
by nomadic
0 Replies
73 Views
Last post December 14, 2016, 10:15:08 AM
by MrSpecialist
0 Replies
82 Views
Last post December 14, 2016, 10:20:26 AM
by MrSpecialist

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.