Multiple data sources for a subreport ?

[FishyBC]

I am trying to access data for a report using stored procedures in MS SQL Server. I have a main report that provides job details and a linked subreport within it that provides the processes that were performed (general information). I want to get access to process detail information that is only available in a 2nd process detail stored procedure.

So far I have found out that Crystal does not support a subreport within a subreport, that you can only get at the first result set within a stored procedure and I also found out that you cannot join 2 stored procedures together based on a common key.

How can I get at this data if I need to access it from 2 different stored procedures at the same time ?

Thanks for any thoughts
FishyBC

 

[paulmarr]

Fishy,

You could use multiple subreports and shared variables to pass the information back to the main report. Shared variables is one way to pass data from subreports to main reports.

Cheers
paulmarr