Codejock Developer Community : Sorting currency columns

Sorting currency columns : Thanks to both contributors on...

Mon, 05 Dec 2011 10:46:07 +0000

Author: PurposeSoftware
Subject: 19257
Posted: 05 December 2011 at 10:46am

Thanks to both contributors on this.

A mixture of both answers has sorted the problem.

Ultimately it seemed that the setting of the Item.Value in the _ValueChanged event causes the sorting to go wrong.

Thanks again for the very fast response.

Cheers, Col

Sorting currency columns : I have tried adding Aaron's...

Mon, 05 Dec 2011 04:38:45 +0000

Author: PurposeSoftware
Subject: 19257
Posted: 05 December 2011 at 4:38am

I have tried adding Aaron's suggestion to my CodeJockReportV1.zip project (don't know if you received that as I can't see it above - even though I am sure I posted it).

However that doesn't allow sorting to work. Still get 200 in the middle.

Will now try jbpro's suggestion.

Sorting currency columns : Hi, Easiest way, to prevent...

Sat, 03 Dec 2011 12:49:33 +0000

Author: Aaron
Subject: 19257
Posted: 03 December 2011 at 12:49pm

Hi,

Easiest way, to prevent showing '0' is to use Metrics.Text in BeforeDrawRow event

' ** CODE ADDED HERE
    If Item.Index = clmPriceFixed Then
        If Item.Value <> "" Then
            If Item.Value <> 0 Then
                Item.Caption = Format(Trim(Item.Value), "##0.#0")
            Else
                Metrics.Text = ""
            End If
        End If
    End If
    ' ** CODE END

Sorting currency columns : I've put together a little...

Fri, 02 Dec 2011 23:27:41 +0000

Author: jpbro
Subject: 19257
Posted: 02 December 2011 at 11:27pm

I've put together a little sample to demonstrate what I think you are looking for:

uploads/2676/ReportSwapEdit.zip

I used Currency values for the numbers (instead of double), and empty strings instead of NULL values. I did this because when I tried using NULL for field values, the RC was randomly sorting the NULL values interspersed with the number values. This appears to be a bug.

Does this help, or have I misunderstood your requirements?

Sorting currency columns : I have 2 columns of currency type.And...

Fri, 02 Dec 2011 11:33:00 +0000

Author: PurposeSoftware
Subject: 19257
Posted: 02 December 2011 at 11:33am

I have 2 columns of currency type.

And the user is required to enter a value in either column but not both.

So when they enter a value in either of the cells the other cell gets set to null (blanked).

The problem we had was with sorting the currency.

If I entered 10.00 on the first row, 200.00 on the second and 30.00 on the third the sorting would put the 200.00 in the middle.

So looking at examples on the forum, I changed the item.value to be double and not string. This resolves the sorting issue but I now cannot have a null cell on that column. Further examples in the forum state I can use the item.caption but this seems not the best way to do it as the item.value may get changed in code and the new value is not reflected on the grid. It also causes problems with formatting.

The attached examples are:

CodeJockReportV1.zip - shows the way it originally worked setting a cell to blank when the other is entered.

Enter data as :

A 10

B 200

C 30

Sort the Fixed Price column by clicking the column header.

Notice that the order is wrong.

Also notice how we want it to work, ie. enter a value in the Fixed Price column, then move to the Discount column and enter a value in there. It clears out the Fixed Price cell. And vice versa.

So, the second example attached (CodeJockReportV2.zip) was an attempt to resolve the issue.

The only differences are :

1. AddRecordPart adds the FixedPrice as double and not a string

2. ClearHeaderRow defaults the FixedPrice to zero from null.

3. _BeforeDrawRow formats the value

But I cannot get it to null the other column's cell data and format the number.

Sometimes when entering 8.87 it rounds up to 9.00 but you may not experience this once written correctly.uploads/6827/CodeJockReportV2.zip