Retrieve email addresses and parameters of scheduled and/or completed crystal reports sent as pdf

Question

4.00/5 (1 vote)

See more:

, +

I'm planning Crystal reports from my application to Crystal Reports Server in the email queue. I want to sent the reports as pdf. Sending emails works fine. In the CMS (Crystal Reports Server) I can see the history and scheduled reports with their parameters.

I would like to retrieve the parameters and used email addresses in my application for completed reports (history) and scheduled reports.

If I retrieve the history, the infoObjects that are scheduled as "Report", but when I retrieve them from the history it appears they are not object type Report but type Pdf:

string query = "Select SI_ID, SI_NAME, SI_OWNER, SI_DESCRIPTION,  SI_STATUS, SI_STATUSINFO " +
                ",SI_RECURRING, SI_SCHEDULEINFO.SI_OUTCOME " +
                "FROM CI_INFOOBJECTS " +
                "WHERE SI_KIND='CrystalReport' AND SI_RECURRING=0";


dt.Columns.Add("Naam");
dt.Columns.Add("Weetniet");
dt.Columns.Add("Eigenaar");
dt.Columns.Add("Status");
dt.Columns.Add("");
dt.Columns.Add("");




InfoObjects infoObjects = infoStore.Query(query);
foreach (InfoObject infoObject in infoObjects)
{
    try
    {
        Report report = (Report)infoObject;
        dt.Rows.Add(
          infoObject.Title,
          infoObject.Properties["SI_NAME"],
          infoObject.Properties["SI_OWNER"],
          infoObject.SchedulingInfo.Status,
          (CeScheduleType)infoObject.SchedulingInfo.Type,

          infoObject.Properties["SI_STATUSINFO"]
          );
    }
    catch (Exception e)
    {
        Alert.Show("Fout in opvragen geschiedenis\n" + e);
    }
}

throws the exception:
Unable to cast object of type 'CrystalDecisions.Enterprise.Desktop.Pdf' to type 'CrystalDecisions.Enterprise.Desktop.Report'.

For the Pdf Object I cannot find the properties to find the email addresses and parameters. Since I can see these in the CMS, they must be there somewhere...

Does anyone know how to do this?

Posted 19-May-11 21:55pm

Mart Rijkers

Updated 19-May-11 21:57pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mart Rijkers · Accepted Answer · 2011-05-20T02:00:00

Found it myself. You need to get the properties of the parent report, which is the original crystal report.
So first select the parent SI_ID:

C#

getParameters(infoObject.ParentID.ToString());

Here is the procedure to get the params:

C#

private string getParameters(string objectID)
{
    string query = "Select * FROM CI_INFOOBJECTS WHERE SI_ID = " + objectID;
    string result = "";
    InfoObjects infoObjects = infoStore.Query(query);

    Report report = (Report)infoObjects[1];
    ReportParameters reportParameters = report.ReportParameters;
    for (int i = 1; i <= reportParameters.Count; i++)
    {
        ReportParameter reportParameter = reportParameters[i];
        result += reportParameter.ValueDisplayString;
    }

    return result;
}