MicroStrategy ONE

Create Print Subscription statement

Creates a print subscription.

Do not include any leading or trailing spaces in the ANSWER parameters. This causes a SQL error and prevents the command from executing.

Copy 
CREATE PRINTSUBSCRIPTION [subscription_name] [FOR OWNERlogin_name] SCHEDULEschedule_name (ADDRESSaddress_name| USERuser_name | CONTACTcontact_name [ADDRESS contact_address_name] | CONTACTGROUPcontact_group_name) CONTENT (report_or_document_nameIN FOLDERlocation_name | GUID report_or_document_guid) [CONTENTTYPE (REPORT | DOCUMENT)] IN PROJECTproject_name [PRINTRANGE [(PAGES FROMstart_page TOend_page 
 | ALL)]] [COPIESnumber_of_copies] [COLLATE (TRUE|FALSE)] [SENDPREVIEWNOW(TRUE|FALSE)] 
 [SENDNOTIFICATION(TRUE|FALSE)] [(SENDNOTIFICATION_ADDRESS "notification_address" | PHYSICALADDRESS "physical_address" 
 DEVICE "notification_device")] [MODIFICATIONBYRECIPIENTS (TRUE|FALSE)] [PROMPT 
 prompt_name1 ANSWER prompt_answer1 [, PROMPT prompt_name2 ANSWER prompt_answer2 [, .. PROMPT prompt_namen ANSWER prompt_answern]]];

where:

  • subscription_name is the name of the subscription

  • login_name is the login name of the subscription owner

  • schedule_name is the name of the schedule

  • address_name is the name of the address

  • user_name is the name of the user

  • contact_name is the name of the contact

  • contact_address_name is the name of the contact address

  • contact_group_name is the name of the contact group

  • report_or_document_name is the name of the  report or document

  • location_name is the name of the folder where the report or document resides

  • report_or_document_guid is the GUID of the report or document

  • project_name is the name of the project where the report or document resides

  • start_page is the first page of the print range

  • end_page is the last page of the print range

  • number_of_copies is the number of copies that will be printed

  • notification_address is the address to which notifications are sent

  • physical_address is the physical address to which notifications are sent

  • notification_device is the device to which notifications are sent

  • prompt_name1..n are the names of prompts in the report or document

  • prompt_answer1..n are the answers to the corresponding prompts