Topic
  • 3 replies
  • Latest Post - ‏2013-06-25T17:37:45Z by DanielWagemann
TheBrenda
TheBrenda
70 Posts

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

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

    ‏2013-06-25T17:19:33Z  

    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
  • TheBrenda
    TheBrenda
    70 Posts

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

    ‏2013-06-25T17:30:30Z  

    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.
     

    Approach 1 - merge all the reports into a single report. Each of the reports has their own prompt page. Can you have a scheduled report that has multiple prompt pages or would i have to merge all the prompts into a single prompt page.

    Approach 2 - post processing. Are you referring to the SDK at http://www-01.ibm.com/support/docview.wss?uid=swg21367562   ?  Would that possibly allow me to pass parameters and run reports and then combine the outputs into exce?

     

  • DanielWagemann
    DanielWagemann
    850 Posts

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

    ‏2013-06-25T17:37:45Z  
    • TheBrenda
    • ‏2013-06-25T17:30:30Z

    Approach 1 - merge all the reports into a single report. Each of the reports has their own prompt page. Can you have a scheduled report that has multiple prompt pages or would i have to merge all the prompts into a single prompt page.

    Approach 2 - post processing. Are you referring to the SDK at http://www-01.ibm.com/support/docview.wss?uid=swg21367562   ?  Would that possibly allow me to pass parameters and run reports and then combine the outputs into exce?

     

    In theory you should be able to get away with multiple prompt pages, but it would be best just to do a quick test.

    That is part of it, I was thinking along the lines of http://public.dhe.ibm.com/software/dw/dm/cognos/development/how_to/handling_report_output_using_the_cognos_sdk.pdf

    I think there is even an example of merging PDF files via SDK  on the Proven Practices site.

    http://www.ibm.com/developerworks/library/ba-pp-development-utilities-page643/