This article shows you how to use certain formatting in Reportpads for
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.
Placing [e] after the text reverts it to the standard font.
You can view all font numbers (e-values) by clicking
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
To create the following table, using manual values
Line one of figures entered directly | 1,000 | (2,500) |
Line two of figures entered directly | 9,000 | 3,500 |
Line three of figures entered directly | 10,000 | 12,500 |
_______ | _______ | |
Total of above | 20,000 | 13,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)
At time you may want to create a table with text in it.
To create a table similar to the following
Name of subsidiary | Country of incorporation | Share type | Percentage of shares |
First Subsidiary Limited | England & Wales | Ordinary A | 100% |
Subsidiary Two Ltd | Scotland | Ordinary B | 90% |
Third Company Limited | England & Wales | Preference B | 51% |
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]
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]).