We have scheduled about 500 crystal reports on our BOE server (central management console 4.1) to be sent out via email to the external customers. On all these reports, in the ‘destination’ section we have ‘From’ as ‘abc@x.com’ and for the ‘Message’ part we have it written as ‘If you have any questions, please send an email to abc@x.com’
Now, our requirement is to change the from address and the email id in the message part to “abc@y.com”
How can this be done as a mass update rather than updating each and every single report manually?
Is there a way that we schedule one crystal report from BOE to run daily and do not want to send it to customers via email or FTP. We would like to save those daily report files (usually pdf or excel files) at some place and let the external customers go in there and check those reports once in 2 weeks or once in a month.
The only way to accomplish this would be to write code using either the .NET or Java SDK that will update the from address and body of the email.
Schedule the report to a file location that you make available over the web. If you include the datetime stamp in the file name (this will only be the date the report is run…) then you would have a separate file for each run. You could even schedule the report in a publication to burst it to separate files in a different folder for each customer.
All the destinations types I see are: 'Email, ‘BI Inbox’, ‘Default Enterprise Location’, ‘FTP Server’, ‘File System’.
I am sure the first three types will not be helpful for me. FTP Server would work or File System would work in this case? Could you please provide me some details on this.
(BOB member since 2007-04-16)