More than 1 stored proc in CR

[windfallent]

Hi... I have used 2 stored procs in my CR (in .Net and SQL 2000), I can see the return parameters of both sp in the Database-->Fields section.

Even the parameters fields hv parameters from both the sp's. But they do not get fired as expected. Instead the proj hangs.

Is there a limit to the no. of sp's used in the CR. How do I make the CR 9 know the # of sp's in my report??

Thanks in advance !!

 

[MisterMo]

CR would treat them as table but because SP's also have some logic eg. parameters you could end up having endless problems or conflict.

properly designed SP could be used but I'd rather write all my logic on a single SP and then add it to my report.

the idea is to let the database do all the leg work (as much as possible)and CR output the result with all the trims and decos.



Mo

 

[synapsevampire]

CR does not support multiple recordsets.

You give no indication as to how these 2 SP's are intended to be used, as Mo suggests, you probably want to combine the code of the 2 SP's into 1. This may mean rewriting them into 1 SP, or perhaps even a UNION of the code for both SP's.

-k

 

[windfallent]

The 2 sp's work entirely in a different manner.

One calculates complex mathematical sums and Averages.

The other retrieves values based on various criteria provided from the Parameters section...

So there is no way I can combine the logic of the 2 sp's.
If i use the 2 sps in my CR ,It hangs.

Using either of the sp shows me the correct o/p corresponding to that sp.

 

[MisterMo]

Could you give a gist of the SP's so that we can have a thinkle

I find hard to believe that by using cursors or procedures the SP's cannot be subdued to do what you need

Mo

 

[flowersr]

Mo,

I am noticing that in CRW7 that when I select the stored procedure for the subreport it throws up a screen for me to enter the parameter value plus there is a check box that says 'Check to set NULL value'.

I entered a 0 for parameter and leave check box unchecked.

When I run main report I get nothing in subreport. However If I open subreport, it also has 2 parameters and if I run it I get good results.

TIA,
Rich