Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace:
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/06 09:46]
runger 		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=====
Line 14: Line 14:
 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.
  
-When designing a Crystal Report that will use a __SQL Server__ database as its data source, the report connection type must be **OLE DB (ADO)**.+<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>
  
-When designing a Crystal Report that will us a __HANA__ database as its data source, the report connection type be **ODBC (RDO)**.  {{ :versago:b1h_90_ht_setupdsforcrl.pdf |This document }} (PDF) explains how to configure this type of connection for use with HANA.  Two options are described in the document.  Be sure to use the B1CRHPROXY32 option.  Here is a sample connection string to use as a starting point. +<WRAP center round tip 80%> 
- +General information about configuring Crystal Reports for use with Versago and Bizweaver is found **//[[versago:Configuring Crystal Reports|here]]//**. 
-<code> +</WRAP>
-DRIVER={B1CRHPROXY32};SERVERNODE=<YourServer>:30015;DATABASE=<YourDB> +
-</code> +
- +
-Replace <YourServer> and <YourDB> (without the < > symbols) with the appropriate values.+
  
 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.
Line 34: 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 43: 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 51: 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 58: Line 60:
  
 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}}+{{  :bw:crimage3.png?388x40  }}
  
 ====Save to Disk Option==== ====Save to Disk Option====
Line 71: 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 77: 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 85: 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.1588772779.txt.gz · Last modified: 2020/05/06 09:46 by runger

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