Passing a parameter to a stored procedure

[MartC]

I have a main report with multiple subreports, my subreports are using stored procedures. I want to pass a parameter value from the main report to these stored procedures. What can I do?

 

[MalcolmW]

You can share parameters between main and subreports - you link on those parameters. It can be a pain if you use descriptive names for your stored procs, cause the dialog window in SCR only shows about 20 characters for each line of the stored proc and linking field name. Are you OK with the linking part? Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?