stored proc with input para and subreport

[alank01]

crystal 8.5 sql 2000 stored procedures with input para.

main report proc1 with p1,p2,p3
sub report 1 proc2 with p1,p2,p3
sub report 2 proc3 with p1,p2,p3

question: while report is printing can a requery of a stored procedure in a sub report be issued with changed values of p1,p2,p3

for example if sub report 1 is embedded in a group on the main report and the group value changes the stored procedure para should be changed to reflect this fact and the SP should hopefully requery with appropriate information.

thanks, i hope i have asked a reasonable clear question.

 

[kenhamady]

If you link the paramter of the subreport to the group field of the main report ( a 'linked subreport' ) then it should run with a different parameter value for each group. Right click on the subreport object in design and select 'change subreport links'. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com