| Navigation: »No topics above this level«====== SetCrystalQueryPreview ============ SetCrystalQueryPrint ====== |    |
The SetCrystalQueryPreview and SetCrystalQueryPrint templates both accomplish the exact same task. They set the SQL Query that wiil be sent to the SQL data source. The difference between these two templates is that SetCrystalQueryPreview is used in conjunction with the PreviewCrystalReport template and SetCrystalQueryPrint is used in conjunction with the PrintCrystalReport template.
These templates call the Crystal8.Query method. For more information on these methods refer to the ABC Library Reference, Crystal8 class.
Requirements
These templates require the PreviewCrystalReport or the PrintCrystalReport template respectively.
Populating the Template
1. From an embed point, press the Insert button and select either the SetCrystalQueryPreview or SetCrystalQueryPrint template.
Template Prompts
These templates provides the following prompts:
Query Variable
Specify a valid variable that holds the SQL Query to send to the SQL data source. This may be a STRING, CSTRING, PSTRING, or MEMO data type. The variable may be a local, module, or global variable. You may also use a file field. This variable is required.