Author Topic: Creating an expression in Report Studio  (Read 108 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
70 Views
Last post April 02, 2009, 05:43:44 AM
by MrSpecialist
3 Replies
138 Views
Last post September 10, 2014, 08:02:09 AM
by CyborgRepublic
2 Replies
64 Views
Last post Yesterday at 11:08:16 AM
by nomadic
0 Replies
55 Views
Last post December 14, 2016, 10:15:08 AM
by MrSpecialist
0 Replies
64 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.