How to ignore case on report definition column

General
, , , ,
1

Hi All,

While pulling the data using report definition, I am able to get different results if the entered data has case sensitive combinations. Ex: If the data entered is abc, ABC, Abc, the report definition fetches 3 results. I want to ignore this and show only 1 result. How can I achieve this.Please note It is not a filter where I can check ignore case. It is a column. I have checked remove duplicates checkbox as well. Can somebody help me on this?

Attached the screen shot displaying results.

Thanks in advance,

Sakhib Hussain

Column.png
Column.png984×240 6.79 KB

2

Hi @SakhibHussain ,

Just to understand your query in a proper way, can you please let me know, why you trying to understand as a duplicate? In Db, many records may contain with same name (which also includes case sensitive). You also stated it as not to consider it as Ignore case to filter the values. I failed to catch the exact query of yours.

3

Hi @Mohammad Ravoof,

If you see the attachment, I just want a single result because a person will enter his name with different case and the requirement is we have to display in a dropdown only with single value. In the attachment, I want to display only as single “Sakhib” not other two.

For your question: In Db, many records may contain with same name (which also includes case sensitive)->Yes correct. I want to display the same name once(ignoring all other records)

why you trying to understand as a duplicate–> I understand it is not a duplicate but, I wanted to omit other cases. This is my requirement.

You also stated it as not to consider it as Ignore case to filter the values–> Because in filter we have already one checkbox for ignore case and not for columns.

Thanks,

Sakhib Hussain

Column.png
Column.png984×240 6.79 KB

4

Hi @SakhibHussain,

In order to achieve this you have to select Display (Top Ranked/Bottom Ranked) at the bottom of Report Definition and select Rows as 1 and select Overall give the property for which you want case sensitive to be ignored. This works.

Thanks,
Deeksha MD

5

@DEEKSHA

But this will only display very first row result if the word is same but of different case.

I agree with @Mohammad Ravoof , we should not consider the query result as duplicate and in DB many records may contain the dame name. May be I need to find some other way to display the above leave as is.

Thanks,

Sakhib Hussain