Another newbie question for gurus. I'm new to using Crystal 8.5, yeah I know it's old.

I've created a somewhat huge sql query using "Enter SQL statement directly" into the Crystal SQL designer. (I dislike using the SQL Experts/Wizards/Builder)

Code for the "subreport" query goes somewhere along the lines of

SELECT ...
FROM
( SELECT ...
FROM ...
WHERE accountno = {?parameter} AND ...something different from B ...
) A

right join
SOMEOTHERTABLE

left join
( SELECT ...
FROM ...
WHERE accountno = {?parameter} AND ... something different from A ..
)B

I've tested that parameter using the "refresh" button, which prompts me to input a parameter value. It spits out results correctly.

When I put this into a subreport and link it using Crystal Reports menu > Edit>Subreport Links. All of the subreports are empty. This means to me that the parameter isn't passing from the master report. I've tried various parameter names including the one in the subreport links. I think crystal only appends a "WHERE statement" to my query in the end (WHICH IS NOT WHAT I NEED), but that's only my suspicion. I need it to simply put the parameter value to where I wrote "?parameter"

Is that possible?