How to handle case sensitive using web report when CS database is designed as case sensitive

Dharani Devi · 2025-05-15T09:33:14+00:00

There was an error rendering this rich post.

Hi,

Can anyone help me on this.

We are passing user names as CSV source file to Web Report in any of the format ( like it includes upper and lower case letter) and we are trying to match these users names with Database. Based on the match we have to perform some functionality. Here, the problem is database is designed as case sensitive. We tried with CAPITALIZE tag in webreports but it didnt work the way we expected.

For example the user names are in DB like V-TestM and V-ACC-DemoP. but we are passing the user names in webreport in different formats like v-testm,V-acc-demoP (these two coming from CSV file and I believe we have to convert these two user names as every first letter is in upper case followed by lower case letters i.e. V-TestM, V-ACC-DemoP so then we can match the user names with DB.

Thanks in advance.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

All comments

GregPetti

Hi,

I'm not entirely sure of all the mechanics of what you're doing, but can you not convert value to upper or lower case in the DB query so they match?

In terms of what you are doing now, it appears the case application is too random for CAPITALIZE. If you have a WebReport associated with a LiveReport that is doing the SQL query, you could consider using the WebReport to do the matching using [LL_WEBREPORT_IF statements. By default this tag is case insensitive. The problem with this approach is if there are large amounts of data coming from the LiveReport as this can affect performance.

Cheers

Greg