Summary
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
- Settings.
- System Setup.
- Styles.
- 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 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)
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 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]
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
- Click Reportpads.
- Click All.
- Type 'exam' on your keyboard and the software will locate the Example reportpad.