Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Calling Bizweaver from SQL • Building a Workflow • about • Introduction (Email) • File Operations Tool • Introduction (GraphqL) • contact • downloads
bw2:crystal_reports_tool

Differences

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

Link to this comparison view

Next revision 		Previous revision
bw2:crystal_reports_tool [2020/12/15 13:52]
akoehler created 		bw2:crystal_reports_tool [2023/02/01 08:54] (current)
mfoster [General Configuration]
Line 5: Line 5:
 =====Related Documents===== =====Related Documents=====
  
-The following pages contain 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 help develop Bizweaver workflows using the Crystal Reports tool.
  
   * **[[bw2:using_variables|Using Variables]]**   * **[[bw2:using_variables|Using Variables]]**
Line 15: Line 15:
  
 <WRAP center round important 80%> <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.+To ensure Crystal Reports' proper functionality with Bizweaver, TLS 1.0 and 1.1 need to be enabled on the Bizweaver server.
 </WRAP> </WRAP>
  
 <WRAP center round tip 80%> <WRAP center round tip 80%>
-General information about configuring Crystal Reports for use with Versago and Bizweaver is found **//[[versago:Configuring Crystal Reports|here]]//**.+General information about configuring SQL/HANA Crystal Reports for use with Versago and Bizweaver is found **//[[versago:Configuring Crystal Reports|here]]//**.
 </WRAP> </WRAP>
  
-The source (.RPT) files need to reside on the same server as Bizweaver. We have found that the Crystal Reports runtime engine, which actually generates the reports, does not function well when the report is on another server and is accessed via a network share. 
  
 +
 +The source (.RPT) files need to reside on the same server as Bizweaver. We have found that the Crystal Reports runtime engine, which actually generates the reports, does not function well when the report is on another server and is accessed via a network share.
 =====Crystal Reports Tool===== =====Crystal Reports Tool=====
  
-The Crystal Reports tool is used to execute a previously developed Crystal Report within a workflow. The resulting output can then be saved to disk, printed, or used for other purposes such as an attachment for email distribution.+The Crystal Reports tool is used to execute a previously developed Crystal Report within a workflow. The resulting output can then be saved to disk, printed, or used for other purposes such as an email distribution attachment.
  
-The configuration of the Crystal Reports tool is illustrated by the examples that follow+The configuration of the Crystal Reports tool is illustrated by the examples that follow.
  
 =====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.+The following example illustrates a simple workflow to generate a Crystal Report, saved to disk and printed. Typical production examples will likely be more involved. An example of a report that uses parameters is found later in this document.
  
-{{  ::bw:crimage1.png  }}+{{ :bw2:bizweavercrtool1.png |}}
  
   * Enter a unique **Name**.   * Enter a unique **Name**.
Line 41: Line 42:
   * **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 49: Line 50:
 Output options are selected via the appropriate checkbox. Output options are selected via the appropriate checkbox.
  
-{{  :bw:crimage2.png  }}+{{ :bw2:bizweavercrtool2.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.
  
 ====Print Option ==== ====Print Option ====
  
 The **Print** option generates the report and sends it to the printer selected from the drop-down list. The number of copies can also be selected. The **Print** option generates the report and sends it to the printer selected from the drop-down list. The number of copies can also be selected.
-{{  :bw:crimage3.png?388x40  }}+ 
 +{{ :bw2:bizweavercrtool3.png |}}
  
 ====Save to Disk Option==== ====Save to Disk Option====
Line 67: Line 69:
 =====Parameters===== =====Parameters=====
  
-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. 
- +{{ :bw2:bizweavercrtool4.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.
  
-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 “Start Year.” In the image above, a variable in the workflow is used to provide the parameter's value. The following image shows the same parameter provided as a static value.
  
-{{  :bw:crimage5.png  }}+{{ :bw2:bizweavercrtool5.png |}}
  
 =====Managing Output Files===== =====Managing Output Files=====
  
-When you create PDF files as output you will usually need to do something with the file. The three main options are to leave the file in place, move the file to a different folder, or delete the file.+When you create PDF files as output, you will usually need to do something with the file. The three main options are to leave the file in place, move the file to a different folder, or delete the file.
  
 Moving or deleting the file is done with the File Operations tool. Information about using this tool is found **//[[bw2:file_operations_tool|here]]//**. Moving or deleting the file is done with the File Operations tool. Information about using this tool is found **//[[bw2: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|
bw2/crystal_reports_tool.1608058353.txt.gz · Last modified: 2020/12/15 13:52 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