Managing User Reports and Report Parameter Files

<< Click to Display Table of Contents >>

Navigation:  Professional > Reports > Running Reports >

Managing User Reports and Report Parameter Files

User Reports

Publish Column Chooser Configuration with User Report

Report Parameter Files

Troubleshooting

 

There are two options for saving report parameters in EQuIS Professional:

1.User Reports - saved to the database. These may be opened when accessing the database from any location (given proper user permissions), including EQuIS Enterprise. The User Reports toolbar provides easy access to existing User Reports, and options to save, save to a specific folder, and delete User Reports.

2.Report Parameter Files - external (*.xml) files that are saved locally to your hard drive, so they can only be accessed by you or shared with others for future use.

 

User Reports

 

User reports can be saved to the database for any published report. These are especially helpful for running reports in Enterprise or scheduling recurring reports using EQuIS Information Agents (EIAs).

 

Notes: EIAs will only run for user reports created by user accounts with Application-Level Security logins (either an EQuIS Enterprise login, or a Windows login if the user can also access Enterprise with that username). User reports created by SQL users cannot run in EIAs. To determine the login type used, see the screenshots on the EQuIS Professional Login help page.

 

Saving a User Report

 

1.User reports can only be saved for published reports. If your User Report toolbar is greyed out, this means that the base report is not published to the database. If that is the case, you will need to first publish the base report to the database.

2.Select the input parameters.

3.Enter the name of the User Report.

 

Warning: SQL commands (e.g. 'UPDATE', 'DELETE') should not be included in the name of the user report, as they will cause an "Unsafe SQL" error.

 

4a. To save a User Report directly to the database: click the User Report Save button located to the right of the report name field.

4b. To save a User Report to the database in a specific folder: click the Save selections to database in a specific folder button located to the right of the save button. A window list of
      folders will appear, select a folder group and click Save.

5.A message will appear indicating success, select OK. Once the User Report is saved, the name will display and the report will be available in the User Report drop-down list. If saved to a folder, a new record will be added to rt_group_member for the new user report. For information on creating new folders, see Enterprise Explorer Widget. See also, Group Types.

 

SaveUserReportSuccess

 

Notes:

User Reports in this list are limited to those where the ST_USER_REPORT_PARAMETER.PARAM_NAME = @facility_id record has a PARAM_VALUE = NULL or matches the FACILITY_ID for the current facility.

User Reports may be saved to multiple group folders.

 

manage_user_reports

 

If the user changes any parameter(s) in the currently loaded User Report, that User Report name will be removed from display, since it is no longer representative of the selected parameters.

 

When a parameter of the base report (class type or dll reports) of a User Report has a macro default/Value (starting with $) and users do not click on it or change the value of the parameter when creating a User Report, the ST_USER_REPORT_PARAMETER.PARAM_VALUE from the parameter in the saved User Report is the macro defaultValue. If the user does click on it or change the value of the parameter during creation of a User Report, the selected or changed value of the parameter is saved in the ST_USER_REPORT_PARAMETER.PARAM_VALUE of the User Report, not the macro defaultValue.

 

Update Existing User Report

 

1.Select the report from the User Report drop-down list.

2.Note or copy the exact name.

3.Edit the parameters as desired.

4.Manually enter the name of the existing report back in the User Reports name field.

5.Click the User Report Save button, located to the right of the report name field.

 

Delete User Report

 

1.Select the User Report from the drop-down menu.

2.Click Delete to remove the User Report from the display list and delete it from the EQuIS Database.

 

Make User Report Use Excel Template File in Output

 

1.Navigate to the desired Excel Template file on your computer, save and take note of the file name (e.g. ARII_B30_template.xlsm).

2.Enter your Excel template name (e.g. ARII_B30_template.xlsm which will be used for a particular Analytical Results II (ARII)) User Report) into ST_USER_REPORT.XLT.

3.Upload the template file into the DT_FILE table of EQuIS Professional via the Docs&Photos Form.

4.Open the ARII Report and load the User Report.

5.Run the ARII Report and export the results to an Excel file, which will be generated from ARII_B30_template.xlsm.

 

Publish Column Chooser Configuration with User Report

 

1.Open a grid report, make parameter selections (or use a XML or User Report) and run report.

2.Select the Column Chooser button .

3.Edit the column configuration to your desired output.

4.Close the Column Chooser dialog.

5.Click Column Chooser button Column Chooser-16 > Publish Column Configuration*.

6.Dialog appears asking for the name of the User Report.
If a User Report was used in Step 1, the name will Default to that User Report name.
If a new User Report name is entered, a dialog will appear confirming creating a new User Report.

7.The report '[USER REPORT NAME]' has been saved successfully. Click OK.

 

User Reports published with a Column Chooser Configuration will:

1.be available for use in the EZView Widget in Enterprise

2.be displayed in the User Report drop-down list with a (cc) at the end of the User Report name:

 

15338-arii_cc

 

Report Parameter Files

 

Report parameter files are external (*.xml) files stored locally for future use. User Report parameters can be saved as a *.xml file and opened in any database. The top report toolbar provides easy access to existing local report parameter files, and options to load and save new files (see image below).

 

manage_report_param_files

 

Save Report Parameter Files

 

1.Select input parameters.

2.Click Save.

3.Enter the file name when prompted.

4.Review the directory location and change, if desired.

5.Click Save.

 

Once the report parameters are saved, the name will display and it will be available in the Parameter files drop-down list for this report (see screenshot above). The list populates from the Current Working Folder as defined in EQuIS Professional Options (default = .Documents\My EQuIS Work\[database]\facility_name]); parameter files saved elsewhere are not available from the drop-down menu.

 

If the user changes any parameter(s) in the currently loaded parameter file, that file name will be removed from display, since it is no longer representative of the selected parameters.

 

Update Existing Report Parameter Files

 

1.Select the report from the Parameter files drop-down menu. Alternatively, use the Load selections button (folder icon) to the left to open a file from a directory other than the Current Working Folder for EQuIS Professional. Note the Load option is not currently linked to the Parameter files menu, so the field clears when this option is used to open parameter files.

2.Note or copy the exact name.

3.Edit parameters as desired.

4.Manually enter the name of the existing report back in the Parameter files field.

5.Click Save.

 

Revision History: In version 7.0, the revision below has been completed.

After users modify certain User Report parameters by manually typing a new value and then directly clicking on the Save selections to database as User Report button to save the change, the message, "The report '...' has been saved successfully" is displayed in a pop-up window. The change to the parameter is actually not saved and users will find this out when reloading the user report. The issue is fixed (Case 132098).

 

Troubleshooting

Foreign Key Constraint Error

If you receive an error message that begins with "The INSERT statement conflicted with the FOREIGN KEY constraint" when attempting to save a user report, this means that the published version of the base report (the report you are creating a user report from) needs to be updated. To correct this error you will need to republish the base report, and then you will be able to save your user report.

Parse Error

Some users may encounter an error message that begins with the following text:

System.ApplicationException ---> System.Runtime.Serialization.SerializationException: Parse Error, no assembly associated with Xml Key NewDataSet

This error indicates that you are attempting to use a saved User Report or a report parameter file created in one report in a different report. This includes reports created in a crosstab or graph report which should not be opened in the base report as this action will trigger the error above. To avoid this error, only use User Reports or report parameter files in the reports they were created in.