FordFairlane
Programmer
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 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, but when I tried to repeat the situation it said I was not allowed to link Stored Procedures.
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
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 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, but when I tried to repeat the situation it said I was not allowed to link Stored Procedures.
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