I have 2 PeopleSoft queries that are prompting on the same values (EffDate, EffSeq, Action, Action_Reason).  One query supplies the container (heading and footer information) and the second query has the meat of the report.  When I run these queries independently, I am only prompted once for the variables.  (Once for each query).

I am only linking the subreport to the main report by a fifth value (employeeid), however, everytime I flip to the next employee, I am prompted again for the EffDate, EffSeq, Action, Action_Reason.  

The report pulls the accurate data, it just prompts for every employee record.  If I don't link by employee, the result is one to many records.

The second query (subreport) needs to run independently (can not use the variables from the main report) because the query itself has the logic to pull the current employee detail record and the previous employee detail record.

I am using Crystal 9 and Oracle 9i