Changes

Jump to: navigation, search

Custom Export

1,909 bytes added, 19:21, 18 September 2013
no edit summary
=Header=
Defines This section is used top define the text and column headings that will appear above the main body of the report.
Basic descriptive text can simply be typed into the Header field. Ensure that you use Use carriage return to move the cursor onto the next a new line so prior to saving. This will ensure that the header text is on a new line from the main datain the exported report, rather than on the same line.
[[Image:Custom Export1.png|link=|800px]]
When This will ensure that when the report is then exported this the header text will appear at be on a new line from the top of the reportmain data, above rather than on the main datasame line.
[[Image:Custom Export2.png|link=|800px]]
If there needs to be multiple lines of text then use carriage return to move the cursor onto the next line , type in the text and start typingclick Save.
[[Image:Custom Export3.png|link=|800px]]
If there needs to be column headers then simply go onto a new line within the Header section and start typing in the column headers.
The headers should then be separated from each other using the {TAB} syntax. This will ensure that the headers are aligned with the corresponding data when the report is exported.
You can also use the {BREAK} syntax at the end of the column header text to ensure that the headers will appear above the actual data or use carriage return to move the cursor onto the next line.
[[Image:Custom Export6.png|link=|800px]]
 
 
=Fields / Detail=
 
The Field section is used to select the columns from within the report that are to be exported, which are then stored in the Details section.
 
It consists of a drop-down list, showing all the exposed report columns as well as the {TAB} and {BREAK} options.
[[Image:Custom Export7.png|link=|800px]]
 
Simply click on the options in drop-down list to have them store to the Details section.
 
The columns should then be separated from each other using the {TAB} syntax.
 
The last column selected should be preceded by the {BREAK} syntax. This is required to ensure that each new record in the report appears on a separate line.
In the example below there are 4 columns selected (i.e. Name, Address 1. City, Country).
 
[[Image:Custom Export8.png|link=|800px]]
 
When the report is then exported there are 4 discreet columns, with each new record appearing on a new line.
[[Image:Custom Export9.png|link=|800px]]
 
 
=Footer=
 
This section defines the text that will appear below the main body of the report.
 
Basic descriptive text can be typed into the Footer field.
 
[[Image:Custom Export10.png|link=|800px]]
 
When the report is then exported the footer text will be appear below the main data in the report.
 
[[Image:Custom Export11.png|link=|800px]]
 
You can also use the {BREAK} syntax prior to the footer text to ensure that there is some space between the footer and the actual data or use carriage return to move the footer text onto the next line.
 
[[Image:Custom Export12.png|link=|800px]]
 
When the report is then exported the footer text will be appear below the main data in the report.
 
[[Image:Custom Export13.png|link=|800px]]
==See Also==
Smartstaff, administrator
4,478
edits

Navigation menu