Subreport is prompting for each record

[thisistoni]

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

 

[lbass]

Link each of the parameters in the main report to the corresponding parameter in the subreport by using the dropdown in the lower left corner of the edit subreport links screen to select {?parm} instead of the default {?pm-?parm}.

-LB

 

[thisistoni]

When I do this I am only prompted once for the main report and then the subreport (which is fine), but I end up with 2840 records in my subreport (which is the total results of subreport) for each record in my main report. There is no linking between the employeeid in the main report and subreport. when I add back in the link, I am back to square one with it prompting me at each employee for the date, sequence,etc.

 

[lbass]

I meant for you to maintain the link on employee ID as well.

-LB

 

[thisistoni]

Sorry... So I have my four prompt parameters in the main report linked to the four prompt parameters in the subreport. I have linked them as {?Parm}to{?Parm} (not the default). This pulls the many to many results. So, when I add in the link for employee id (which is not a parm), it matches the data in the subreport correctly to the main report. But as soon as I add the employee id link, I am now prompted for the initial criteria before each new employee.

 

[lbass]

Is there a prompt in the main report for Employee ID? I'm not following why the report would execute employee by employee. It might help if you explained in what marin report section the subreport is located and if you showed the record selection formulas for both the main and the subreports.

-LB