Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Using table values as prompt inputs Post Reply Post New Topic
Author Message
hello
Groupie
Groupie
Avatar

Joined: 05 Feb 2014
Online Status: Offline
Posts: 85
Quote hello Replybullet Topic: Using table values as prompt inputs
    Posted: 18 Dec 2019 at 3:48am
Hello:

CR 11.0

Have created a simple invoice report and would like to send the same report to multiple customers automatically using Business Objects scheduler on a weekly basis.

Is this possible? I was hoping I could just 'hook' the report to a table with all our customer data and set it up to run every week.

After Googling the topic, it seems like maybe the SAP Business Views add on to Business Objects would do this. Can anybody verify that I am going in the correct direction?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 23 Jan 2020 at 10:48am
If you're still working on this, the way to handle this would be through a Publication. However, I'm not sure whether Publications are available in BusinessObjects XI, which is what I assume you're using based on the version of Crystal. Unless "11" is from "2011", in which case this will work.

You would create a report off of the customer data table that includes the name, email address, and relevant fields for filtering the original report for each customer. The original report becomes the "Source Document" and the customer report becomes the "Dynamic Recipients" document. Under "Personalization" you'll match the fields from the customer report to the matching fields in the source report. Set up format and destination, then schedule the publication. It will automatically burst the source report and send it to the customers.

-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.