Linking Stored Procedure to other SQL Tables

[FordFairlane]

Hi People,

I'm having a problem where-by I've created stored procedures that are recursive and return a single result set - I can use this to save someone creating 40 plus reports by adding the procedure like a table and then linking one of the result columns to a column in another table already in the report.

I need the result set to drive the selection of data from the existing report and table structures.

Can this be done? ie linking a Stored Procedure result set to other tables or do you need to create a blank report for the SP and link it to a subreport.

CR 8.5 allowed me to link the SP to a table (did not work too well), so when I tried to repeat the operation it said I was not allowed to link Stored Procedures to tables.

Otherwise is there a way of programming in CR similar to the VB modules in Access, whereby I can create a recursive procedure to select the initial dataset?

Can anyone advise me please?

Regards
Ralph

 

[Madawc]

I used subreports to access data in tables, using linked parameters based on values in the Stored Procedure Madawc Williams
East Anglia
Great Britain