## pass values between groups

## pass values between groups

(OP)

Hi all,

I have four pieces of data

Main Job Number

Sub Job Number

Estimated Value

Invoiced Value

So the main job number always ends in '0' (EG 123456/0) and on the main job the estimated value is stored

However all invoices are raised on the sub jobs... (EG 123456/1, 123456/2 etc...)

I am trying to write a crystal that looks the estimated values versus the running total of the invoices values, however I am struggling because the main job never has an invoice raised on it I cant get the main job estimated total and the sum of all invoices raised to date to appear on the same line or in the same group etc...

Can anyone help?

thanks in advance

David.

I have four pieces of data

Main Job Number

Sub Job Number

Estimated Value

Invoiced Value

So the main job number always ends in '0' (EG 123456/0) and on the main job the estimated value is stored

However all invoices are raised on the sub jobs... (EG 123456/1, 123456/2 etc...)

I am trying to write a crystal that looks the estimated values versus the running total of the invoices values, however I am struggling because the main job never has an invoice raised on it I cant get the main job estimated total and the sum of all invoices raised to date to appear on the same line or in the same group etc...

Can anyone help?

thanks in advance

David.

## RE: pass values between groups

//{@Job}:

Left({table.jobno},instr({table.jobno},"/")-1)

Next create a formula like this:

//{@Estimated Cost}:

Stringvar x := {table.jobno};

If val(mid(x,instr(x,"/")+1))=0 then

{table.amt}

//{@Invoice Amt}:

If val(mid(x,instr(x,"/")+1))>0 then

{table.amt}

Insert sums on each formula at the group level.

-LB

## RE: pass values between groups

The main job and sub job number is a different field...does that make a difference?

## RE: pass values between groups

-LB