store procedure in CR X! 2

[Durango122]

hi guys
Cr XI
MS SQL database
I have a main report that has a storeprocrdure
the sub report has a storeprocedure
can i link these to storeprocedure?
Can i pss a parameter to from the main to the sub?

thanks



Durango122

 

[dk87]

Yes you can. You can link your subreport to main report data or to a formula.

 

[Durango122]

hi
thanks for the input
So I can link these 2 storeprocedure on a commom field?
if not
i can pass a parameter from the main to the sub report?
is that what your saying
thanks



Durango122

 

[dk87]

Yes, that is correct

 

[Durango122]

hi
so witch one is right
the first one link the procedure2
or 2. pass parameter

sorry for the confusion

Durango122

 

[dk87]

You can do either or both. What is it you want to do? If you want to pass a parameter from the main report to the subreport, use sub report linking. If you want the user to enter a parameter for the subreport (sp2), don't do anything. They will be prompted. You did not provide much information, so it is hard to guess.

 

[Durango122]

Hi
Thanks alot
sorry not being clear on what i was asking
you see my storeprocedures do not contain any parameter
at all
1. I was asking if i could link these 2 storeprocedure on one commom field from both
2. Or i can create a parameter from cr report to link subreport
Old version of cr did not permit to link storeprocedure
sorry



Durango122

 

[synapsevampire]

You don't need to create a parameter, just link the field in the main report to the field in the subreport.

I think that you're mistaken, you could link a main report based on a stored procedure to data in a subreport based on a stored procedure, what you could not do was link stored procedures to stored procedures within the same report

-k