create new group using formula that doesnt show in group expert 1

[girky]

Hello,
I'm having trouble creating a new group in crystal. Currently I have a report that displays billing data and is sorted employee, project, date. Then it displays a total for each employee. There are multiple detail lines per day that i suppress and display totaled in group footer for each day. The problem I am having is when an employee's billing rate changes I need to display separate totals for each rate. So really I want the report sorted employee, billing rate, project, date. To get the billing rate i have a formula:
if {Type}="R" then
BillingRate := {Regular_Rate}
else
BillingRate := BillingRate

this works great and carries over the billing rate to lines that have no rate, the problem is I can't use this as a group sicne it doesn't show in the group expert. Is there any other way I can accomplish my goal?
Thanks!

 

[lbass]

I'm betting you added "whileprintingrecords;" at the beginning of the formula. If you remove it, the formula should be available for grouping.

-LB

 

[synapsevampire]

Your formula doesn't seem like it would work without additional dependencies, since BillRate was never set to anything to begin with, more importantly the formula should error out as BillRate isn't declared, so please post all relevent information.

Generally you would have something like:

if {Type}="R" then
{table.Regular_Rate}
else
0

This should then be available at the group level.

-k

 

[girky]

Yes, I did. That fixed my problem. Thanks so much lbass!

 

[synapsevampire]

...

Right, please post your entire formulas in the future instead of pseudo code.

-k