Can I ask what brought you back to CR from SSRS? Did you bail on SSRS or are on a new project that only uses CR?

Re your question, this is a common problem people have. I put it in the "Best of the Forum" section of my new Encyclopedia book.

You have the right idea about adding a link from the main report to the subreport, but CR has a trick that you need to use to prevent the multiple prompting problem. When creating the link, CR automatically creates an intermediate variable to pass the value to the subreport. This is what is shown by default in the bottom left-hand corner of the dialog box. What you need to do is click the drop-down box and select the actual parameter that the subreport uses. By doing a direct link from the main report to the subreport, the user won't be prompted multiple times.

You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.

The post you linked to looks pretty good. I would think that it would work for you once you got any bugs worked out. However, This is a lot of work for a simple fix. It uses the runtime object model to do multiple tasks and you just need to link a couple subreports together. Try what I suggested as see how that works. I think it will be a much cleaner solution for you.

Glad to hear it!

The quick way to update a parameter is to use the following code:

myReport.SetParameterValue("Country", "USA")
myReport.SetParameterValue("Country", "USA", "subreportname")


Note that the first is the name, the second is the value, and the third is the subreport name (leave blank when passing to main report).

I cover this in Chapter 16 of my book.  You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.