MicroStrategy ONE

Create Print Device statement

Creates a print device. A Distribution Services print device is used  to automatically print a MicroStrategy report or document on a printer on your network. The device is based on a transmitter in the system.

Copy 
CREATE PRINTDEVICE "device_name" TRANSMITTER "transmitter_name" [DESCRIPTION "description"] [PRINTERPATH "location"] [ALLOWUSERINFO (TRUE | FALSE)] [SCALE scale] 
 [PRINTQUALITY "quality"] [PAPERSOURCE "papersource"] [PAPERSIZE "papersize"] [POSTSCRIPTLEVEL level] [EVENODD (EVEN | ODD | BOTH) ] [REVERSEPAGE (TRUE | 
 FALSE)] [APPLICATIONPRIORITY (OTHER | ISERVER) ] [USEBACKUP (TRUE | FALSE) 
 BACKUPTYPE (PRINTER | FILE ) BACKUPLOCATION "location"] 
 [NUMBEROFRETRIES num] [TIMEBETWEENRETRY time] [DELIVERYTIMEOUT time] [WORKLOCATION "worklocation"];

where:

  • PRINTDEVICE "device_name" is the name of the new print device, of type string.

  • TRANSMITTER "transmitter_name" is the transmitter that the new device is an instance of and is based on, of type string. This should be the name of a print transmitter in the system.

  • DESCRIPTION "description" is the description of the print device, of type string.

  • PRINTERPATH "location" is the location of the printer the report or document is to be delivered, of type string.

  • ALLOWUSERINFO indicates whether to allow users to specify a printer. If this is TRUE, the printer that the user specifies is used as the default location, and any printer location you specify is used as a backup location.

  • SCALE scale is the scale, as a percentage of the original, at which you want to print documents or reports using this device, of type numeric.

  • PRINTQUALITY "quality" is the quality at which you want to print documents or reports using this device, of type string.

  • PAPERSOURCE "papersource" is the source of the paper to use, such as tray 1, of type string.

  • PAPERSIZE "papersize" is the size of the paper to use, such as 8.5 x 11, of type string.

  • POSTSCRIPTLEVEL level is the Postscript level to use for PDF printing, of type numeric.

  • EVENODD is whether to print only even numbered pages, only odd numbered pages, or both in PDF printing.

  • REVERSEPAGE is whether to reverse the page order in PDF printing.

  • APPLICATIONPRIORITY (OTHER | ISERVER) is the application that takes print priority, either ISERVER for Intelligence Server, or OTHER for any other application.

  • USEBACKUP indicates whether you want to save reports or documents to a backup location or print to another printer, if printing on the default printer fails..

  • BACKUPTYPE (PRINTER | FILE) is the type of backup location to use, either a different printer location or a file location.

  • BACKUPLOCATION "location" is the location of the backup printer or folder for storing the file, of type string.

  • NUMBEROFRETRIES num is the number of times to retry printing to the default location before printing to the backup location, of type numeric.

  • TIMEBETWEENRETRY time is how long, in seconds, to wait between retries, of type numeric.

  • DELIVERYTIMEOUT time is how long, in seconds, after which, if the report or document does not print successfully on the default printer, the backup location is used, of type numeric.

  • WORKLOCATION "worklocation" is the path and folder where documents can be saved temporarily during execution, of type string.

Example

Copy 
CREATE PRINTDEVICE "Main Print Device" 
 TRANSMITTER "Print" ALLOWUSERINFO TRUE;