multiple stored procs in crystal report 9

[windfallent]

Hi all,
I am using crystal report 9 with a window based program written in c#.net. If i use two or more stored procs in a single crystal report , it hangs....
where i amgoing wrong ??????
pls suggest.
thnx in advance....

 

[MisterMo]

You should never use more than one SP in a report

Do your joining on another SP and then call the last SP on your report

Mo

 

[bobpv]

You can create the 2nd sp as a subreport and link it into the main report as well.

But Mo is correct, best solution is to rewrite the SP to include all fields needed in the report.

 

[synapsevampire]

Thinkk of it this way, how would Crystal know which recordset you are intending to display?

If you're returning 2 datasets, Union All them into one within another SP.

-k

 

[windfallent]

Hi bob!
---You can create the 2nd sp as a subreport and link it into the main report as well.

I tried this solution!
But i m not able to pass parameters to subreport. It pop ups parameter window. i m not able to pass parameters Progrmatically. Is there any different way to pass parameters to a sub report while calling to main report.


Can u guide me in this?

And also i m looking for CR 10 trial version or free download. Can u provide me links?

Thanks

 

[pandpp]

Right mouse click the SubReport, Change Subreport Links...

Peter.