Hi Bill,

This is a tricky problem and I cover the details of how to solve it starting on page 361 of my book Crystal Reports Encyclopedia

I'm going t assume that you have the parameters in the subreport working with the stored procedure. The problem you are running into is that when you link the parameters in the main report to the subreport then you get prompted twice for what should be the same parameter.

The problem is that when you link the parameters in the main report to the subreport that you are accepting the default subreport field of "?PM-..." This is a parameter that CR has created by default and "recommends" that you link to by putting it as the first item in the dropdown list of fields. Using this parameter is causing your problem. What you want to do instead, is to ignore the ?PM- parameter and click on the dropdown list and find the existing parameter that you already created for your stored procedure. By linking directly to the parameter created for the stored procedure and not the intermediate ?PM- parameter, you will only get prompted a single time and that same value will be used for both the main report and the subreport. Do this for all three parameters and you should be good to go!

I have tons of tips and tricks for working with subreports in Chapter 9 of my book Crystal Reports Encyclopedia.

I had just finished reading this section when the issue came up in the company for the first time.  I set things up the way the book described, but I was unable to get rid of the extra set of parameter prompts.  I searched the user's report for any other references to a sub report, but was unable to find any.