on 04-18-2017 6:45 PM
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 .
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would suggest you to take a look at publication capability to schedule multiple reports in one go.
Thanks
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
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 .
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.