Schedule sending (not Bursting) a crystal report via Email to report users

The status of the schedule is only an indication that the schedule was kicked off. it doesnt mean it was successfully completed.

if you arent receiving the email it could mean you dont have rights to any of the data in the report or that your email device isnt set up right.

have you tried to test your device yet?

I am the owner of the report. I am able to run the report and see data in LBI from Report Actions using, View Latest Instance, View with Data Refresh and View this Instance.

I did a device test. The following is the setup and the results from my testing.

Reporting Services Administration->Server Administration->Email and Printer Settings

Device Type Tools->Manage Device Types
Name: E-mail Device Type
Description:
Medium: E-mail
Host: SMTPServer.mycompany.org
From: LawsonLBI@mycompany.org

Device Tools->All Devices
Name: Email Test
Owner: {Main Lawson system user id}
Description:
Address: Alan.Gersh@mycompany.org
Device Type: E-mail Device Type

Device Tools->Delivery Test
Send an email delivery to a user or role
Recipient Name: {My Lawson user id}
Is Role: Unchecked
Clicked Send, I do not get a test email. And the following message is displayed on the Test Delivery Service screen "No recipients to whom to send the content."

Send a delivery to a specific device
Get devices for user: {Main Lawson system user id}
Select a device for user "{Main Lawson system user id}" to send delivery to : Email Test
Clicked Send, I receive a test email.

so seems there is something off with your delivery device. Double check that the Lawson system user is using the same Device Type as your ID. Have you looked in the WebSphere log files yet? Any clues there?

Which folder/directory should I look in for the WebSphere log files? Is there a particular files(s) I should look at?

it differs depending on you installation of websphere but the files you want are SystemOut.log and SystemErr.log.

Hello, Were you able to get this to work? I am having the same issue and nothing is being logged in the Websphere log files suggested.

If possible, you can look at the Crystal RAS logs as well. They should be under Business Objects folder then depending on your version ours is \BusinessObjects Enterprise 12.0\Logging

This may give you another clue.

I would start by verifying that Bursting works when viewing it OnDemand. If it is, then I would verify that you are able to do an email only. Dont forget, if you are attaching the report in your schedule (which I assume you are) you cant attache it as RPT format.

I am trying to email the report to myself (the owner) with no bursting. I selected the following on the Maintain Schedules...Bursting and Distribution screen:
Output Type: Adobe PDF
Burst Report: unchecked
Recipients: Report Owner
Message Format: Attachment
Subject: Test
Rest unchecked

Report runs successfully. But email is not generated. I am unable to find any logs with any information.

Report runs successfully.

How are you verifying this? If the report is run by the scheduler there will be an entry in your SystemOut.log file. If there is no entry then I would say the culprit is your scheduler. make sure your schedule is set up correctly (check the Next Run Date is what you would expect).

Are you certain that you are the owner? If so have you run a delivery test on the device that you set up for your user id?

Have you checked the email distribution box on the schedule for bursting and distribution ?

Was this resolved? I'm facing the same issue.

Hi Jeremy, I worked through Support on this issue. There was an issue with emailing in the early versions of RS and FS 10.1.x. I suspect that you'll just need to apply updates to FS and RS. We are on FS & RS 10.1.0.0.76 which was affected. We have not applied the patches to see if it has fixed our issue yet. You may reference our support incident # if you plan to contact Support - # 6177772.