Eclipse Community Forums: BIRT » UPPER in analysis query

Home » Archived » BIRT » UPPER in analysis query(I need help working in the UPPER expressions into my sql expression filter)

Show: Today's Messages :: Show Polls :: Message Navigator

UPPER in analysis query [message #1786881]

Mon, 14 May 2018 17:51

Jeremy Schreier

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!

Report message to a moderator

Re: UPPER in analysis query [message #1786994 is a reply to message #1786881]

Thu, 17 May 2018 01:31

Jerry Sheets

Messages: 76
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

Report message to a moderator

Previous Topic:	crosstab presentation problem - different row level measure's aggregation
Next Topic:	BIRT Runtime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:08:35 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter