Straight Table repeating values

[#1]

Hi Guys,

I have a straight table, which is repeating values as below. How do I get the straight table without duplicates?

NOTE

• I have used =1 as an expression and have kept it as a hidden expression.
• I do not want to 'Suppress When Value is Null' on that field because Policy Number is an options field
• So if I suppress that field then it will only show me cases where they have policy number but i want to see all the cases.
• I also do not want Pivot table.

About the Data Model

• @ symbol is primary keys which are hidden from users.
• Each OrderID can have more then one Case ID
• Each OrderID can only have none of max 1 Policy Number

Thank you.

[maxgro]

Check if Order Date is a true date (without decimal); you can try this adding a listbox for Ordere Date formatted as Timestamp.

You can use the floor function to remove the time from Order Date.

[#3]

Thanks maxgro‌,

This how I am loading the order date

Date(Floor(ConvertToLocalTime(CreatedDate))) AS  [Order Date]

And this is how the order date list box looks like as a timestamp

[maxgro]

coukd you post your .qvw or a small extract of that with the problem?

[#5]

No worries..

Here it is..

[Anil_Babu_Samineni]

Hello,

In fact, That is not possible because You have select the Case ID, Order Date --> Those Duplicate dates depend from Case ID. Two case ID's are different. Just identify that let me know.

- Anil

[#7]

Thank Anil,

Thats the thought i had since beginning but looking at the data that field (Case ID) is only repeating once in the actual table. and i could not find repeating corresponding field for that value

[Anil_Babu_Samineni]

Like This..

[agni_gold]

This might help

[#10]

Thank Anil, How to merge rows like this?