Differences

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

--- reports:how_to [2024/10/08 08:09] – Finish - v.0.1 antonio.andriychuk
+++ reports:how_to [2024/10/08 09:01] (current) – Added Images and minor changes antonio.andriychuk
@@ Line 215: / Line 215: @@
   * __queue_time or pending_time__: self-explainatory, it is the ammount of time where the call is being queued and how much it rang;
   * __talk_time__: ammount of time where the call had a conversation;
+{{:reports:screenshot_2024-10-08-11-00-43_3840x1080.png?400|}}
 After developing the query, we can move to Jasper to continue with building the front-end of the report. \\ \\
@@ Line 240: / Line 243: @@
   * Streamline the query to run a 'lil faster;
   * Creating parameters fields and link them to the query;
+{{:reports:screenshot_2024-10-08-10-58-42_3840x1080.png?400|}}
 \\ \\
 ==== Change the Hyperlink ====
 To change the Hyperlink, you must first select the Brightpattern in the "Main report" tab of the front page and on the property tab go to "Hyperlink", open the "Hyperlink" window and change the "Hyperlink Reference Expression" to the BeCloud url, which is: "https://www.becloudsolutions.com"; \\
 \\ Then, procceed with changing the value of the field from "BrightPattern" to "BeCloud Solutions", mostly, once running the report, you will see only "BeCloud " but if you will expand that frame, you will see "BeCloud Solutions".
+{{:reports:screenshot_2024-10-08-10-48-27_3840x1080.png?400|}}
 \\ \\
 ==== Streamline the query ====
 This step is more easier than expected, this step is also important to make the report able to only take the tenant dataset and not every tenant. In order to apply this explaination in query terms, open the DataSet of the first page and change the FROM call_detail (as an example, change the table to the interested one or where you've been requested to develope a look-alike report) to FROM (tenant dataset).call_detail .
-\\ As an expample, if I have to make a report on the beincontact.it tenant you must insert: "FROM test_com.call_detail"; \\
+\\ As an example, if I have to make a report on the beincontact.it tenant you must insert: "FROM test_com.call_detail"; \\
 Another worth mention is that, in order to create a more streamline and fast query, if it is requested to only extract the query on a single service, add this service on the WHERE condition.
+{{:reports:screenshot_2024-10-08-10-47-29_3840x1080.png?400|}}
 \\ \\
 ==== Parameters and Link ====
 In order to create a better-streamlined-work I suggest to copy the created parameter from the "Developing the report: Jasper" paragraph and paste them in the Parameters tab of the "Main Report" tab, once done that, in the "Outline" tab select "Table" (which is under the "Summary" tab) and on the properties navigate to "DataSet" and click on "Parameters", which is located under the properties page and add the Parameters previously copied.
-\\ As per the provided example, we're going to select "Add" and on the "Parameter Name" we're going to type "Interval" and on the "Parameter Expression" we're going to type: $P{interval}, after click finish and OK to save the change.
+\\ As per the provided example, we're going to select "Add" and on the "Parameter Name" we're going to type "Interval" and on the "Parameter Expression" we're going to type: $P{interval}, after click finish and OK to save the change. \\
+{{:reports:screenshot_2024-10-08-10-45-50_3840x1080.png?400|}}
+Next, another thing worth to do in order to require an input from the User is to navigate on the "DataSet" tab of the report, then navigate to Parameters and tick on "Is For Prompt" of the previously copied Parameter.
+{{:reports:screenshot_2024-10-08-10-44-56_3840x1080.png?400|}}
 \\ \\
 ====== Conclusions ======