Post reply

ghostscript to auto print a generated Reportservices Report

  • May 14, 2015 at 12:39 pm

    #308127

    I downloaded ghostscript and ghostview

    I was trying to use XP_CmdShell, to print a report once it was generated in reporting services. we only have SQL Server 2012 standard.

    I cannot get the XP_CmdShell to work.

    USE MSDB

    EXEC XP_CmdShell 'C:\Program Files\Ghostgum\gsview\gsprint.exe -color -landscape -all -printer "Brother MFC-5460CN" "E:\BatchSheets\Batch_9403.pdf"'

    has anyone else used ghostscript to print files automatically?

    Thanks

    George

  • May 14, 2015 at 12:47 pm

    #1797984

    Please don't cross-post.

    Original Post here: http://www.sqlservercentral.com/Forums/Topic1685618-3077-1.aspx

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

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

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