Topic
3 replies Latest Post - ‏2013-06-25T17:37:45Z by DanielWagemann
TheBrenda
TheBrenda
58 Posts
ACCEPTED ANSWER

Pinned topic Scheduled job(s) output to same Excel workbook

‏2013-06-25T13:35:54Z |

Re: Scheduled job(s) output to same Excel workbook

I have several Report Studio reports that I need to put on a schedule with input parameters and then email to various clients. The clients do not want multiple Excel workbooks. They want each report to be a worksheet in a single workbook, Any advice or tips on how to accomplish this?

Thanks

Updated on 2013-06-25T17:32:00Z at 2013-06-25T17:32:00Z by TheBrenda
  • DanielWagemann
    DanielWagemann
    850 Posts
    ACCEPTED ANSWER

    Re: Scheduled job(s) output to same Excel workbook

    ‏2013-06-25T17:19:33Z  in response to TheBrenda

    The only thing I can think of here is creating a report for scheduling only which consists of a merger of all you individual reports.  The excel worksheets are driven by the report pages. So if you have one "report" per page it would give you the sheets your are looking for.
     

    Of course there is always the post processing programming which would capture the results of each report and merge them using the SDK or some other programming approach outside of the BI environment.
     

    Updated on 2013-06-25T17:20:45Z at 2013-06-25T17:20:45Z by DanielWagemann