How to Format Text and Number

How to Format Text and Number

Created by: Geraldene Sibi de la Torre

Modified on: Mon, 12 Aug, 2019 at 3:05 PM

The Wink Reports Report Designer uses default formatting for text and numbers.

You can change how these are displayed to make the content easier to view and understand.

In the report designer, select COLUMNS.

Then, click the dropdown arrow in the Selected Column (in the pop-up screen).

The list of columns that can be selected will be shown as below.

For instance, I want to format the Tax Amount column in my report.

I will just scroll down, then highlight and click Tax Amount. 

Now, I can format this column as I want.

    • Select either BOLD, ITALIC and/or Font Alignment.

    • Click the dropdown arrow 
    • Select your preferred number format

  • CHANGE WIDTH -  allows you to independently adjust column width for each column
    • Click Arrow Up to increase 
    • Click Arrow Down to decrease
    • Set the Width = 0, to hide the column

  • TOTAL ROW - you can easily turn the Total Row on/off at the bottom of your report 
    • Click the dropdown arrow
    • Select "NO TOTAL" if no total is needed or select your preferred Total Row format as below

Congratulations, you have successfully changed the format of your text and numbers

    • Related Articles

    • How to change Wink Report Header text and background colours Print

      Created by: Andrei Gromek Modified on: Tue, 18 Sep, 2018 at 2:06 PM Outline Wink Reports allows users to change the colour of header rows and the colour of text on the header rows on their reports. Follow these steps to change your header row ...
    • Report Designer Formula Reference

      There are two places where formulas can be used in the report designer tool: Row Filter formula for reports Value Source formula for cells Both have the same syntax, but are used in different ways. The general formula language is inspired by the ...
    • Report Designer Excel Style Formulas

      Created by: Gavin Hodge Modified on: Fri, 14 Feb, 2020 at 9:43 AM Most formula transformations can be done using value source formulas, but the report designer tool also supports using literal Excel style formulas.  While value source formulas are ...
    • How to decide when to use Value Source or Excel formulas?

      Created by: Johann Du Toit Modified on: Fri, 14 Feb, 2020 at 9:41 AM Warning! This is a confusing subject, but please bear with us. If you've done some report designs and created formula columns, then you would be familiar with "Value Source" or ...
    • Learn Regex The Easy Way

      What is a Regular Expression? A regular expression is a group of characters or symbols which is used to find a specific pattern in a text. A regular expression is a pattern that is matched against a subject string from left to right. Regular ...