Wednesday, June 29, 2011

Crystal Reports : Using a specified Group Sort Order

When selecting sort options for your Group, select Specified Order. Notice that a Specified Order tab appears when you do so. Simply choose in which order you’d like your Group printed. This is helpful in situations (for example) when the Group named "Thirty Days" must come before "Sixty Days", yet "Ninety Days" must be the last. Note that neither Ascending nor Descending order will solve this problem.

3 comments:

nick22 said...

How would use the specified sort order tab and ensure that empty or null values came last?

Justin Hill said...

I don't think you can do this with the Specified Sort Order; I don't believe NULL or blank appears in the list.
What I would do personally is create a formula to test for NULL or blank and then just sort on that.

So you could create a formula called "FieldName" with the following code:

IF ISNULL({TABLE.FIELD}) = TRUE OR {TABLE.FIELD} = "" THEN "NULL" ELSE {TABLE.FIELD}

NULL's are always difficult to deal with... Hope this helps!

chenlina said...

louis vuitton outlet
ralph lauren outlet
washington wizards jerseys
christian louboutin outlet
coach outlet online
new balance sneakers
hollister
nhl jerseys cheap
louis vuitton handbags
coach handbags
chenlina20170228