WebFOCUS Online Help > Managed Reporting End User > Using Dashboard > Creating Reports in Dashboard
You can create My Reports using Reporting Objects. You can also copy a Shared Report and save and modify it as your own My Report.
In addition, you can create new reports from scratch in the Custom Reports folder. Custom Reports enable you to create your own reports using one of the reporting tools or the text editor. Reporting tools include InfoAssist, Report Assistant, Graph Assistant, and Power Painter (if the user is assigned the Advanced privilege). Depending on which tool you use to create your report, you can edit your report using the same tool or the text editor. You can change the name of your Custom Report from the Properties window, and you can create new folders in the Custom Reports folder.
From Custom Reports, you can also upload (import) an external data file for use in one of the available reporting tools. For details, see Uploading Data Files.
You can insert a procedure within another procedure when creating a custom report. For details, see Execution of a Custom Report Using -INCLUDE.
Note:
The report is saved with the name you provide in a subfolder within the My Reports folder. The subfolder is named for the group folder where the selected Reporting Object is located.
For details on using:
To delete a report or folder in My Reports, right-click the report or folder and select Delete from the menu.
Note:
Copying a Shared Report and saving it as a My Report enables you to edit the report or graph without affecting the original. For details, see How to Copy a Shared Report.
If you have selected InfoAssist, Power Painter, Report Assistant, or Graph Assistant, you will be prompted to select a data source from which you want to report, then click OK to continue.
The selected tool opens.
For details on using:
If you copied a report to the same Custom Reports folder, the copied report has (Copy 1) appended to the original report name. If you make multiple copies of the report, each additional copy increments the numeric value listed after Copy.
If you copied or moved a report to a different Custom Reports folder, the copied report uses the original report name. If the same report name already exists, a confirmation dialog box appears where you can select to overwrite the existing report or not.
To delete a folder in Custom Reports, right-click the folder and select Delete.
Edit only one report at a time when using InfoAssist, Power Painter, Report Assistant, or Graph Assistant.
For details on using:
Note: After editing with the Dashboard text editor, you will not be able to use reporting or graphing tools to open reports created using InfoAssist, Power Painter, Report Assistant, or Graph Assistant because the tools cannot read some user-added syntax.
You can use the text editor to create, view, edit, and run the source code for Custom Reports in Dashboard. The text editor enables you to use familiar editing techniques, such as cut, copy, and paste. You can also find and replace text and specify case.
Note: After editing with the Dashboard text editor, you will not be able to use reporting or graphing tools to open reports created with InfoAssist, Power Painter, Report Assistant, or Graph Assistant because the tools cannot read some user-added syntax.
The following image shows the text editor with a sample file in the editing window.
The following table describes all of the functions available in the Dashboard text editor. The first column lists the buttons, and the second column lists the actions they produce.
Button |
Action... |
---|---|
|
Saves the report. Acts as "Save As" the first time you save the report. |
|
Saves the report in the Custom Reports folder with a name you specify. |
|
Runs the current report. |
|
Exits the Editor window. If you made changes to the original report, a window prompts you to save or cancel the changes. |
|
Opens the online help. |
|
Cuts, copys, or pastes the highlighted text. |
|
Deletes, selects all, undoes, and redoes. |
|
Finds and replaces text. |
|
Enables you to go to a particular line number in the report. |
|
Converts highlighted text to uppercase. |
|
Converts highlighted text to lowercase. |
|
Sets the text color in the editor. |
|
Sets the background color of the editor. Note: The text color and background colors are for the current session only. |
|
Enables you to change the font of the editor. |
|
Enables you to change the font size of the text in the editor. |
Note:
When you create reports and graphs, you may want to share them with others in your organization. The Shared Reports feature addresses this need by enabling you to create reports and graphs and make them available to other users who access the same domain.
By designating a report as shared, you allow other users to run it from the Shared Reports folder in the Domain Tree. Other users cannot edit a Shared Report in the Shared Reports folder, but they can copy a Shared Report to their own My Reports folder and then edit the copied report without affecting the original. All users who access the Domain Tree have the ability to view, run, and copy Shared Reports. Note that users with the User role cannot copy Shared Reports.
Only users who have been granted the Shared privilege by their
Administrator can share a My Report. The My Reports that you contribute
appear in the Shared Reports folder of other users and display the
Shared Report icon. These reports also appear
in your My Reports folder displaying the same Shared Report icon
to denote that they have been made available to others. Note that
Custom Reports can be shared in the same manner as My Reports.
The Shared Reports folder in the Domain Tree consists of folders named for other users who contributed Shared Reports. All the reports contributed by a particular user appear under the Shared Reports folder in a subfolder named for the Reporting Objects group folder, Custom Reports folder, or Custom Reports subfolder where the report was created. Shared Reports are available to all other Managed Reporting users who can access the same domain. Note that reports that you share are not listed in your own Shared Reports folder.
The following image shows three Shared Reports contributed by a user named Jeff who created and shared the reports from three different locations: the Custom Reports folder, a Custom Reports subfolder, and a Reporting Objects group folder named Test IA.
The Shared Reports folder enables you to:
To make an existing My Report available to other users:
The Properties dialog box opens.
The Properties dialog box closes and the report becomes available to all users who access the domain.
To make a new report or graph that you are creating available to every user who accesses the domain:
You can create and save a report or graph from either the Custom Reports folder, a Custom Reports subfolder, or a Reporting Objects group folder.
The Properties dialog box opens.
Tip: Alternatively, if you are using Report Assistant or Graph Assistant, when you are finished creating the desired report or graph, you can click Save As in the File menu, select the Share Report check box in the dialog box that appears, type a descriptive name, and click OK.
To copy a Shared Report to your My Reports folder:
The Shared Report folder displays folders with the names of users who have contributed reports.
The expanded user folder displays subfolders that were used to create the Shared Reports.
The Save As My Report dialog box opens.
You can keep the original name or change the name of the report by deleting the original and typing a new name in the Description field.
WebFOCUS copies the report to your My Reports folder.
After you copy a Shared Report to your My Reports folder, you can edit the report without affecting the original.
WebFOCUS opens the reporting tool used to create the Shared Report and displays the report or graph you copied from the Shared Reports folder.
For details on using:
In Dashboard, you can upload (import) external data files for use in WebFOCUS reporting tools. This functionality enables you to easily create a WebFOCUS file description and data file for use in your reporting application. The Upload Data File option is enabled by default and is available to all users with access to the Custom Reports folder of the Domain Tree.
The first page of the Upload Data File dialog opens displaying three sections that require you to make a selection:
A Choose file dialog opens.
The following image shows the first page of the Upload Data File dialog.
The second page of the Upload Data File dialog, as shown in the following image, appears for you to review and customize the file conversion options.
If you change any of the attributes for a field, click the Apply button to apply the changes and refresh the data.
Two files are created:
Note: If a file with the same file name already exists, a dialog is displayed prompting you to allow file replacement.
The amper auto-prompting facility enables you to select parameters and run the report while still being able to view and change your parameter selections. You can also display and hide parameters to widen the screen as needed. For example, the following image shows a report that requires parameter selection.
After you run the report, the output appears as shown in the following image:
From the amper auto-prompting launch page, you have the following options:
Button |
Description |
---|---|
Run |
Click this button to run the report. |
Reset |
Click this button to reset the parameter selections. |
Save |
Some reports provide the save parameters option. |
Clear Output |
Click this button to clear the report output area. |
Run in a new window |
Select this check box to open the report in a new browser window. |
Show/Hide Parameters |
Double-click splitter bar to hide parameters for full screen report view. Double-click splitter bar again to return to the original parameters and report view. |
You can customize the look and feel of the amper auto-prompting facility by editing the launch page template file you are using. All of the available launch page templates are located in the ibi\WebFOCUS76\ibi_html\javaassist\ibi\html\describe directory. The default template is autoprompt_top.css.
If you want to customize the banner, create an image, save it in the describe directory, and change the background-image property, which is shown in bold type in the following Cascading Style Sheet (CSS) code:
#idBannerDiv { height:45px; background-image: url(logo_banner.gif); background-position: top left; background-repeat: no-repeat; margin: 0; margin-top:2px; cursor:hand;}
The option to select different launch page templates can be set in the WebFOCUS Administration Console using the Parameter Prompting selection under Client Settings, where you can set the IBIF_describe_xsl value to one of the launch page templates.
You can also enter the name of the desired launch page template in a FOCEXEC using the following code:
<describe_xsl>template</describe_xsl>
where:
Is set to one of the following launch page template values:
You can save parameter selection values as a My Report for reports that run immediately or run deferred. By default these reports are saved in the Saved Parameter Reports folder which is automatically created under the My Reports folder, but you can save parameter reports anywhere in the My Reports folder structure.
When you select Run from the menu options for Saved Parameter Reports, the saved values are used to run the report and the prompt form does not display. When you select Edit Parameters, the prompt form appears so you can make changes to the values before running the request. You can Run Deferred, which also shows the prompt form before running the request. Additional menu items for Saved Parameter Reports that are available from Dashboard are Delete, Add to Favorites, Add to Mobile Favorites, and Properties. You can also schedule the report for later execution if you have scheduling capabilities.
Note:
Note: The appearance of this button may be different depending on your application.
The Save Parameters dialog box opens.
Note: You may need to click the refresh button (circle with arrow) in the toolbar to refresh the domain and view the new report.
WebFOCUS |