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?