Post reply

Is it possible to open a Crystal reports file from SQL Server??or for that matter any other external application??

  • November 11, 2004 at 2:39 pm

    #87051

    I'm trying to automate Crystal Reports template by running a SQL Server job..it does not work...is it even possible to do.??

  • November 11, 2004 at 5:03 pm

    #529861

    It's possible to use xp_cmdshell to run commands outside of SQL Server - so this may be of help. I'm not quite sure what you mean by automating a template - please clarify.

  • November 12, 2004 at 9:34 am

    #529961

    Phil,

    first of all thanx for the reply..

    I'm trying to imitate a command prompt just as I would do in Visual Basic

    for example:

     VB

    ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

    dim PN as string 'programm name

    dim RunProgram 'return

    PN = "C:\Crystal Reports EXE Location" & "space" & "Cristal Reports File location"

    RunProgram = Shell (PN, vbNormalFocus)

    ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

    SQL SERVER:

    '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

    declare @cmd varchar(255)

    set @cmd = 'C:\Program Files\Seagate Software\Crystal Reports\crw32.exe' 'C:\Reports\CrTest.rpt'

    --

    exec master..xp_cmdshell @cmd

    ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

    Is'n it the same thing??

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply