Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using output from a stored procedure/select statement as a parameter

I'm 90% sure this isn't possible, as I haven't been able to find information about it anywhere, but this is what I'm trying to accomplish:

I'm re-configuring standard reports for use in a new, read-only and static (read: is about 5 minutes out of date) environment, and the way we save reports is via a header, containing information specific to that report. I want to use two data sources - the first to retrieve the saved header information from the transactional database, the second to use the output from this to drive the connection to the read-only, reporting database. I know it's possible via parameters, however I would like not to have to expose the reporting controls as it makes them only too easy to fake, and I know it is also possible, as we are developing in .NET, to build a custom data-set and then base the report of this.

At the moment I am favoring the latter approach however does anyone know if it is possible to use output as parameters? Or if there is another, more elegant solution to this problem?

Former Member
Not what you were looking for? View more on this topic or Ask a question