Skip to content
logo Knowledgebase

Example of Reportpad formatting

Created on  | Last modified on 

Summary

Some examples of formatting to be used in Sage APA

Description

This article shows you how to use certain formatting in Reportpads for

  • Using e-values to change the font used for text
  • Writing a small table with manual values
  • Table containing text, not numbers
  • Producing a sentence with balances within it


Resolution

TIP: You can insert tables into a Reportpad by clicking Insert/Edit table at the the bottom. This allows you to select what appears and where.

Using e-values to change the font used for text

Using [e0] makes the software use font number 0 for the following text.

Placing [e] after the text reverts it to the standard font.

You can view all font numbers (e-values) by clicking

  1. Settings.
  2. System Setup.
  3. Styles.
  4. Select rtfevfrs.dtx*.

    TIP: the evalue file used depends on various settings, but the standard for FRS companies is the rtfevfrs.dtx

CAUTION: We do not recommend changing the settings of a font as it will cascade through to all clients that font is used for. Instead, scroll to the bottom and create your own font from e90-e99.

EXAMPLE 1

[e4]This is a short subheading[e]//this command uses font [e4], then reverts to standard at the [e]

Will output as

This is a short subheading

EXAMPLE 2

[e2]Or you could put a heading here[e]//this command will use font e2 for the text then revert to standard

Will output as

Or your could put a heading here


Writing a small table with manual values

To create the following table, using manual values

Line one of figures entered directly1,000(2,500)
Line two of figures entered directly 9,0003,500
Line three of figures entered directly 10,00012,500

______________
Total of above20,00013,500

______________


The coding to create this table would be

Line one of figures entered directly [sum 100000 c2][sum -250000 c4]//enter the number multiplied by 100 to allow for rounding.

Line two of figures entered directly [sum 900000 c2][sum 350000 c4]

Line two of figures entered directly  [sum 1000000 c2][sum 1250000 c4]

Total of above [total c2,c4 aul,bdul]//this line totals the column above and applies the line above the total (aul) and the bold line below (bdul)


Table containing text, not numbers

At time you may want to create a table with text in it.

To create a table similar to the following

Name of subsidiaryCountry of incorporationShare typePercentage of shares
First Subsidiary LimitedEngland & WalesOrdinary A100%
Subsidiary Two LtdScotlandOrdinary B90%
Third Company LimitedEngland & WalesPreference B51%


The coding to create this table would be

[col 1 40 this][col 2 56 this][col 3 67 this][col 4 78 this]//this defines the column widths and sets them to output if this year is relevant

["Name of subsidiary" ct f+ bold]["Country of incorporation" c2 f+ bold]["Share type type" c3 f+ bold]["Percentage of shares" c4 f+ bold]//the bold column headings

["First Subsidiary Limited" ct]["England & Wales" c2]["Ordinary A" c3]["100%" c4]

["Subsidiary Two Ltd" ct]["Scotland" c2]["Ordinary B" c3]["90%" c4]

["Third Company Limited" ct]["England & Wales" c2]["Preference B" c3]["51%" c4]


Producing a sentence with balances within it.

You can create a sentence similar to the following

Our sales for the year totalled £100,000 (2019: £75,000) and our Cost of Sales were £25,000 (2019: £23,500).

To format this, you need to use following commands

sum - to extract the sum of a group of codes

text - to convert the balance to text

last - to call last years year end

[$] - for the currency symbol

c2 c4 - call the balances from columns 2 and 4 (this year and last year)

To output the sentence above, you would enter

Our sales for the year totalled [$][sum 1:49 c2 text] ([last]: [$][sum 1:49 c4 text]) and our Cost of Sales were [$][sum 50:149 c2 text] ([last]: [$][sum 50:149 c4 text]).


You can also view this example formatting in SUBLTD clients
  1. Click Reportpads.
  2. Click All.
  3. Type 'exam' on your keyboard and the software will locate the Example reportpad.