ORS - Revision history

Anw: Updated

2025-08-20T09:08:38Z

Updated

← Older revision		Revision as of 11:08, 20 August 2025
Line 89:		Line 89:
	[[Image:ors_15.png]]		[[Image:ors_15.png]]

	It is worth noting that any columns with the "Req" (required) field set to "Y" already have the "Inc" (included) check box selected. The "req" column is not updatable via this screen, it’s value is set in the corresponding database table.		It is worth noting that any columns with the "Req" (required) field set to "Y" already have the "Inc" (included) check box selected. The "req" column is not normally updatable via this screen, it’s value is set in the corresponding database table.


	You may ~~also~~ change the "Req" value - this affects whether the parameter is required when running the report, from here and any other system that allows running of saved ORS reports, such as Calidus Portal or CTL. {{Warning}} Changing the value in this field can result in massively inefficient reports, so much care should be taken. Confirm this with your system administrator first.		You may change the "Req" value if your user group is configured to allow this - this affects whether the parameter is required when running the report, from here and any other system that allows running of saved ORS reports, such as Calidus Portal or CTL. {{Warning}} Changing the value in this field can result in massively inefficient reports, so much care should be taken. Confirm this with your system administrator first, and they can set the function for your group (ORS_Edit_Req_Field).

	Having selected the "Include All" button, we can again run the report via the "Create CSV" button and, in the following example, see the addition of an extra column to the extract .csv file.		Having selected the "Include All" button, we can again run the report via the "Create CSV" button and, in the following example, see the addition of an extra column to the extract .csv file.
Line 226:		Line 226:
	\|-		\|-
	\| ORS_TYPE_EXC_GROUP \|\| Exclude ORS types from grouping fields \|\| SYSTEM		\| ORS_TYPE_EXC_GROUP \|\| Exclude ORS types from grouping fields \|\| SYSTEM
			\|}


			The following Access Control Group Accessible Functions affect this functionality.

			{\| class="wikitable" border="1"
			\|- bgcolor="silver"
			!Function !! Description
			\|-
			\|ORS_Edit_Req_Field \|\|Ability to edit required fields in ORS report
	\|}		\|}

Anw: Added Report Scheduling

2025-07-30T10:37:16Z

Added Report Scheduling

← Older revision		Revision as of 12:37, 30 July 2025
Line 210:		Line 210:
	1, PLANNED, DEPOT2		1, PLANNED, DEPOT2

			== Scheduling ORS Reports ==
			Details of this can be found here: [[EDI - Report/Extract Scheduling]].

	== Further Configuration ==		== Further Configuration ==

Anw: Added Req field changing.

2024-08-05T13:57:44Z

Added Req field changing.

← Older revision		Revision as of 15:57, 5 August 2024
Line 90:		Line 90:

	It is worth noting that any columns with the "Req" (required) field set to "Y" already have the "Inc" (included) check box selected. The "req" column is not updatable via this screen, it’s value is set in the corresponding database table.		It is worth noting that any columns with the "Req" (required) field set to "Y" already have the "Inc" (included) check box selected. The "req" column is not updatable via this screen, it’s value is set in the corresponding database table.


			You may also change the "Req" value - this affects whether the parameter is required when running the report, from here and any other system that allows running of saved ORS reports, such as Calidus Portal or CTL. {{Warning}} Changing the value in this field can result in massively inefficient reports, so much care should be taken. Confirm this with your system administrator first.

	Having selected the "Include All" button, we can again run the report via the "Create CSV" button and, in the following example, see the addition of an extra column to the extract .csv file.		Having selected the "Include All" button, we can again run the report via the "Create CSV" button and, in the following example, see the addition of an extra column to the extract .csv file.

Anw: Merged from training document

2024-06-10T11:03:50Z

Merged from training document

@@ Line 6: / Line 6: @@
 [[Image:ors_1.png]]
@@ Line 68: / Line 63: @@
-==Amending The Report Titles==
+==Amending the Report Titles==
 If we wished to change the Excel column titles, we need to change the "Displayed Title" on the form. In the following example, we have amended the Displayed Title from "Order Ref" to "Order Reference".
@@ Line 177: / Line 172: @@
 As can be seen above, the report "orderheader1" is no longer shown in the "Saved Reports" list.
 If after deletion, there was a requirement to retrieve this report we could log on as the user we copied the original report to in section 2.7.

Anw: Added system parameters affecting the screen

2024-06-07T07:25:37Z

Added system parameters affecting the screen

← Older revision		Revision as of 09:25, 7 June 2024
Line 178:		Line 178:
	If after deletion, there was a requirement to retrieve this report we could log on as the user we copied the original report to in section 2.7.		If after deletion, there was a requirement to retrieve this report we could log on as the user we copied the original report to in section 2.7.


			== Further Configuration ==
			The following System Parameters affect this functionality:
			{\| class="wikitable" border="1"
			\|- bgcolor="silver"
			!Parameter !! Description !! Level
			\|-
			\| ORS_DELIMITER \|\| Oracle reporting suite data field delimiter \|\| SYSTEM
			\|-
			\| ORS_SUMMARY \|\| Allow the summarisation OF ORS reports \|\| SYSTEM
			\|-
			\| ORS_TYPE_DEF_GROUP_BY \|\| List of the ORS types to default group by fields \|\| SYSTEM
			\|-
			\| ORS_TYPE_EXC_GROUP \|\| Exclude ORS types from grouping fields \|\| SYSTEM
			\|}

	<noinclude>		<noinclude>

Anw: Categorisation

2024-05-17T14:57:56Z

Categorisation

← Older revision		Revision as of 16:57, 17 May 2024
Line 179:		Line 179:


			<noinclude>
	[[Category:Reports\|100]]		[[Category:Reports\|100]]
	[[Category:C-TMS Modules\|E-100]]		[[Category:C-TMS Modules\|E-100]]
	[[Category:C-TMS User Guide\|BE-100]]		[[Category:C-TMS User Guide\|BE-100]]
	[[Category:Interfaces]]		[[Category:Interfaces]]
			</noinclude>

Anw: Minor formatting change

2024-05-17T08:02:57Z

Minor formatting change

Show changes

Anw: Added link to all ORS Reports

2024-05-07T09:10:57Z

Added link to all ORS Reports

Show changes

Anw: Categorisation

2024-02-16T09:42:10Z

Categorisation

← Older revision		Revision as of 11:42, 16 February 2024
Line 179:		Line 179:
	[[Category:C-TMS Modules\|E-100]]		[[Category:C-TMS Modules\|E-100]]
	[[Category:C-TMS User Guide\|BE-100]]		[[Category:C-TMS User Guide\|BE-100]]
			[[Category:Interfaces]]

Middletong at 13:39, 9 August 2011

2011-08-09T13:39:36Z

← Older revision		Revision as of 15:39, 9 August 2011
Line 175:		Line 175:
	As can be seen above, the report “orderheader1” is no longer shown in the “Saved Reports” list.		As can be seen above, the report “orderheader1” is no longer shown in the “Saved Reports” list.
	If after deletion, there was a requirement to retrieve this report we could log on as the user we copied the original report to in section 2.7.		If after deletion, there was a requirement to retrieve this report we could log on as the user we copied the original report to in section 2.7.

			[[Category:Reports\|100]]
			[[Category:C-TMS Modules\|E-100]]
			[[Category:C-TMS User Guide\|BE-100]]