Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking a Subreport to diff values ?

Status
Not open for further replies.

acrouch

Technical User
Oct 29, 2001
9
AU
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

 
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},":")-1)

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

-k kai@informeddatadecisions.com
 
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},":")-1)


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top