Can we trigger a crystal report from command line?

[Former Member]

Hi,

I am using Crystal reports X1 developer and Crystal Report Server XI R2.

Supposing, tthere is a report created and stored in the server.

Can we trigger/Run this report through Command Line?

Thanks,

sriram

[former_member11696]

Only open the report using windows DDE command.

[Former Member]

Hey Sriram,

If you are interested in the URL reporting, then you can follow this link to access the report as this is a default one.

You must enter the values in the link to call the report.

="<a href=\"http://%3cserver name>:<port number>/<WebIntelligence virtual directory>/scripts/

openDocument.<deployment mode tag>? &iDocID=<document ID number>&sDocName=<document name>&sType=<document file type>&sRepoType=<repository type>&lsS<message displayed by the prompt>="[<object for which the value is to be used as the prompt value>]"\">"[<object for which a value is displayed in the cell>]"</a>"

Here you must enter the file name, server name and parameter values and the report id.

This is not the documentation for the URL reporting.

Regards,

Naveen.

[Former Member]

Hi,

Sorry for the late response.

The idea behind asking, triggering a report from command line is to re-run the failed report using a trigger on the database column upon updating the failed status flag and re-run flag on the database table columns.

So, when a report is triggered from command prompt, it is asking for the Crystal report User name and password. Please advise the syntax to pass the crystal report username and password through command prompt while a report is triggered.

[Former Member]

Hi Sriram,

We have to pass login credentials for the report through command as it is designed by default.

As it is suggested to run the report through URL Reporting where it will prompt for Enterprise login credentials .

What ever the process we have to enter it by default .

As it is designed in crystal by default.

Regards,

Naveen.

[Former Member]

Hi Sriram,

The prompt for the user credentials might be for the database credentials or if the report is tried to run from different location.

If the report is saved in Enterprise then it prompts for user credentials, but we should pass the credentials at the level report and cannot pass through command line.

Regards,

Naveen.

[Former Member]

Hi Naveen,

prompt for the password is not for the database rather it was crystal user (named user and password) prompt. We do not have any issues to peovide the crystal user name and password. But what we want to know is, how to trigger report without prompting for password?

Please suggest

Thanks,

Sriram

[Former Member]

Hi Sriram,

Is there a specific requirement that you want to run the reports only using the command line?

Since the reports are saved to the Server (Assuming it is the Business Objects Enterprise Server), then a better option would be to use URL reporting, in which you can create a URL and pass it along to users and they will be able to view the report in Internet explorer.

URL reporting also gives you the flexibility to pass the parameters, login info and the type of viewer you want to use.

If you would like to exlpore this option, then do let us know so that we can try and arrange for the technical paper which will guide you through the entire process.

Regards,

Abhishek Jain.

[Former Member]

Hi Sriram,

Type the path of the report in the run command.

Give the drive name, folder name and name of the report in the extension.

Type the path of report for e.g. as:

D:\Crystal reports\Annual sales report.rpt.

if you are accessing the report through remote desktop then type the machine name or machine numb in network.

This would help you out.

Thanks,

Naveen.

[Former Member]

funny echo!

[Former Member]

Hi,

Thanks for your valuable inputs.

I tried as per your suggestion. But when the report opens, it is asking the username and password.

Is there any option to pass the username and password from the command line, so that the report runs without any prompt for password?

Thanks,

Sriram

[Former Member]

cmd? ms-dos?

if so, you can type the file path & name in ms-dos, such as c:\report.rpt and it'll launch Crystal and open the report

regards,

dom