Prompt for SP cursor parameter

[xsw1971]

I am using CR8.5 and Oracle 8.1.6.

I have a report with a subreport that's based on a stored procedure. I had everything working just fine - the report prompted the user for 2 dates only; those 2 dates and an ID got passed to the procedure for processing.

I started doing some formatting of the report, now suddenly when I refresh for new parameters, I am being asked for the 2 dates along with the stored procedure's in/out cursor value. If I leave the cursor prompt blank and just provide the dates, it works fine. However, my users will be confused about that parameter and I will spend a lot of time trying to explain to them that they should leave it blank.

What could I have changed that it now requires that parameter? I would like to get it out of the user prompt.

Thanks,
Jennie

 

[synapsevampire]

Right click the subreport and select Change links and verify that the link from the main report is set properly.

Then go into the subreport and check what's in the Record Selection Formula->Record.

-k

 

[xsw1971]

Thanks for the reply. Yep, I've already tried both of those methods and I cannot find anything out of the ordinary. The cursor parameter shows up in the subreport's Field Explorer parameter list - it has a green check next to it but I can't find any place where it is referenced, nor can I delete it. It wasn't in the parameter list before...