extract values from different stored procedures and create one report
If the stored procedure only returns one result set, and you know the column names in advance, then you can create a temp table and Insert #TableName Exec ProcedureName. You would then select the value you want into a variable from the temp table, and run the procedure again.

If it only returns one result set but you don't know the column names in advance, you can use this solution (https://stackoverflow.com/a/1228165/401970) to call the procedure within an Openrowset and put the results into a temp table it creates for itself with the returned column names.

SELECT * INTO #MyTempTable FROM OPENROWSET('SQLNCLI', 'Server=(local)\SQL2008;Trusted_Connection=yes;',
     'EXEC getBusinessLineHistory')


If the procedure returns multiple result sets then you're not going to be able to do a solution in T-SQL only. You can write a simple PowerShell script to do it, but that's not really going to help if they need to get the result directly from the database.