How to amend date or time object properties on reports

Summary

When adding date or time variables or expressions to a report, you can change the format in which they appear by amending the date and time properties. This article explains how to amend the date and time properties of objects in Sage Report Designer.

Answer

These are the basic steps that explain how to to apply date and time format properties to an object. They include:

  • To open your report in Report Designer
  • To change the properties of a date or time object

To save the changes to your report

To open your report in Report Designer

1. Open the required module > Tasks pane > click the reports option > select the required report > click Edit.

Sage 50 HR 2010 v3.0 and below – Open the required module > Tasks pane > click the reports option > select the required report > click Open.

2. Properties pane > Name > enter a new description for the report > Enter.

 To change the properties of a date or time object

  • Select the object you want to change > Properties pane > Formatting > Date & Time tab > amend the settings as required > OK.

 To save the changes to your report

1. File > Save As > if required, change the location to save the report to, for example, Employment.

2. File name > enter a new file name > Save > File > Exit.

Note: If you can’t see any of the Sage Report Designer panes mentioned in this article, for example the Properties pane, open the View menu and choose the required pane. If the pane does not appear, to reset the Sage Report Designer desktop view to its default, open the Tools menu, choose Options then select the Reset Settings check box. For these settings to take effect, you must close and reopen Sage Report Designer. You can then open the required panes from the View menu.

The following detailed steps contain everything you need to help you to apply date and time format properties to an object.

To open your report in Report Designer

To open a report in Sage Report Designer, from the navigation bar, click the required area, for example, Appraisal, then from the Tasks pane, click the relevant Reports option, for example, Appraisal Reports.

In the Reports window, from the right-hand pane, select the required report.

To open the report in Sage Report Designer, from the Reports toolbar, click Edit.

Sage 50 HR 2010 v3.0 and below – To open the report in Sage Report Designer, from the Reports toolbar, click Open.

Note: If the Open Company window appears, select the required company, click OK, enter your logon details for that company, then click OK again.

In the Properties pane select Name, enter a new description for the report then press Enter.

You have now opened your report in Report Designer and entered a new report description. You can now amend the date and time properties of objects on your report. For further information, please refer to the following sections.

 To change the properties of a date or time object

From the report design area, select the required object.

To change the date or time format, from the Properties pane, click Formatting then click the finder button .

Tip: If you have chosen to auto-hide any of your Report Designer panes, the name appears in a tab to the left or right of your window. To expand a pane, click on its name. If you have closed any of your Report Designer panes, to open them, from the View menu, choose the relevant pane.

From the Formatting window click the Date & Time tab, then amend your date or time formatting settings as required.

For a detailed explanation of the date formatting and time formatting options, please refer to the following section, The date and time options.

Tip: You can choose a format from the drop-down list, or manually enter the required format.

To confirm the changes, click OK.

You have now amended the properties of the date object on your report. You should make any further changes required then save your report. For further information about how to save the amended report, please refer to the section To save the changes to your report later in this article.

 The date and time options

d Used to specify the format used for the day. A single d displays the correct date, but suppresses the leading zero, where applicable, for example, the first of the month appears as 1.
dd Displays a leading zero where applicable, for example, the first of the month appears as 01.
ddd Displays the day name in a short text format, for example, Monday appears as Mon.
dddd Displays the complete day name in text format, for example, Monday appears as Monday.
M Used to specify the format used for the month. A single M displays the correct month, but suppresses the leading zero, where applicable, for example, January appears as 1.
MM Displays a leading zero where applicable, for example, January appears as 01.
MMMM Displays the complete month name in text format, for example, January appears as January.
yy Displays a leading zero where applicable, for example, 2009 appears as 09.
yyyy Displays the complete year, including the century, for example, 2011 appears as 2011.
H Used to specify the format used for an hour. A single H displays the correct hour, but suppresses the leading zero, where applicable, for example, one AM appears as 1. An upper case H is used to specify the 24 hour clock format.
HH Displays the leading zero where applicable. For example, one AM appears as 01. An upper case HH is used to specify the 24 hour clock format.
h Used to specify the format used for an hour. A single h displays the correct hour, but suppresses the leading zero, where applicable, for example, one o’clock appears as 1. A lower case h is used to specify the 12 hour clock format.
hh Displays the leading zero where applicable. For example, one AM appears as 01. A lower case hh is used to specify the 12 hour clock format.
mm Used to display the number of minutes. This is always displayed as two digits.
ss Used to display the number of seconds. This is always displayed as two digits.
tt Used to display whether the time is AM or PM when using a 12 hour clock format. This is always used in conjunction with the 12 hour clock format listed above.

To save the changes to your report

To save the changes to your report, open the File menu and choose Save As.

From the Save As window, in the File name box, enter a file name for your amended report.

The Save As window displays the current location of the report. If you want to save your report in an alternative folder, browse to the required folder.

To save the report, click Save.

To close Sage Report Designer, open the File menu and choose Exit.

You have now saved the changes to your report.

Answers to common questions

What you’ve been asking us…

How do i change the numeric formatting of items on my report?

How do i rename and save my report?

d Used to specify the format used for the day. A single d displays the correct date, but suppresses the leading zero, where applicable, for example, the first of the month appears as 1.
dd Displays a leading zero where applicable, for example, the first of the month appears as 01.
ddd Displays the day name in a short text format, for example, Monday appears as Mon.
dddd Displays the complete day name in text format, for example, Monday appears as Monday.
M Used to specify the format used for the month. A single M displays the correct month, but suppresses the leading zero, where applicable, for example, January appears as 1.
MM Displays a leading zero where applicable, for example, January appears as 01.
MMMM Displays the complete month name in text format, for example, January appears as January.
yy Displays a leading zero where applicable, for example, 2009 appears as 09.
yyyy Displays the complete year, including the century, for example, 2011 appears as 2011.
H Used to specify the format used for an hour. A single H displays the correct hour, but suppresses the leading zero, where applicable, for example, one AM appears as 1. An upper case H is used to specify the 24 hour clock format.
HH Displays the leading zero where applicable. For example, one AM appears as 01. An upper case HH is used to specify the 24 hour clock format.
h Used to specify the format used for an hour. A single h displays the correct hour, but suppresses the leading zero, where applicable, for example, one o’clock appears as 1. A lower case h is used to specify the 12 hour clock format.
hh Displays the leading zero where applicable. For example, one AM appears as 01. A lower case hh is used to specify the 12 hour clock format.
mm Used to display the number of minutes. This is always displayed as two digits.
ss Used to display the number of seconds. This is always displayed as two digits.
tt Used to display whether the time is AM or PM when using a 12 hour clock format. This is always used in conjunction with the 12 hour clock format listed above.

Version

Sage 50 HR 2007 and above

For further advice or technical queries

Please contact us on:

01603 516350

enquiry@mintmis.com

www.mintMIS.com

Download the above article in PDF for FREE below