Skip to Content
avatar image
Former Member

Can we trigger a crystal report from command line?

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Oct 16, 2008 at 03:00 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 04:52 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Oct 22, 2008 at 06:22 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • avatar image
    Former Member
    Oct 24, 2008 at 04:49 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2008 at 05:49 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Nov 06, 2009 at 05:11 PM

    Only open the report using windows DDE command.

    Add comment
    10|10000 characters needed characters exceeded