Skip to Content
avatar image
Former Member

How to schedule multiple reports in simple way

Dear Experts ,

I have designed more than 25 reports using sap crystal report 2013 . Now i want to schedule all those report in cmc and trigger email on daily basis . In folder options -> right click -> add local document -> adding each and every report individually and scheduling reports .

Is there any simple way to do this , all 25 report i want to schedule on daily basis and need to trigger a email for ABC@gmail.com

Is there any option where i can put all rpt files under single folder and i can schedule a folder , so that all 25 reports can trigger and send through email .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Apr 18, 2017 at 06:34 PM

    Added two secondary tags: SAP BusinessObjects Business Intelligence Platform and Platform Administration. The question belongs to those components.

    From Crystal Reports perspective you can select a main report and add all remaining 24 reports as unlinked subreports in Reports Footer subsections. It would be then a single report to schedule.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Dell ,

      Thanks for your reply . In main report i have added few reports in report footer as unlinked subreports . But in preview its displaying only main report output .

      Also when i try to schedule in cmc , Just i am receiving Single mail with main data output value .

      But in my case user want to receive each rpt output in separate mail i,e (1 main report +24 sub report = 25 mail ) .

      Please suggest .

  • Apr 18, 2017 at 07:50 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18, 2017 at 11:53 PM

    I would suggest you to take a look at publication capability to schedule multiple reports in one go.

    https://howtobi.wordpress.com/2011/02/23/how-to-setup-report-bursting-data-driven-publication-in-businessobjects/

    Thanks

    Mani

    Add comment
    10|10000 characters needed characters exceeded

    • The problem with using publications is that when a report changes, the changes aren't automatically picked up by the publication. Instead, you have to delete the report, save the publication, then re-add the report and reconfigure the report within the publication. Then you have to reschedule it.

      -Dell

  • Apr 19, 2017 at 03:04 PM

    Another option, if you don't want to look at a third-party tool for this like Ido posted, you could look at using either the Java or .NET SDK to schedule the reports. If you're using Crystal for Enterprise instead of "classic" Crystal, you could also use the RESTful web services SDK.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 21, 2017 at 10:46 AM

    If its Crystal Reports, then why don't you create an Object Package for the same. It will be easy to define the schedule for all the reports at once. I think this will be the best option for you.

    Add comment
    10|10000 characters needed characters exceeded