<< Click to Display Table of Contents >> Navigation: Professional > Groups > Display Groups of STATUS_FLAG=R |
By default, the conditions RT_GROUP.STATUS_FLAG = "A" and RT_MTH_ANL_GROUP.STATUS_FLAG = "A" are included in the relevant report parameters' data sources so that groups with STATUS_FLAG = "R" are not displayed in the group list of the report user interface.
Users can undo this functionality to show all groups, regardless of STATUS_FLAG value, by following the steps below.
2.Open the child table, ST_REPORT_PARAMETER, for that REPORT_ID and find the group-related parameter (e.g., via PARAM_NAME, CAPTION, or DATA_SOURCE). DATA_SOURCE of the group related parameter for that REPORT_ID.
3.In the DATA_SOURCE for that group-related parameter, remove the code for XXX.STATUS_FLAG = "A".
4.Save.
As an example for the Analytical Results II report, follow these steps.
1.Find ST_REPORT.REPORT_ID for ST_REPORT.DISPLAY_NAME = "Analytical Results II".
2.Sort ST_REPORT_PARAMETER for the above REPORT_ID and the group-related parameters PARAM_NAME = "@ANALYTE_GROUPS" and "@LOCATION_GROUPS".
3.Edit ST_REPORT_PARAMETER.DATA_SOURCE for the above parameters to remove WHERE MAG.STATUS_FLAG = "A" and AND STATUS_FLAG = "A", respectively.
Copyright © 2024 EarthSoft, Inc. • Modified: 08 Jul 2024