Differences

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

--- 72:custom_reports_getting_started_creating_reports [2019/02/15 18:19] – ext-bkkr
+++ 72:custom_reports_getting_started_creating_reports [2024/02/15 00:00] (current) – external edit 127.0.0.1
@@ Line 6: / Line 6: @@
   - The BIRT RCP Designer is started by executing the birt.exe
-  - Select **File --> New --> New Report **from the drop-down menu
+  - Select **File –> New –> New Report **from the drop-down menu
   - Type the name for the report
   - Select the path where the report file will be stored, and click **Next**
@@ Line 15: / Line 15: @@
 ==== Create a Stages Data Source ====
-  - To create a new Data Source, navigate to the **Outline View** on the lower left side and right-click on the **Data Source** entry and select **New Data Source**.
+  - Navigate to the **Outline View**  on the lower left side and right-click on the **Data Source **entry and select **New Data Source**.
-  - Select **Stages Data Source**. Enter a name for the data source. In the example, the default name is used.
+  - Select **Stages Data Source**. Enter a name for the data source.
   - Click **Next**.
-  - If you do not use the PkitMetrics.xml you need to specify the <font inherit/Courier New,Courier,monospace;;inherit;;inherit>Stages server URL</font> and enter a <font inherit/Courier New,Courier,monospace;;inherit;;inherit>Stages username</font> (for example root) and <font inherit/Courier New,Courier,monospace;;inherit;;inherit>password</font>. Then click **Finish**.
+  - If you do not use the metrics.xml you need to specify the Stages server URL and enter a Stages username and password and click **Finish**.
-      - If you use PkitMetrics.xml, it is necessary to insert a script for your Data Source. You will see the created Data Source in your BIRT Report Designer, click on the Data Source and choose the "script tab" and the condition "beforeOpen".
+      - If you use the metrics.xml, it is necessary to insert a script for your Data Source. You will see the created Data Source in your BIRT Report Designer, click on Data Source and choose the "script tab" and the condition "beforeOpen"
-  - Insert the linked Scripted and save it
+  - Insert the [[:72:custom_reports_getting_started_creating_reports_linked_script|linked script]] and save it.
+==== Create a Data Set ====
+  - Navigate to the **Outline View**  on the lower left side and right-click on **Data Set **and select **New Data Set**.
+  - Select a name for the Data Set, and click **Next**.
+  - Enter the column names and data types
+      - Documentnamewith type string
+      - Statewith type String
+  - Click **Next**.
+  - Click **Edit Script**
+  - Enter the following script into the editor
+<code>
+var artifacts =
+pkit.getCurrentProject().getEntities("containsProcess@SYSTEM")
+[0].getEntities("containsArtifact@SYSTEM");
+for (i = 0; i <artifacts.length; i++) {
+ var artifacts_instances =
+ artifacts[i].getEntities("containsInstance@SYSTEM");
+ for (j = 0; j <artifacts_instances.length; j++) {
+ var artifacts_revisions =
+ artifacts_instances[j].getEntities("containsRevision@SYSTEM");
+ if (artifacts_revisions.length == 0) {
+dataset.setColumnValue("State", "no version");
+ } else {
+ dataset.setColumnValue("State",
+ artifacts_revisions[0].getProperty("state"));
+ }
+ dataset.setColumnValue("DocumentName",
+ artifacts_instances[j].getProperty("LogicalName"));
+ dataset.storeResultRow();
+ }
+}
+</code>
+To finish the editing of the script, click **OK**.
+Enter a //Workspace Path //in the text input field. The //Workspace Path//  is the pipe separated path of workspace names in Stages. A report to be executed in the workspace **Company –> Projects and Products –> System A –> Software Project A**  would need the //Workspace Path//  to be set to **Company|Projects and Products|System A|Software Project A**.
+  - //Note: The Workspace Path value is needed for the preview, if the script contains the statement //pkit.getCurrentProject()…
+  - Click **Finish**  to continue the data set configuration and click **Preview Results**  to show a preview of the results.