Search results for query: *

Good Point...thanks for taking care of it!..t

Naith, Your fix worked. My dashes are actual dashes and were in the middle of the field rather than at the end (my example showed them at the end). I changed the RIGHT to MID and changed the '' to ' ' so that the rest of the field could be sorted correctly and it fixed the problem. Thanks...

I am trying to group a report by a formula field. When my data is returned, that formula is sorted with alphabetics before characters like '-'. I am using a Sybase database. If I do the sort on Sybase, the -'s are before alphabetics but since this is a formula field the sort is done on...

That did it. Thank you so much....t

Yes, I did and I need to. I should've thought of that. Is there another way that I can identify that I'm on the report footer? Thanks...t

That is exactly what I did when trying to solve it on my own. However, it then suppressed the GH on the last page of every group. Does it reset TotalPageCount for each group ??? Is there another way to identify last page (or report footer)? Thank you. Theresa

Thanks for the help. The intent is to print the group header on every page except the report footer. I think this should be accomplished using the 'Repeat Group Header on Each Page' group option. The group footer should print at the end of the group, on the same page, if possible. The...

The group header is being suppressed by Crystal on pages where the group footer winds up on a page by itself. I am using Crystal 8.0. My report looks like: Group Header (on every page except report footer, new page before each group) Details Group Footer (on same page as details, unless the...

Naith, thanks again for your time. I am obviously a Crystal novice. I customized to show decimals up to 5 chars, all pieces have zeros beyond 2 and the total is 0.00000 (no negatives).

I tried suppressing if the formula is less than zero. This didn't change anything. I think this was because the formula returns exactly zero. Below are data values for one example: Paid commit = {LAYERS.CGL_EXP_COM} = 0.00 +{LAYERS.HPL_EXP_COM} = 0.00 +{LAYERS.CGL_IND_COM} = 0.00...

Thanks to both of you. I thought for sure that would be it but it wasn't. None of the fields have any null values and I don't see how anything can get rounded here. My formula looks like this: If {LAYERS.POL_TYPE} <> 'T' then {LAYERS.AGGR_LIMIT}-{@PaidCommit}+{LAYERS.VARIATION} else 0 In...

I have a formula that conditionally returns a numeric field or zero. I have the format set to suppress if zero. Sporatically in the report, when the formula returns a zero, it isn't suppressed. I can't see a pattern for when it doesn't suppress. Has anyone seen and conquered this problem...