Hello Forum Members,
There are some reports in crystal reports which are scheduled to run automatically every week and generates a pdf output and emailed to users. These files/reports give the sales information for California state. The requirement is, if the total sales are below $100000 the report instance title should say Report Instance title name - bad. If the sales are above
$100000 and less than $150000 then the report instance should say Report Instance title name - good. If the total sales are above $150000, then the instance title should say Report Instance title name - Excellent.
Data cannot be passed from the report to Business Objects. The only way to maybe do this would be to develop a vbscript that reads the data field you want to compare and rename the file after that.
Technically speaking, this can be accomplished. It’s a little wacky, though.
First, you need to set up some sort of scheduled job outside of BOXI to read the information from your database and determine which report you need to send. This job should then create a text file in a folder that the BOXI system user has access to. Name the file appropriately (e.g., “Bad.txt”, “Good.txt”, “Excellent.txt”). The files do not actually need any content.
Then, create three file-based events in BOXI. Each event will watch the folder for one of the three files to appear. When it does so, the event will be triggered.
Then, create three copies of the document, each with separate titles. Or, if it is acceptable, one document, but three schedules with different email subject lines. Each schedule should be linked to one of the above events.
Now, assuming you’ve set it up all correctly, here is how it will play out. Your weekly cron job or database job or whatever will check the results of a query in the database. It will then create an appropriate file in the designated folder to let BOXI know which report title to fire off. The event in BOXI will see the file appear, and trigger. The appropriate schedule executes when the event triggers, sending out the email with the document with the appropriate title.
mtoedtemeier,Lugh
I really apreciate for taking your time and providing solutions to my problem.
I am not aware of vbscript. I will try to implement the solution from Lugh.
It looks like it can be accomplished. Thanks a lot for that incredible solution.