Parameter field linking when 1 is a formula

[trsquared]

Background: using Crystal Reports 8.5, two different databases, both oracle. (warning, I'm not a programmer, so formulas do not come easily to me )

I'm trying to link a subreport to the main report via a field called "provider". The problem is the main report uses one data source and the provider comes from a field with codes, like "dway". The subreport also has a provider name, but I use a formula to derive it:
If {DEAL.DEAL_NAME} = "DWW_subscriprion"
or
{DEAL.DEAL_NAME} = "DWW_Adhoc"
then "HNS Pilot"
else Left({@RIGHT},InStr({@RIGHT}, ' '))

@right = Right({DEAL.DEAL_NAME},(Length({DEAL.DEAL_NAME}) - InStr({DEAL.DEAL_NAME}, ')')))

[Basically, I'm looking at a long deal name like "direcway monthly, $13.99" to get a provider called "Direcway"]


How am I going to link the code "dway" from the main report Provider field to the subreport's Provider name that comes from the deal? I need to select on the provider name in both reports.

Any help greatly appreciated. This has vexed me for days.

 

[MColeman]

Create a parameter prmProvider in the main report.

Right click the subreport and create a link between like
dealname and the main report's prmProvider parameter.

Edit the subreport and edit the record selection. Change it so that it selects records based on the subreport's dealname containing the prmProvider string.