crystalvictim
Programmer
Hi,
I'd like to know if there's a solution for the following problem I'm dealing with since quite some time without success:
I have an ordinary report that's retrieving data from a table.
I've written an oracle stored procedure / function with two parameters that inserts the values of its parameters into a certain table.
Now I'd like the stored procedure to be executed with parameters based on the main report's table fields (most likely by creating a subreport based on the stored procedure).
The problem is, that CR expects me to enter the subreports' parameters (i.e. the stored procedure's parameters) when running the main report. Yet, I do not want to specify them manually, as the subreport is meant to get them from the main report's table fields.
Has anyone succeeded in accomplishing this with CR8.5/10 or XI?
Thanks in advance for your comments.
Frank
I'd like to know if there's a solution for the following problem I'm dealing with since quite some time without success:
I have an ordinary report that's retrieving data from a table.
I've written an oracle stored procedure / function with two parameters that inserts the values of its parameters into a certain table.
Now I'd like the stored procedure to be executed with parameters based on the main report's table fields (most likely by creating a subreport based on the stored procedure).
The problem is, that CR expects me to enter the subreports' parameters (i.e. the stored procedure's parameters) when running the main report. Yet, I do not want to specify them manually, as the subreport is meant to get them from the main report's table fields.
Has anyone succeeded in accomplishing this with CR8.5/10 or XI?
Thanks in advance for your comments.
Frank