Linking a Subreport to diff values ?

[acrouch]

Hi All,

I need to link a field in my sub report which is usally fine except this time the values will sometimes be slightly different.

eg: Report 1 123456-1:name
123456-2:name

124567-1:name

Report 2 123456:name

124567:name

Basically to link these two reports I need to remove the -1 etc from the value I think....

I have absolutely no idea so any help is greatly appreciated.
Thank you in advance for your replies...

Antoinette Crouch

 

[synapsevampire]

I think that you're right, so create a formula with which to link:

I'll call it @NameParse
left({MyTable.Name},instr({MyTable.Name},":&quot-1)

When asked for the field to link to, choose @NameParse

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[acrouch]

I created the formula as above but when I view the resaults it is not returning the result I require

orig result = 123456-1:name

result with formula = 123456-1

Req result = 123456:name

Have I done something wrong ?

I have copied the formula I entered.

left ({PURCHORD_HDR.REFERENCE}, instr ({PURCHORD_HDR.REFERENCE},":&quot-1)