Post reply

Ghostscript to auto print reporting services report

  • May 14, 2015 at 12:42 pm

    #308128

    I downloaded ghostscript and ghostview.

    I am trying to print a reporting services report after it generates.

    I am using the below SQL

    USE MSDB

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

    its not working

    anyone else able to use ghost script.

    thanks

    George

  • May 14, 2015 at 12:45 pm

    #1797983

    I'm curious - how is that script supposed to know what Report it's supposed to print?

    "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

  • March 2, 2016 at 11:23 pm

    #1862634

    Any luck with this attempt ? I am trying to do this too.

    Managed to get gsprint to discover the printer but got another error related to Windows GDI Driver.

  • March 3, 2016 at 10:31 am

    #1862842

    Initially, I did get this work, and work working fine until we decided to just render the reports to pdf, and email the reports to who ever needed them.

    George

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

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