Business objects / Crystal reports server schedule to disk

Question

1.00/5 (1 vote)

See more:

Hi all,

I'm trying to schedule a report from an ASP application to file in order to simultaniously print the report to printer. The code below results to the very same scheduled report as when I do this in the CMC. Only in the CMC application this works and when I try the code the report stays "Active" and does not write a file or print a copy to the printer. What could be the problem here?

This is my code:

string query = "Select SI_DEST_SCHEDULEOPTIONS, SI_PROGID From CI_SYSTEMOBJECTS "
    + "Where SI_PARENTID = 29 AND SI_NAME = 'CrystalEnterprise.DiskUnmanaged'";
InfoObjects fileInfoObjects = infoStore.Query(query);
InfoObject infoObject = fileInfoObjects[1];

DestinationPlugin destinationPlugin = (DestinationPlugin)infoObject;
DiskUnmanaged diskUnmanaged = (DiskUnmanaged)destinationPlugin;

DestinationOptions destinationOptions = diskUnmanaged.ScheduleOptions;
DiskUnmanagedOptions diskUnmanagedOptions = new DiskUnmanagedOptions(destinationOptions);

diskUnmanagedOptions.DestinationFiles.Add(@"c:/PrintedReports/test.rpt");

schedulingInfo.Destination.SetFromPlugin(diskUnmanaged);

query = "Select SI_ID, SI_NAME FROM CI_INFOOBJECTS " + "Where SI_ID=" + report.ID.ToString();
InfoObjects infoObjects = infoStore.Query(query);

infoObject = report;

ReportPrinterOptions reportPrinterOptions = report.ReportPrinterOptions;
reportPrinterOptions.Enabled = true;
reportPrinterOptions.AlwaysPrintToPDF = true;
reportPrinterOptions.Copies = 1;

reportPrinterOptions.PrinterName = printerDataTransfer.PrinterName;

infoObjects = report.ParentInfoObjects;
infoStore.Schedule(infoObjects);

Posted 20-Jun-11 23:08pm

Mart Rijkers

Add a Solution

Comments

thatraja 22-Jun-11 22:24pm

Any error message? Need more details....

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 · 2013-10-17T03:19:00

Solved it like this:

C#

string query = "Select SI_DEST_SCHEDULEOPTIONS, SI_PROGID From CI_SYSTEMOBJECTS "
    + "Where SI_PARENTID = 29 AND SI_NAME = 'CrystalEnterprise.DiskUnmanaged'";
InfoObjects destinationInfoObjects = infoStore.Query(query);
InfoObject infoObject = destinationInfoObjects[1];


DestinationPlugin destinationPlugin = (DestinationPlugin)infoObject;
DiskUnmanaged diskUnmanaged = (DiskUnmanaged)destinationPlugin;

DestinationOptions destinationOptions = diskUnmanaged.ScheduleOptions;
DiskUnmanagedOptions diskUnmanagedOptions = new DiskUnmanagedOptions(destinationOptions);

diskUnmanagedOptions.DestinationFiles.Add(filename);

diskUnmanagedOptions.UserName = SMC_Reportserver_Classes.Properties.Settings.Default.printFileUser;
diskUnmanagedOptions.Password = SMC_Reportserver_Classes.Properties.Settings.Default.printFilePassword;

schedulingInfo.Destination.SetFromPlugin(diskUnmanaged);
InfoObjects infoObjects = report.ParentInfoObjects;
infoStore.Schedule(infoObjects);