Query Studio

Changing the Data Format in Query Studio

You can use predefined formats to change the appearance of numbers, dates, and times without changing the underlying data. For example, you can show a date in abbreviated format or in long format, which spells out the day and month.

Data Format	Description
Default	The default format is the format of the report item before any formatting is applied in Query Studio. Use default to remove formatting.
Number	Use the number format to change the number of decimal places, to specify whether to use a thousands separator, to choose different symbols to represent negative numbers, and to scale large numbers.
Currency	You can choose from many world currencies. Use either the currency symbol or the international code. For example the currency symbol for the euro is € and the international code is EUR. You can also change the number of decimal places, specify whether to use a thousands separator, choose different symbols to represent negative numbers, and to scale large numbers.
Percentage	This format shows a number multiplied by 100, using two decimal places and a percent sign. For example, 0.7356 appears as 73.56%.
Scientific	This format shows a number in exponential notation. For example, the number 224,110 is 2.24110E+05 in scientific notation.
Date and Time	You can choose from a list of date and time formats, including the 12 or 24 hour clock.

To change the format of data in a Query Studio report:

Open the Reports application.
Open the report that you want in Query Studio.
Click the heading of the report item you want to format.
From the Edit Data menu, click Format Data and then click one of the following:
To format numeric data, in the Category box, click a type and define the format as required.
To format text data, in the Category box, click Text and type a number in the Number of visible characters box.
To format date and time data, in the Category box, click a type and then in the Type box, click a format.

Click OK.