Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » UPPER in analysis query(I need help working in the UPPER expressions into my sql expression filter)
UPPER in analysis query [message #1786881] Mon, 14 May 2018 17:51 Go to next message
Jeremy Schreier is currently offline Jeremy SchreierFriend
Messages: 1
Registered: May 2018
Junior Member
Can anybody explain how to correctly type in the UPPER function into a converted SQL filter.

Currently I am using

(UPPER("XXXX.XXXX")) <> "XXXX.XXXX"

Obviously XXXX = equals the table and data field.

The reason I am trying to do is because I am attempting to create a report showing me the values that do not match these two, but one is stored in upper case and the other in lower case and the its returning everything.

Thanks!
Re: UPPER in analysis query [message #1786994 is a reply to message #1786881] Thu, 17 May 2018 01:31 Go to previous message
Jerry Sheets is currently offline Jerry SheetsFriend
Messages: 68
Registered: July 2009
Location: Salt Lake City, UT
Member
You don't need the "'s unless you are converting/comparing constants

As I read you statement you are comparing the literal TableA.XXXX to the literal TableB.xxxx
Previous Topic:crosstab presentation problem - different row level measure's aggregation
Next Topic:BIRT Runtime
Goto Forum:
  


Current Time: Fri Sep 21 19:11:24 GMT 2018

Powered by FUDForum. Page generated in 0.01757 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top