Using RapidReports

role administrator minimum version 2017 3 rapidreports allows you to quickly create a report using a single click the feature may need to be configured and implemented in order to be available for your installation once a default or customized report has been created, it will appear under build > automation tools > rapidreports in the report manager page rapidreports is available for both on premises and cloud deployments, with different configuration and installation methods for each for example, on premises reports are installed and configured using the report configuration manager installer rapidreports support only smtp protocol rapidreports is enabled out of the box for most business objects for both form and list (grid) view incident servicereq problem change knowledge release (except for sda view) project ci service task assignment journal email follow the steps in this topic to enable rapidreports for objects other than those listed you can also customize the templates using the procedures in use report manager to customize and edit a default template docid\ zy3nq7zilpcddz2nv6fxr rapidreports contains two functions that can be assigned to users the administrator must explicitly assign access rights to either one or both of these depending on the functionality assigned to a role, a user can create default reports from the available list, or create and customize the reports a report designated as a global report can be viewed and run by all users the functions are report manager usually assigned to administrators or super user roles allows you to create a default report, to clone, edit, and rename default reports, and to designate a report as a global report report viewer can be assigned to any role to allow them to view reports, or to run a default report, a global report, or any report created for a workspace that they can access any role with access rights can create a report from any workspace where rapidreports is implemented available formats once a report is generated, it can be printed to pdf or html using a saved search the data can be sorted and filtered by selecting and running a saved search , and then generating a report to do this run the selected search when the results are displayed, click the rapidreports print icon and use the default template to create a report from the search results the report displays any column contained in the search, as long as the column also appears in the report template the search parameters do not impact the columns contained in the pre configured template to only display certain columns in a report, you can create a report template that is specific to your requirements see use report manager to customize and edit a default template docid\ zy3nq7zilpcddz2nv6fxr for more information configure access to rapidreports use the following steps to assign access for an administrator, then assign access to other roles using the same steps remember, an administrator user will need access to both functions report manager and report viewer , but most other roles may only need access to the report viewer log in to the application using the administrator role from the settings pane go to configure > users and permissions > roles and permissions and select a role (such as administrator) at the role details page click top level tabs in the toolbar at the top level tabs page, click add new tab and select report manager from the list in the new tab details page, edit the name field to report manager then click add this tab for administrator users, also add the report viewer tab using the same steps click save to save your changes add rapidreports to a workspace edit the business object to implement rapidreports for a workspace you can implement rapidreports for change , problem , or incident business objects this example uses the incident business object implement rapidreports by using the following steps log in to the application using the administrator role from settings > build > business objects , click incident from the business object incident# page, click layouts in the toolbar from the layouts page, select incident layout servicedesk in the edit layout incidentlayout servicedesk page, scroll to views in this layout and click gridview as best practice, we recommend that you add the function to both gridview and formview in the list view editor page, in the toolbar option, click the edit link on the right of the toolbar in the toolbar editor , filter on commands to locate rapidreports then click select and drag it to the right pane click save in the toolbar button editor dialog, save on the toolbar editor , and save in the list view editor (or form view editor ) page to save your changes this may take some time as the system needs to add functionality as recommended in in the edit layout incidentlayout servicedesk page, scroll to views in this layout and click gridview docid\ zy3nq7zilpcddz2nv6fxr above, also apply the rapidreports button to the formview create a default template generate a default template if no templates are initially available once a template is available you can edit it and rename it to suit your needs as mentioned previously if you are an existing customer, no templates appear under build > automation tools > rapidreports the following procedure walks you through the basics of creating a template, cloning it, renaming it, and setting a few functions while you are still in administrator role, return to the application page and refresh it to apply the changes you made after following instructions to add rapidreports to a workspace docid\ zy3nq7zilpcddz2nv6fxr click on the incident workspace to open it, and click the rapidreports button you added to the toolbar to see the available options initially only the following 2 options are available default template generates the default template for this list select this option to create the initial template report manager opens the page to edit a template you cannot edit a default template, but you can edit any other templates select the option to see a list of editable templates if no options appear, see using report manager to clone, or customize a template docid\ zy3nq7zilpcddz2nv6fxr for information about how to clone and create a new, editable template click the default template option to generate a template a new tab with incident report default template opens notice that all columns available in the incident list window appear in the report in a new installation, clicking report manager will also generate a default template so that at least one template is always available return to the configuration console to edit the default template to create customized output use report manager to customize and edit a default template before you begin, remember that the report you produce by clicking on the rapidreports icon, may not exactly match the search you run the search is created using the list view from the workspace however, the columns in the report template appear in the order specified within the template this means that the data you request, is presented based on the pre‑configured report template you selected to view the data in a different format, or to show only some of the columns, or to view columns in a different order, you need to customize a template for your requirements once a default template has been created, you can edit it to change items such as margins, to customize the logo, and so on use the following procedure to create customized templates log in to the application using the administrator role from settings > build > automation tools > rapidreports , open the report manager page select the default template (or any other template) in order to customize it the toolbar options are described in the following table icon description click the clone icon to create a clone of a default report click the edit icon to change the name of a template and to designate it as a global template the global check box is selected by default click the design icon to change the design of the template edit the footer information by clicking the footer and then adding system variables to display other information the columns you see in the default report (as listed below) are the only columns that you are able to retain for any new reports you create you cannot add other columns they are incident (displays incident number) , summary, status, priority, customer, location, team, owner, service, category, source, created on, and modified on when editing a report template or creating a customized template you can delete any columns that you do not need however, if you delete a column heading (such as team) then you must also delete the appropriate (associated) table column from the report options in the style designer, such as charts or graphs, cannot be enabled in reports and will not work does not support the use of images that have been uploaded to image control in rapidreport select an item on the report to activate the associated properties that you can edit, in order to change the appearance for example, font, font weight, or alignment click the trash icon to delete the selected template once deleted a template cannot be retrieved click the reload/refresh icon to refresh the list select the design icon to open the properties and to edit the template we recommend not changing the basic format however, you can customize a few basic elements as described in the following table most properties can be viewed from the home tab the bottom bar lists the default measurement unit used by the template select an element in order to see the appropriate properties in the left pane properties in the style designer such as charts or graphs are unavailable and will not work element how to edit logo if this exists, replace with a company logo or add a logo to the template you can change the logo directly in the report designer or in the admin ui branding which will change all logos for any newly created reports (any reports created before the branding changes are made will not be updated ) measurement unit available from home tab change the measurement units so they are appropriate for your installation the setting is located on the bottom bar under properties and is applied to and affects, page size and page layouts the default is millimeters but you may want to change the default to inches page size select the page option from properties and select from the available values for page size (a4, letter etc ) and margins if you cannot see the page option click in the margins of the report example (the white area) that displays in the right pane from here you can select a default orientation (portrait or landscape) and a paper size (a4 or letter) edit margins by using the following structure left;top;right;bottom example 1 25;0 5;0 5;0 75 add a watermark if required you can also leave defaults as is, and only edit the settings for other templates click the save icon on the top left to save your changes using report manager to clone, or customize a template to create a customized template it is recommended that you clone the default template, then customize it as needed you can also customize the default template before you clone it, as described in use report manager to customize and edit a default template docid\ zy3nq7zilpcddz2nv6fxr log in to the application using the administrator role open the configuration console and from settings > build > automation tools > rapidreports , open the report manager page and click on the default template default click the clone option from the report manager to clone the template, then edit it or, from the application, as any user with access to report manager , click on rapidreports > report manager to open a template designer, and create a new global or personal template other report manager options once the feature is configured you will see a full list of forms in the report manager search and filter reports can be searched for or filtered, by report name or report type the options are as follows item description type select a checkbox in the list to filter your choices source name enter a source such as incident or incidentlayout to see the forms associated with that source the source name is usually the name of the item as it appears in either the gridview or formview (i e from where it was generated) report name enter the first few letters of the report name to see the choices owner enter the owner name as it appears in , to see all templates owned by that user show global only check this box to see only templates designated as global reset filters click to reset the search parameters to the default export or import reports export a report to a json file or import a json template into the system by selecting the export or import icons on the top left print a generated report can be saved to pdf email send the report in email by using the email option after a report is generated following is some general information about data that will appear in the reports, and how to gather only the information you need report data is generated from the search you select and run, before you generate a report create a targeted search to define the data you want to view in the report the data can be sorted and filtered by selecting and running a saved search , and then generating a report the report data will appear in the same sort order you see in the list window for example, if you sorted by owner name , then the data will appear sorted by that column all columns that you see in the default list view will appear in the report hiding them won't hide them in the report however, you can create a template that only includes the columns you need for example, incident number, summary, customer name, and owner see using report manager to clone, or customize a template docid\ zy3nq7zilpcddz2nv6fxr for more information you can scale to select one page or the whole report selecting the option to load a report page by page is the quickest way to view it loading the full report (if it consists of multiple pages) may take some time the one page view is the default option