Display Groups of STATUS_FLAG=R

<< 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.

1.Find the Report ID.

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.