Upper Case and Lower Case??

building reports webintelligence legacy
1

Hello,

I just can’t seem to figure out how to make a string value go to upper case or lower case in WebI6? :confused:

anybody has any idea?

Thanks,

Leroyb

leroyb (BOB member since 2004-02-16)

2

Hi,

There doesn’t seem to be a function to do the same in WebI6. Suggestion: Try to do that in the designer itself.

If this doesn’t help, let us know the exact requirement, someone can give alternative.

ravi.

palepuravi :india: (BOB member since 2003-10-28)

3

Ravi,

thanks for your answer …

[begin rant]
I must admit that I am a bit (well … very) surprised of not having one of the most basic string functions available through WebI! … didn’t they try to gather user requiremetns before they started to build the thing? … I can’t believe that nobody during the testing phase noticed that you can’t UPPER or LOWER (or UCase/LCase) strings using variables! :reallymad:
[/end rant]

… is there any way of using equivalents of the VB Chr or Asc functions in WebI? this might provide a alternative or not?

any help would be greatly appreciated,

cheers,

Leroyb

leroyb (BOB member since 2004-02-16)

4

Hi Leroy

I have the same issue - I can’t send UPPER() to the database since this will negate the index on the column and I have already converted the database to upper case for all text fields. Since we are not using Oracle 10, I don’t have the ability to easily perform case insensitive queries…

…so I came up with an alternative solution, not brilliant but gets my users the result they want. Here’s how it goes:

  • convert all the data in the database to uppercase
  • create a JavaScript function to enumerate the prompt form for all text fields and systematically perform a .toUpperCase() on the values
  • include this function and calls to this function in the relevant WebI .asp and .js scripts

It works a treat and I am quite pleased with the results, however the following should be observed:

  • this only works because (a) all the data is uppercase and (b) all text is converted to uppercase from prompts
  • this does not work when using the prompts within the Java report panel, only HTML version of the prompt when running the report

Does this sounds like a solution you could implement?

Cheers

Neil

Neilly (BOB member since 2005-04-11)

5

Hello Neil,

thanks for your answer.

Not a bad solution at all, except that we are not allowed to customise anything for now :frowning: … its a shame, because we chose the ASP implementation and that’s something I have some skills in and I could do all those changes myself!

I think we will simply have to live with this. I hope that BO is listening and that they will implement such functions in new releases. :yesnod:

Thanks,

leroyb

leroyb (BOB member since 2004-02-16)