Blog - Crystal Reports for Visual Studio .Net 2003 Parameter Passing

Crystal Reports for Visual Studio .Net 2003 Parameter Passing

Location: Blogs Living in Software Development
Posted by: host	11/30/2006 6:58 PM
Today I wrote a Report for a client using Crystal Reports for Visual Studio.net 2003. The report uses two stored procedures in MSDE as the datasource for the main report and one subreport. Both stored procedures use the same parameter name, and when I first ran the report I received multiple parameter prompts, even though the parameter name in both stored procedures is the same. There is a linking that can be done between the main report and the subreport to suppress the duplicate parameter prompts. The way you do it is to open the report in Visual Studio. Right click the subreport in the design view of the main report and click "Change Subreport Links." From the Available Report Fields list, I selected the parameter from the Report Fields and added it to the "Field(s) to link to:" list. As soon as I did that, a new control popped up below the two lists where I could select the subreport parameter to link, and then the multiple prompts issue was squashed.

Permalink \| Trackback