Adventures at 10 Options

[Tom Poje]

this is my first
looksee at 10...

Nondiscrimination report: Overall Report

The sort is by RateGrpID, which appears to assign a number to each HCE alphabetically.
however, when my report prints, it sorts in the following manner

1
10
11
12
13
2
3
4
5 etc.
Thus people at the end of the alphabet get sandwhiched between the other employees. I imagine there is someway to set something in Crystal to make this work, but since I don't know how....
fortunatelly the report is in Crystal so easy to modify. In fact I was able to add an item that will tell how many additional NHCEs are needed if the nondiscrim classification test fails on an individual. well heck, an idiot like me finds that useful.

[bernie lomax]

Do you mind sharing the report?

[Tom Poje]

I don't mind sharing as long as it is understood I have tried this on one plan, and only one plan, though I can't see how the calculation logic would change.
On the report I have included the number of NHCEs, number of HCEs, total testable ees, NHCE concentration % and midpoint.
report should check to see if an HCE ratio % > midpoint, if not then it multiplies the midpoint by the HCE ratio % * total # of NHCE. then it subtracts the # of NHCEs benefiting to produce the number of additional NHCEs needed. (well, I add .5 and then round)


by the way, I doubt this will run from custom, so it would 'replace' the existing Relius report. this is the landscape version. you would probably want to rename the actual Relius report just so you dont lose it if this report doesn't work.

This post has been edited by Tom Poje: Dec 30 2005, 09:48 AM

[rcline46]

Tom, don't you realized this is a character field, not a numeric field, and therefore the sort is 'correct'.

[Fredman]

What if you create a new formula field that checks the length of RateGrpID and if equal to one, add a leading zero to it. For example...

if length({RPTPLANGNDRATEGRPTEST.RATEGRPID} ) = 1 then
'0' + {RPTPLANGNDRATEGRPTEST.RATEGRPID}
else
{RPTPLANGNDRATEGRPTEST.RATEGRPID}

If you have more than 100 HCEs, you would need two leading zeros for lengths of 1 and an additional if/then to add a leading zero to lengths 2 characters.

Then in the formula "@Rate Group / HCE Name" replace {RPTPLANGNDRATEGRPTEST.RATEGRPID} with {@name of the formula} above.

This should now sort like...
01
02
03
04
05
06
07
08
09
10
etc.

[Tom Poje]

Fredman: I simply modified to sort on name.

RCline: I did not know that the sort was on a character field. In that case, that is one of the most stupid sorts I have ever seen in a report.