Report Examples

the following use cases are provided as examples to help you create a report template with parameters, upload it to , publish it, and then run it example creating a report where users select incident categories and view owners by category docid\ zaxpw0ukzody1glpluhvcexample creating a report that filters incidents by owner teams and owners within the teams docid\ zaxpw0ukzody1glpluhvcexample using a field in a report that stores both html and text docid\ zaxpw0ukzody1glpluhvcexample restricting report data based on login id docid\ zaxpw0ukzody1glpluhvc example creating a report where users select incident categories and view owners by category this example shows how to create an incident report with category as a parameter step 1 logging into the report builder docid\ zaxpw0ukzody1glpluhvcstep 2 creating the dataset for the report docid\ zaxpw0ukzody1glpluhvcstep 3 creating the dataset for the parameter docid\ zaxpw0ukzody1glpluhvcstep 4 creating the parameters docid\ zaxpw0ukzody1glpluhvcstep 5 designing the report docid\ zaxpw0ukzody1glpluhvcstep 6 uploading and publishing the report docid\ zaxpw0ukzody1glpluhvcstep 7 running the report docid\ zaxpw0ukzody1glpluhvc step 1 logging into the report builder log in to the application as a report manager open the report templates workspace the system displays a list of report templates click new report template the system opens the report builder in the connect to report server login window, enter the following field description username enter userid # tenant id password enter the application password click ok step 2 creating the dataset for the report from the left report data pane, click data sources > saasappmodel create dataset for the report right click saasappmodel , then select add dataset the system displays the dataset properties dialog box click query designer in the enter data source credentials window, enter your microsoft ssrs user name and password, then click ok you only have to enter your microsoft ssrs credentials once during a session the system displays the query designer dialog box click edit as text enter your query for example, a simple query to get all incidents by categories, showing the incident number and owner is as follows select incidentnumber,category,owner from incident where category in (@category) in this example, @category is taken by microsoft ssrs as a parameter when running the query, the system prompts you for the value you can provide any value to test the query the system automatically creates the category parameter and automatically maps it to the dataset click ! the system displays the define query parameters dialog box enter a value in the parameter value field, (for example, enter category ) and click ok view the report columns, then click ok the system displays the dataset properties dialog box click ok to close the window the system creates the dataset, as shown under datasets the system creates the category parameter, as shown under parameters category parameter step 3 creating the dataset for the parameter from the left report data pane, click data sources > saasappmodel right click saasappmodel , then select add dataset the system displays the dataset properties dialog box click query designer the system displays the query designer dialog box click edit as text use the text based query designer to specify a query using the query language supported by the data source, run the query, and view the results at design time enter your query for example, a simple query to get all incident categories is as follows select distinct category from incident where category !='' the query should always have a value after select and not just select because doing so not only causes performance issues, but it might also create an error when upgrading if a field is deleted click ! view the incident categories that are created, as queried in this example, then click ok the system displays the dataset properties dialog box click ok to close the window click ok to close the dataset properties dialog box the system creates the second dataset, for the parameter you have now created two datasets one for the report and one for the parameter two datasets step 4 creating the parameters from the left report data pane, under parameters , select the parameter that you created, then right click and select parameter properties the system displays the report parameter properties dialog box enter a name in the name field or accept the default that you entered in the parameter value field earlier you cannot use any spaces in this field users do not see this name in the prompt field, enter a prompt for the user, (for example, select a category ) or leave the default value users see this prompt select allow multiple values this allows users to select multiple value selections from the category menu allow multiple values from the left pane, click available values select get values from a query select the dataset that you created from the dataset field select the category value from the value field field select the category label from the label field field available values click ok right click the dataset that you created for the report (as described in step 2 creating the dataset for the report docid\ zaxpw0ukzody1glpluhvc ), and select dataset properties click parameters and make sure that it is using the appropriate parameter parameters click ok step 5 designing the report in the report designer, right click and select insert you can insert charts, graphs, tables, and so on when designing your report in this example, the report data is displayed in a table select table drag the values from the dataset that you created and drop them into the header fields creating a report click run to view the report view the incident categories in the menu and the prompt value that you defined viewing a report select the categories to run the report for or click select all , then click view report categories for a report make sure that you are satisfied with the report before uploading it to click save as and save the report to your local machine step 6 uploading and publishing the report log in to the application as a report manager open the report templates workspace the system displays a list of report templates click upload report in the report template name field, enter a descriptive name for the report for example, enter incident categories by owners browse to select the template that you saved, then click save click ok step 7 running the report log in to the application as a report manager open the reports workspace the system displays a list of reports click new report in the report template field, select the report that you created in this example, select incident categories by owners enter a display name and a description select a category to group the report by for example, select incident in the publish report to field, select the roles to publish this report to, such as report manager, service desk analyst, or service desk manager in the parameter information section, select some of the incident categories or select all whichever value you select is the default value when users run the report however, they can select other values from the menu and run the report again to allow users to select the categories, leave the hidden field as no select allow run now running the report click save select the new report to view it ensure that your web browser is enabled to allow pop ups users can select multiple categories or view all categories example creating a report that filters incidents by owner teams and owners within the teams in this example, you create an incident report showing all the incidents filtered by owner teams and then by owner the list of owners that you see after you select the owner team is constrained by the team users can select one or more owner teams, select an owner from the team, and view the incidents where the selected employee is specified as the owner step 1 creating the dataset for the report docid\ zaxpw0ukzody1glpluhvcstep 2 creating the datasets for the parameter docid\ zaxpw0ukzody1glpluhvcstep 3 creating the parameter for the owner teams docid\ zaxpw0ukzody1glpluhvcstep 4 creating the parameter for the owners constrained by owner teams docid\ zaxpw0ukzody1glpluhvcstep 5 designing the report docid\ zaxpw0ukzody1glpluhvcstep 6 uploading and publishing the report docid\ zaxpw0ukzody1glpluhvcstep 7 running the report docid\ zaxpw0ukzody1glpluhvc step 1 creating the dataset for the report log into the report builder see step 1 logging into the report builder docid\ zaxpw0ukzody1glpluhvc from the left report data pane, click data sources > saasappmodel right click saasappmodel , then select add dataset the system displays the dataset properties dialog box click query designer in the enter data source credentials window, enter your microsoft ssrs user name and password, then click ok you only have to enter your microsoft ssrs credentials once during a session the system displays the query designer dialog box click edit as text enter your query for example, a simple query to get all the incidents by owner team, showing the incident number and owner is select incidentnumber,ownerteam,owner from incident where owner= (@owner) in this example, @owner is taken by microsoft ssrs as a parameter when running the query, the system prompts you for the value you can provide any value to test the query the system automatically creates the owner parameter and automatically maps it to the dataset click ! the system displays the define query parameters dialog box enter a value in the parameter value field (for example, enter admin ) and click ok view the report columns, then click ok the system displays the dataset properties dialog box click ok to close the window the system creates the dataset, as shown under datasets the system creates the owner parameter, as shown under parameters owner parameter step 2 creating the datasets for the parameter you need to create two datasets for the parameter the first dataset is for showing the list of owner teams for incidents, and the second dataset is for showing the list of owners constrained by the selected owner team from the left report data pane, click data sources > saasappmodel right click saasappmodel , then select add dataset the system displays the dataset properties dialog box click query designer the system displays the query designer dialog box click edit as text use the text based query designer to specify a query using the query language supported by the data source, run the query, and view the results at design time enter your query for example, a query to get all the incident owner teams is select distinct ownerteam from incident your query should always have a value after select and not just select because doing so not only causes performance issues, but it might also create an error when upgrading if a field is deleted click ! view the incident owner teams that are shown, as queried in this example, then click ok the system displays the dataset properties dialog box click ok click ok to close the dataset properties dialog box the first dataset for the parameter is now created now, create the second dataset for the parameter from the left report data pane, click data sources > saasappmodel right click saasappmodel , then select add dataset the system displays the dataset properties dialog box click query designer the system displays the query designer dialog box click edit as text enter your query for example, a query to get all the incident owners from the selected owner teams is select distinct owner from incident where ownerteam in (@ownerteam) click ! in the define query parameters dialog box, enter a parameter value for example, enter admin , then click ok view the incident owner that is shown, as queried in this example, then click ok the system displays the dataset properties dialog box click ok you have now created three datasets one for the report and two for the parameters, as shown below three datasets step 3 creating the parameter for the owner teams from the left report data pane, under parameters , select the owner team parameter you created, then right click and select parameter properties the system displays the report parameter properties dialog box enter a name in the name field or accept the default that you entered in the parameter value field earlier you cannot use any spaces in this field users do not see this name in the prompt field, enter a prompt for the user, (for example, select an owner team ) or leave the default value users see this prompt select allow multiple values this allows the user to select multiple value selections from the owner team menu from the left pane, click available values select get values from a query select the dataset that you created from the dataset field menu for this example, select dataset2 select the owner team value from the value field field select the owner team label from the label field field click ok step 4 creating the parameter for the owners constrained by owner teams from the left report data pane, under parameters , select the owner parameter that you created, then right click and select parameter properties the system displays the report parameter properties dialog box enter a name in the name field or accept the default that you entered in the parameter value field earlier you cannot use any spaces in this field users do not see this name in the prompt field, enter a prompt for the user, (for example, enter select an owner from the selected owner team ) or leave the default value users see this prompt from the left pane, click available values select get values from a query select the dataset that you created from the dataset field menu for this example, select dataset3 select the owner value from the value field field select the owner label from the label field field click ok right click the dataset that you created for the report (as described in step 2 creating the dataset for the report docid\ zaxpw0ukzody1glpluhvc ), and select dataset properties click parameters and make sure that it is using the appropriate parameter click ok step 5 designing the report in the designer, right click and select insert you can insert charts, graphs, tables, and so on when designing your report in this example, the report data will be displayed in a table select table drag from the dataset that you created and drop the values into the header fields designing the report go to the parameters folder and select ownerteam , then press ctrl + keyboard up arrow to move ownerteam above owner click run to view the report view the incident owner team and owners in the menu and the prompt values that you defined view the report select the owner teams to view or click select all select an owner from the selected owner teams, then click view report make sure that you are satisfied with the report before uploading it to click save as and save the report to your local machine step 6 uploading and publishing the report log in to the application as a report manager open the report templates workspace the system displays a list of report templates click upload report in the report template name field, enter a descriptive name for the report for example, enter incidents by owner by teams browse to select the template that you saved, then click save click ok step 7 running the report log in to the application as a report manager open the reports workspace the system displays a list of reports click new report from the report template field, select the report in this example, select incident by owner by teams enter a display name and a description select a category to group the report by for example, select incident in the publish report to field, select the roles to publish this report to in the parameter information section, select an incident owner team or select all select an owner whichever value you select is the default value when the user runs the report however, they can select other values from the menu and run the report again to allow users to select categories, leave the hidden field as no select allow run now click save select the new report to view it ensure that your web browser is enabled to allow pop ups view the new report users can select multiple teams or view all the teams, and then select an owner from the teams example using a field in a report that stores both html and text this example describes how to create a report template that uses both html and text based fields from the {{business object}} records for example, your email body might use html and text elements, which might not render the line breaks correctly in the generated report for your reports to render correctly, you need to add an expression to the field that uses html and text elements log in to the application as a report manager open the report templates workspace the system displays a list of report templates click the edit icon next to a report template the system opens the report builder from the view menu, ensure that properties is checked the system displays the properties pane on the right select the form field to create the expression for for example, select email message create expression in the properties pane, for the markup type field, select expression the system displays the expression dialog box enter the following expression =if(code checkhtml(fields!emailbody value) = true then "html" else "none") click ok example restricting report data based on login id log in to the application as a report manager open the report templates workspace the system displays a list of report templates click the edit icon next to a report template the system opens the report builder in the report parameter properties dialog box, click general on the left enter information into the fields field description name a descriptive name for the parameter, for example, login id prompt the prompt that users see use a expression for example, enter $(currentloginid()) data type the data type select text select parameter visibility the visibility of the parameter select an option if you select hidden , users cannot change the parameter when running the report click ok