Skip to Content
0

How to schedule multiple reports in simple way

Apr 18, 2017 at 05:45 PM

272

avatar image
Former Member

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 .

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Vitaly Izmaylov
Apr 18, 2017 at 06:34 PM
0

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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Vitaly ,

Thanks for your reply , All 25 reports should be sent individual mail , if i place all 24 reports in footer section as subreport ,may be there is a chance to affect performance .

Instead of that , now i am using object package option to add all rpt files under single section . Now its reducing work to schedule each and every report individually .

All 25 reports connected with same DB and user need it in pdf format .

when i schedule Object package , there is a component option to select database login and report format .

Here i am selecting each and every report individually and selecting pdf format .

Instead of that , is there any default settings to apply one time ?

0

Sriram,

There won't really be any affect on performance by putting all of the reports as subreports in a single report. The reports will run sequentially, just like they will from an Object Package or a Publication.

-Dell

0
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 .

0
Ido Millet Apr 18, 2017 at 07:50 PM
0
Share
10 |10000 characters needed characters left characters exceeded
Manikandan Elumalai Apr 18, 2017 at 11:53 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0
Dell Stinnett-Christy Apr 19, 2017 at 03:04 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Kuldeep Ghosh Apr 21, 2017 at 10:46 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded