I would like to know if it is feasible to create a stored procedure that can execute and SSRS report with the output of the report going to either .xps or .pdf format where the .xps or .pdf file is then stored in a SQL table.
In terms of feedback on this concept, I am not bound to a stored procedure. If the answer is that a C++ program can call SSRS, produce the desired report output and then store that image in the database, that is fine as well.
As to why we want to do things this way, the answer is the the report is a legal document where it needs to be created one time only and stored for several years. Although the data to create the document is also in the database, the regulators insist that the document not be generated on demand.