7 Columns - Revision history

Gibbo at 20:33, 24 November 2011

2011-11-24T20:33:51Z

Simon Clive at 07:03, 4 July 2011

2011-07-04T07:03:29Z

Simon Clive at 06:43, 4 July 2011

2011-07-04T06:43:03Z

Simon Clive at 06:24, 1 July 2011

2011-07-01T06:24:06Z

Simon Clive: Created page with " Customise Lists and Sorting Columns Do you know how to sort columns in the list by alpha-numeric ascending or descending order? Click on any report or list column header and ..."

2011-06-27T02:54:41Z

Created page with " Customise Lists and Sorting Columns Do you know how to sort columns in the list by alpha-numeric ascending or descending order? Click on any report or list column header and ..."

New page

Customise Lists and Sorting Columns

Do you know how to sort columns in the list by alpha-numeric ascending or descending order?

Click on any report or list column header and a hand symbol will sort the column by ascending or descending, click the
header again to change.

Do you know how to move columns around and place them where you want?

Left mouse click on any report or list column header and drag it to the new desired position, then simply release
mouse (click and drag). This will move the whole column to the new position.

Do you know how to customise your lists to display the columns you wish to view?

From the list or report that you wish to customise eg. customer list, select the tab then press the 'customise'
button, then the Main Grid Screen appears.
The features and functionality of this area are global and apply to all reports. The information available will vary
however the theory is the same.

You can now choose whether you customise the list for just the user (person logged in) or globally by selecting
the tab at the bottom left 'user' or 'global'. This determines who sees the changes.

On the grid tab select or de-select the columns that you want to show on the List/Report, by ticking or unticking.
The boxes ticked will be visible and the unticked boxes will not be visible on the List/Report.
(Note: Ticked columns will appear at the top of the lists and then unticked)

To change the header label/name on the columns, click on customise, double click the label and simply key in
the preferred label/name.

To turn off the grid lines, click on customise, and untick the box at right to turn off, tick again to turn on (enable).

To add your own customised column to a list/report, click on customise, then click on the New tab under
custom column. Then enter the name for the new column and click OK. This will then take you back to the main
customising list screen.The new column just added will appear in the list and the formula screen will be available
to enter a formula if required, a mathematical formula can now be entered in this column.

> right click in the column formula field and mathematical options and a list of columns will appear.
> You can now build the formula using existing columns and mathematics.

You can also choose how to display the column by simply choosing a format from the display format field.

Within the main customise list screen you also have the Custom Report Tab

> This tab allows you to rename the report you are creating so that the default report is untouched.
> All the changes made will be on the new report and not on the default report.
> You can give the report a unique name.
> To enable other people to view the newly created report, place in another tab on the report selector.

(Note: If you only name the report and choose not to place on any other tab, the report will only be visible in the My
Reports area of the report selector and this area is protected by your user name and password. ie. other people
cannot see the reports that are unique to you).

After you have named the report and placed it in other visible areas (if desired) click the 'create custom report'
button to activate.

After creating any changes you require, click OK to save changes.

In this area you can also customise the columns by clicking on the column title, holding down the left mouse
you can dragg the columns to the preferred layout and place them on the grid where you choose. You can also
increase or decrease the size of the columns by clicking on the line between the colomn titles and move left or
right depending on what size is required.
When you close the list the new positions and lay out will be remembered. ie. the list will open in the same
layout or format that it was last viewed in.
This layout is specific to each user. The unique user name and password will trigger the layouts specific for that
person.

@@ Line 8: / Line 8: @@
 <br> Do you know how to '''Move Columns''' around and place them where you want?
-*'''Left Click '''and'''Hold''' on any report or list column header and '''Drag''' it to the new desired position,&nbsp; then simply release the mouse.
+*'''Left Click '''and '''Hold''' on any report or list column header and '''Drag''' it to the new desired position,&nbsp; then simply release the mouse.
 *This will move the whole column to the new position. this is called '''Click''' and '''Drag.'''
 <br> Do you know how to '''Customise''' your lists to display the columns you wish to view?
-*'''Select''' the list or report that you wish to customise '''E.g.''' '''Customer List''' button and the '''Main Grid'''screen appears.
+*'''Select''' the list or report that you wish to customise '''E.g.''' Slect S'''ales in the main menu&nbsp;.'''
-*The features and functionality of this area are '''Global''' and apply to all reports. The information available will vary, however the theory is the same.
+*'''Select &nbsp;''''''Customer List''' button and the '''Main Grid S'''creen appears for customers. Ther are similar grids for all of the lists in ERP..
 *You can now choose whether you '''Customise''' the list for just the '''User''' (person logged in) or '''Globally''' by selecting the tab at the bottom left '''User''' or '''Global''' which determines who sees the changes.
 *On the '''Main Grid''' screen select or de-select the columns that you want to show on the List/Report, by '''Ticking''' or '''Unticking'''. The boxes ticked will be visible and the unticked boxes will not be visible on the List/Report. '''N.B.''' Ticked columns will appear at the top of the lists and the unticked below.<br>
 *To '''Edit''' the header label/name on the columns, click on '''Customise''', double click the label in the '''Main Grid''' and simply type in the preferred label/name.
-*To turn off the grid lines, click on '''Customise''', and untick the '''Enable Grid Lines''' box on the right. Tick again to Enable Grid Lines<br>
+*To turn off the grid lines, click on '''Customise''', and untick the '''Enable Grid Lines''' box on the right. Tick again to Enable Grid Lines
-*To '''Add''' your own customised column to a list/report, click on '''Customise''', then click on the '''New''' button in the '''Custom Column''' box. Then '''Type''' in the name for the new column and click '''OK'''. This will then take you back to the main customising list screen.
-*The new column just added will appear in the list and the'''Formula Screen''' will be available to enter a Formula if required, a mathematical formula can now be entered in this column.
 *Right click in the '''Column Formula''' field and mathematical options and a list of Columns will appear. You can now build the formula using existing columns and mathematics.
 *You can also choose how to display the column by simply choosing a format from the '''Display Format''' field.
-*Within the main '''Customise List''' screen you also have the '''Custom Report''' Tab. This tab allows you to '''Rename''' the report you are creating so that the '''Default''' report is untouched.&nbsp; All the changes made will be on the '''New''' report and '''Not''' on the '''Default''' report.&nbsp;
 *Select the '''Report Selector Tab''' to move this unique report to another '''Module''' on the '''Report Selector'''.
 *'''N.B.''' If you only name the report and choose not to place it in any other '''Module''', the report will only be visible in the '''My Reports''' area of the report selector and this area is protected by your user name and password. I.e.. other people cannot see the reports that are unique to you.
 *After you have named the report and placed it in other visible areas (if desired) click the '''Create Custom Report''' button to activate.
 *After creating any changes you require, click '''Ok''' to '''Save''' changes.

@@ Line 16: / Line 16: @@
 *The features and functionality of this area are '''Global''' and apply to all reports. The information available will vary, however the theory is the same.
 *You can now choose whether you '''Customise''' the list for just the '''User''' (person logged in) or '''Globally''' by selecting the tab at the bottom left '''User''' or '''Global''' which determines who sees the changes.
 *On the '''Main Grid''' screen select or de-select the columns that you want to show on the List/Report, by '''Ticking''' or '''Unticking'''. The boxes ticked will be visible and the unticked boxes will not be visible on the List/Report. '''N.B.''' Ticked columns will appear at the top of the lists and the unticked below.<br>
 *To '''Edit''' the header label/name on the columns, click on '''Customise''', double click the label in the '''Main Grid''' and simply type in the preferred label/name.
 *To turn off the grid lines, click on '''Customise''', and untick the '''Enable Grid Lines''' box on the right. Tick again to Enable Grid Lines<br>
-*To'''Add''' your own customised column to a list/report, click on '''Customise''', then click on the '''New''' button in the '''Custom Column''' box. Then '''Type''' in the name for the new column and click '''OK'''. This will then take you back to the main customising list screen.
+*To '''Add''' your own customised column to a list/report, click on '''Customise''', then click on the '''New''' button in the '''Custom Column''' box. Then '''Type''' in the name for the new column and click '''OK'''. This will then take you back to the main customising list screen.
 *The new column just added will appear in the list and the'''Formula Screen''' will be available to enter a Formula if required, a mathematical formula can now be entered in this column.
 *Right click in the '''Column Formula''' field and mathematical options and a list of Columns will appear. You can now build the formula using existing columns and mathematics.
 *You can also choose how to display the column by simply choosing a format from the '''Display Format''' field.
 *Within the main '''Customise List''' screen you also have the '''Custom Report''' Tab. This tab allows you to '''Rename''' the report you are creating so that the '''Default''' report is untouched.&nbsp; All the changes made will be on the '''New''' report and '''Not''' on the '''Default''' report.&nbsp;
 *Select the '''Report Selector Tab''' to move this unique report to another '''Module''' on the '''Report Selector'''.
 *'''N.B.''' If you only name the report and choose not to place it in any other '''Module''', the report will only be visible in the '''My Reports''' area of the report selector and this area is protected by your user name and password. I.e.. other people cannot see the reports that are unique to you.
 *After you have named the report and placed it in other visible areas (if desired) click the '''Create Custom Report''' button to activate.
 *After creating any changes you require, click '''Ok''' to '''Save''' changes.

@@ Line 1: / Line 1: @@
 '''Customise Lists and Sorting Columns'''
 Do you know how to '''Sort Columns '''in the list by alpha-numeric ascending or descending order?
 *'''Click''' on any report or list column header and a '''Hand Symbol''' will sort the column by ascending or descending order.
 *'''Click '''the header again to change back.
 <br> Do you know how to '''Move Columns''' around and place them where you want?
 *'''Left Click '''and'''Hold''' on any report or list column header and '''Drag''' it to the new desired position,&nbsp; then simply release the mouse.
 *This will move the whole column to the new position. this is called '''Click''' and '''Drag.'''
 <br> Do you know how to '''Customise''' your lists to display the columns you wish to view?
-'''Select''' the list or report that you wish to customise<span style="font-weight: bold;" /> eg. '''Customer List''' and select the '''Customise Button '''and the '''Main Grid ''''''Screen''' appears.
+*'''Select''' the list or report that you wish to customise '''E.g.''' '''Customer List''' button and the '''Main Grid'''screen appears.
+*The features and functionality of this area are '''Global''' and apply to all reports. The information available will vary, however the theory is the same.
-The features and functionality of this area are global and apply to all reports. The information available will vary, however the theory is the same.
+*You can now choose whether you '''Customise''' the list for just the '''User''' (person logged in) or '''Globally''' by selecting the tab at the bottom left '''User''' or '''Global''' which determines who sees the changes.
+*On the '''Main Grid''' screen select or de-select the columns that you want to show on the List/Report, by '''Ticking''' or '''Unticking'''. The boxes ticked will be visible and the unticked boxes will not be visible on the List/Report. '''N.B.''' Ticked columns will appear at the top of the lists and the unticked below.<br>
-You can now choose whether you customise the list for just the user (person logged in) or globally by selecting the tab at the bottom left 'user' or 'global'. This determines who sees the changes.
+*To '''Edit''' the header label/name on the columns, click on '''Customise''', double click the label in the '''Main Grid''' and simply type in the preferred label/name.
+*To turn off the grid lines, click on '''Customise''', and untick the '''Enable Grid Lines''' box on the right. Tick again to Enable Grid Lines<br>
-On the grid tab select or de-select the columns that you want to show on the List/Report, by ticking or unticking. The boxes ticked will be visible and the unticked boxes will not be visible on the List/Report. (Note: Ticked columns will appear at the top of the lists and then unticked)
+*To'''Add''' your own customised column to a list/report, click on '''Customise''', then click on the '''New''' button in the '''Custom Column''' box. Then '''Type''' in the name for the new column and click '''OK'''. This will then take you back to the main customising list screen.
+*The new column just added will appear in the list and the'''Formula Screen''' will be available to enter a Formula if required, a mathematical formula can now be entered in this column.
-To change the header label/name on the columns, click on customise, double click the label and simply key in the preferred label/name.
+*Right click in the '''Column Formula''' field and mathematical options and a list of Columns will appear. You can now build the formula using existing columns and mathematics.
+*You can also choose how to display the column by simply choosing a format from the '''Display Format''' field.
-To turn off the grid lines, click on customise, and untick the box at right to turn off, tick again to turn on (enable).
+*Within the main '''Customise List''' screen you also have the '''Custom Report''' Tab. This tab allows you to '''Rename''' the report you are creating so that the '''Default''' report is untouched.&nbsp; All the changes made will be on the '''New''' report and '''Not''' on the '''Default''' report.&nbsp;
+*Select the '''Report Selector Tab''' to move this unique report to another '''Module''' on the '''Report Selector'''.
-To add your own customised column to a list/report, click on customise, then click on the New tab under custom column. Then enter the name for the new column and click OK. This will then take you back to the main customising list screen.The new column just added will appear in the list and the formula screen will be available to enter a formula if required, a mathematical formula can now be entered in this column.
+*'''N.B.''' If you only name the report and choose not to place it in any other '''Module''', the report will only be visible in the '''My Reports''' area of the report selector and this area is protected by your user name and password. I.e.. other people cannot see the reports that are unique to you.
+*After you have named the report and placed it in other visible areas (if desired) click the '''Create Custom Report''' button to activate.
-&gt; right click in the column formula field and mathematical options and a list of columns will appear. &gt; You can now build the formula using existing columns and mathematics.
+*After creating any changes you require, click '''Ok''' to '''Save''' changes.
-−
-You can also choose how to display the column by simply choosing a format from the display format field.
-−
-Within the main customise list screen you also have the Custom Report Tab
-−
-&gt; This tab allows you to rename the report you are creating so that the default report is untouched. &gt; All the changes made will be on the new report and not on the default report. &gt; You can give the report a unique name. &gt; To enable other people to view the newly created report, place in another tab on the report selector.
-−
-(Note: If you only name the report and choose not to place on any other tab, the report will only be visible in the My Reports area of the report selector and this area is protected by your user name and password. ie. other people cannot see the reports that are unique to you).
-−
-After you have named the report and placed it in other visible areas (if desired) click the 'create custom report' button to activate.
-−
-After creating any changes you require, click OK to save changes.
-−
-In this area you can also customise the columns by clicking on the column title, holding down the left mouse you can dragg the columns to the preferred layout and place them on the grid where you choose. You can also increase or decrease the size of the columns by clicking on the line between the colomn titles and move left or right depending on what size is required. When you close the list the new positions and lay out will be remembered. ie. the list will open in the same layout or format that it was last viewed in. This layout is specific to each user. The unique user name and password will trigger the layouts specific for that person.