Toad World® Forums

How to change default format for numeric fields in Data Report Designer


#1

When I right click on the query result and click Send To -> Data Report Designer, and use the Data Report Wizard to generate a report, all of the numeric fields have the default format of currency with the dollar sign. How do I change the default format for the Data Report?


#2

Click on the field that is displaying currancy. Click the little right arrow so you can get the drop down shown in the first screenshot. Then choose Format String. This will bring up the editor that is shown in the second screenshot. Choose the currency formats.

Debbie
DataReport2.png


#3

Click on the field that is displaying currancy. Click the little right arrow so you can get the drop down shown in the first screenshot. Then choose Format String. This will bring up the editor that is shown in the second screenshot. Choose the currency formats.

Debbie
DataReport1.png


#4

Is there anyway to set the DEFAULT format, instead of manually changing format for each field afterward?


#5

No. But you can create a custom style in the colleciton editor and then apply to the fields you want. This way you define it once and then set to the fields that it applies.

Debbie
DataReport3.png