Report Attributes via Reporting Templates - Revision history

Vmurrell: /* Attribute Placement Step 4 */

2022-10-13T10:59:20Z

‎Attribute Placement Step 4

2022-09-05T16:07:31Z

2021-06-08T16:26:14Z

2021-04-28T11:15:42Z

‎Convert the data

2021-04-28T11:15:21Z

‎Convert the data

2021-04-28T11:14:04Z

‎Creating the Reporting Template

2021-04-28T11:13:43Z

‎Creating the Reporting Template

2021-04-28T11:13:24Z

‎Creating the Reporting Template

2021-04-28T11:12:48Z

‎Overview

2021-04-28T11:12:15Z

‎Overview

← Older revision		Revision as of 10:59, 13 October 2022
Line 21:		Line 21:

	[[File:RT-ATTS-STEP4.PNG\|Step 4\|1200px]]		[[File:RT-ATTS-STEP4.PNG\|Step 4\|1200px]]
		+
		+
		+	'''Note''': as from Version 11.4, it is no longer possible to use the 'colour picker' insted, just enter the HEX code. The selected colour will appaer lower down the page.

	=Reporting Template Excel Workbook=		=Reporting Template Excel Workbook=

← Older revision		Revision as of 16:26, 8 June 2021
Line 5:		Line 5:

	In this example I am using a Data Structure which has an Attribute relating to the confidentially status of the reported data. This article assumes that you have a basic understandin of how to create a Template using the GUI as explained in this article - [[Create_an_Excel_Reporting_Template\|How to create a Reporting Template]].		In this example I am using a Data Structure which has an Attribute relating to the confidentially status of the reported data. This article assumes that you have a basic understandin of how to create a Template using the GUI as explained in this article - [[Create_an_Excel_Reporting_Template\|How to create a Reporting Template]].
−
−	~~You can read more about [[Excel_Reporting_Template_Data_Format\|Reporting Template Data Formats]] here.~~

	=Creating the Reporting Template=		=Creating the Reporting Template=

@@ Line 40: / Line 40: @@
 [[File:RT-ATTS-3.PNG|200px|thumb|right|Convert the Excel spreadsheet]]
-If you open the XML file and view using Pretty Print (I am using XMLSpy) you will see that the colour coding has taken affect and the correct codes are included agains the Attribute CONF-STATUS.
+If you open the XML file and view using Pretty Print (I am using XMLSpy) you will see that the colour coding has taken affect and the correct codes are included against the Attribute CONF-STATUS.
 [[File:RT-ATTS-4.PNG|XML Data|1200px]]

@@ Line 36: / Line 36: @@
 =Convert the data=
-The next step is to convert the spreadsheet into and XML file via wither the Load from file option or the quick convert option as shown aside.
+The next step is to convert the spreadsheet into a XML file via either the Load from file option or the quick convert option as shown aside.
 [[File:RT-ATTS-3.PNG|200px|thumb|right|Convert the Excel spreadsheet]]

@@ Line 9: / Line 9: @@
 =Creating the Reporting Template=
-The template wizard is created in the usual way for the first 3 steps as shown in the examples aside.
+The template wizard is created in the usual way for the first 3 steps as shown in the example thumbnials aside.
 [[File:RT-ATTS-STEP1.PNG|200px|thumb|right|Step 1]]

@@ Line 4: / Line 4: @@
 In the current version of the Registry, only Dimensions can be included in a Reporting Template (completion worksheet) however it is possible to use Step 4 of the Reporting Template to identify attributes in such a way that when the Template is converted into an XML file, the attributes are included.
-In this example I am using Data Structure which has an Attribute relating to the confidentially status of the reported data. This article assumes that you have a basic understandin of how to create a Template using the GUI as explained in this article - [[Create_an_Excel_Reporting_Template|How to create a Reporting Template]].
+In this example I am using a Data Structure which has an Attribute relating to the confidentially status of the reported data. This article assumes that you have a basic understandin of how to create a Template using the GUI as explained in this article - [[Create_an_Excel_Reporting_Template|How to create a Reporting Template]].
 You can read more about [[Excel_Reporting_Template_Data_Format|Reporting Template Data Formats]] here.

@@ Line 2: / Line 2: @@
 =Overview=
-In the current version of the Registry, only Dimensions can be included in a Reporting Template (main worksheet) however it is possible to use Step 4 of the Reporting Template to identify attributes in such a way that when the Template is converted into an XML file, the attributes are included.
+In the current version of the Registry, only Dimensions can be included in a Reporting Template (completion worksheet) however it is possible to use Step 4 of the Reporting Template to identify attributes in such a way that when the Template is converted into an XML file, the attributes are included.
 In this example I am using Data Structure which has an Attribute relating to the confidentially status of the reported data. This article assumes that you have a basic understandin of how to create a Template using the GUI as explained in this article - [[Create_an_Excel_Reporting_Template|How to create a Reporting Template]].