I am new to Cognos. I am running 2 SQL statements that I built in Toad and have run successfully for quite some time. I am scheduling them to run specific days of the week in Cognos, and having the output emailed to a user. Report A must be run prior to Report B because Report A returns a value that must be used as a parameter to run Report B.
I would like to have Report A run, then pass that value to Report B, run Report B, then email both to the user instead of me manually performing these steps. Can anyone guide me with how to get the value, and pass it? (These reports are built with SQL versus the reporting views because the table the data resides in is a custom table, not delivered with our Banner system).
Thanks so much!