Crystal sorting

[pmacduff]

Once again I need the expertise of the Relius/Crystal users! I have a custom Employee Status Report that sorts by HCE code, by category and then by name. I want my names to run right after one another, even on a change of one of the sort items. (This report used to work before!) Now it is sorting the employees and participants in the correct order with the HCEs first, but after the HCEs, it is resetting to start the NHCEs on the next page leaving loads of blank space. I've tried everything I can think of from suppressing blank lines to starting over and I cannot get this to work. Any suggestions would be appreciated. Oh yes - I'm still on version 7.3. (Hoping to move to 8+ when it slows down).

[Tom Poje]

in crystal, on the left hand side of the report, if you right mouse click and then select format section, is the section that does the hce/nhce sort set to 'new page after'?

[pmacduff]

Hi Tom - No - no "new page after" setting in the format of the group for HCE/NHCE or the "Details" section. I'm lost.........

[Fredman]

Along Tom's idea, is the "keep together" option checked? It may be trying to "keep together" a group on the same page.

[pmacduff]

Fred - Yes - I looked for the "keep together" as well. It was in there at one point, but I have removed it. I guess I will have to break down & submit an incident to Relius. Thanks for your help Tom & Fred. Patti

[Fredman]

If you are in a hurry, you can attach the report here or email it to me and I will take a closer look. I don't have Relius so I won't be able to refresh the data, but I can poke around to see if I see anything else might be causing your page break.

[pmacduff]

Sorry Fred - my Benefitslink is telling me I cannot upload this type of file. I'll keep trying and let you know how I make out. Thanks again. Patti

[Tom Poje]

hmmm. maybe something broke again. you used to be able to attach a .rpt file.

you could try asking Burgermeister Dave Baker. he is usally pretty good about fixing stuff if that is what the problem is.

[pmacduff]

I thought I would try again today to attach my *.rpt file - it looks like it worked...let me know if anyone can find out why the report is spacing after the HCEs. It never did that before!!! Thanks in advance. Patti

FDPDETAILHC.rpt

[Fredman]

Here's a stab in the dark:

Click (from the top menu), REPORT->CHANGE GROUP EXPERT

Select your first group (PLANEE.....) then click options

At the bottom there is a "keep together" boxed checked. Uncheck this and press OK.

Cross your fingers and refresh your data.

[Tom Poje]

Patti:

aside from the problem you are having, I think the sort has a possible problem

If I understand things correctly

you have a sort

HCE code

category

last name

first name

If two people had the same name the system would not print one of them.

I only say this because I had a similar report and two people named

for example, John Smith - and the second one would never print

usually you would have an additional sort 'soc sec #' to prevent that.

(or replace 'last name' with rptee.sortname

and replace 'first name' with SSNUM)

[pmacduff]

Thanks guys - it worked with a combination of both suggestions. I went into my "Change Group Expert" and unchecked all of the "keep group together" boxes in each group per Fred's suggestion. The report was still isolating my HCEs on one page. I then changed my 'last name' to rptee.sortname and 'first name' to rptee.ssnum per Tom's suggestion and voila....report is working fine just the way I want! I really appreciate the help, anyone who works with these reports knows that you can go crazy over getting what you think is a simple thing to work! Thanks again

[Tom Poje]

Thanks for the compliments, although I'd classify the solution to more of a lucky guess! I didn't expect it to help your problem!

Hopefully you won't have too many reports that you have designed that might have the same 'problem' lurking about.

By the way, at Relius 8 any report with user fields has to be fixed by adding a new table - sometimes twice if you are using both plan spec user fields and census user fields. if it gets to that point, I have a powerpoint explanation about going about that process. It is a bizarre concept (at least to me) using the same table to pull data from both census and plan specs.

ANd be careful, I lost a lot of my user field info when I converted.