Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (Charts) • Data Views • Introduction (Migration Assistant) • Introduction (Crystal Reports)
bw:crystal_reports_tool

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
bw:crystal_reports_tool [2020/05/21 11:30]
akoehler [Print Option] 		bw:crystal_reports_tool [2022/08/02 16:50] (current)
akoehler
Line 5: Line 5:
 =====Related Documents===== =====Related Documents=====
  
-The following pagescontain additional information that may be helpful with the development of Bizweaver workflows using the Crystal Reports tool.+The following pages contain additional information that may be helpful with the development of Bizweaver workflows using the Crystal Reports tool.
  
-  * [[bw:using_variables|Using Variables]] +  * **[[bw:using_variables|Using Variables]]** 
-  * [[bw:file_operations_tool|File Operations]]+  * **[[bw:file_operations_tool|File Operations]]**
  
 =====Before You Begin===== =====Before You Begin=====
  
 You must have a Crystal Reports source file (.RPT) to use this tool. You must have a Crystal Reports source file (.RPT) to use this tool.
 +
 +<WRAP center round important 80%>
 +To ensure proper functionality of Crystal Reports with Bizweaver, TLS 1.0 and 1.1 need to be enabled on the Bizweaver server.
 +</WRAP>
  
 <WRAP center round tip 80%> <WRAP center round tip 80%>
Line 28: Line 32:
 =====General Configuration===== =====General Configuration=====
  
-The following example illustrates a simple workflow to generate a Crystal Report which is saved to disk and printed. Typical production examples will be more complicated. An example of a report that uses parameters is found later in this document.+<WRAP center round tip 80%> 
 +The Crystal Reports tool has a dependency on the Crystal Runtime Engine. These files can be found on the **[[https://portal.twbs.com/M.htm#/|Third Wave Portal]]**. Navigate to Products, then Software Downloads; the file is named "CRRuntime_Files.zip." 
 +</WRAP>
  
-{{::bw:crimage1.png}}+The following example illustrates a simple workflow to generate a Crystal Report, saved to disk and printed. Typical production examples will be more complicated. An example of a report that uses parameters is found later in this document. 
 + 
 +{{  ::bw:crimage1.png  }}
  
   * Enter a unique **Name**.   * Enter a unique **Name**.
Line 37: Line 45:
   * **Report Source Path** identifies the Crystal Report source file to be executed.   * **Report Source Path** identifies the Crystal Report source file to be executed.
   * **Output Options** and **Parameters** are described below.   * **Output Options** and **Parameters** are described below.
-  * **Logon Information** defines the target server and database where your data is found, as well as the logon credentials.+  * **Login Information** defines the target server and database where your data is found, as well as the logon credentials.
     * Select the target **DB Type** from the drop-down; either __SQL__ or __HANA__.     * Select the target **DB Type** from the drop-down; either __SQL__ or __HANA__.
  
Line 45: Line 53:
 Output options are selected via the appropriate checkbox. Output options are selected via the appropriate checkbox.
  
-{{:bw:crimage2.png}}+{{  :bw:crimage2.png  }}
  
 At least one option must be selected but both can be selected as well. At least one option must be selected but both can be selected as well.
Line 65: Line 73:
 Many Crystal Reports will use parameters to define the information to be reported. When a parameter is detected in the report it is listed in the **Parameters** section of the tool. Many Crystal Reports will use parameters to define the information to be reported. When a parameter is detected in the report it is listed in the **Parameters** section of the tool.
  
-{{:bw:crimage4.png}}+{{  :bw:crimage4.png  }}
  
 The value assigned to each parameter could be a static value, a Bizweaver Step Variable, a value from a Bizweaver User variable, or, as in this case, a value from a previous SQL step. Press F4 while in the “Parameter Value” field to display the list of available variables. The value assigned to each parameter could be a static value, a Bizweaver Step Variable, a value from a Bizweaver User variable, or, as in this case, a value from a previous SQL step. Press F4 while in the “Parameter Value” field to display the list of available variables.
Line 71: Line 79:
 In this example the parameter in the Crystal Report is “CardType.” In the image above a variable in the workflow is used to provide the value for the parameter. The following image shows the same parameter provided as a static value. In this example the parameter in the Crystal Report is “CardType.” In the image above a variable in the workflow is used to provide the value for the parameter. The following image shows the same parameter provided as a static value.
  
-{{:bw:crimage5.png}}+{{  :bw:crimage5.png  }}
  
 =====Managing Output Files===== =====Managing Output Files=====
Line 79: Line 87:
 Moving or deleting the file is done with the File Operations tool. Information about using this tool is found **//[[bw:file_operations_tool|here]]//**. Moving or deleting the file is done with the File Operations tool. Information about using this tool is found **//[[bw:file_operations_tool|here]]//**.
  
 +====Crystal Reports Variables====
 +
 +^Name ^Description^
 +|ActionPrint|This indicates if the print checkbox is selected|
 +|ActionSave|This indicates if the save to disk checkbox is selected|
 +|Database|This indicates the database selected for the Crystal Report|
 +|DBType|This indicates the database type ex. SQL, HANA|
 +|Format|This indicates the format of the output file radio button that is selected ex. PDF,Word,Excel|
 +|NoOfCopies|This indicates the number of copies to be printed|
 +|ParamColl|This indicates the parameter entered if any|
 +|Password|This indicates the password used for the Crystal Report|
 +|Printer|This indicates the printer that is used|
 +|ReportOutputPath|This indicates the save location of the report with extension|
 +|ReportSourcePath|This indicates the source location of the Crystal Report|
 +|Server|This indicates the server the Crystal Report is connecting to|
 +|User|This indicates the user for the database that Crystal Reports is connecting to|
 +|StepMessage|During a failure the reason for failure will be populated here|
 +|StepStatus|True or False|
bw/crystal_reports_tool.1590075024.txt.gz · Last modified: 2020/05/21 11:30 by akoehler

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki