SubReport Link using String Formula 1

[TheLibrary]

In the Main report I have an available field IMLITM which has data that includes variations of basic part numbers (such as 7123001, 7123001*OP1 and 7123001*OP2).

I need to link to a SubReport that only has the basic 7 character part numbers in the related field WMCPIL. I want each of the variations to also link to the same basic number in the SubReport.

I've tried combinations of the Left() String formula with no success.

Example:
Main: 7123001 Desc: Housing Top
SubReport: 7123001 stock loc: A210
(no problem when Main IMLITM is 7 char.)

Main: 7123001*OP1 Desc: Housing Top
SubReport:
(no data selected, but should show the same!)

Advise?

 

[Madawc]

Are you compairing like with like? That's to say, if you trim your main-report field, are you also trimming the value in the subreport? Crystal can be very fussy, especially with numerics.

ALso look in the Selection Formula of your subreport. Did it add an unwanted condition check when you made your link?

Madawc Williams
East Anglia, Great Britain

 

[TheLibrary]

Problem Solved!

The link did not add an additonal bad check, I just had an extra one that needed to be removed.

Thanks