I have an excel report where one of my fields is a Customer Number. When I add the field to my Excel based report I get the green arrow in the upper left (Number stored as text).
I would very much like to not have this message because it does not look good. Are there any suggestions for how to remove this warning for all users. I know I can disable this in my copy of Excel but I want this for all external users.
You can override the source format for the field in the Excel report. You will have to deselect the default option of "Keep Source Formats" for the field, and then you can apply Excel or custom formatting to ensure it does not come in as text.
Once your source data is converted to numeric format using the load script in the QVW, then you should no longer show number as text fields in your 'send to excel' or your NPrinting excel report output.
This community user does not receive direct private messages
You need to specify the format of the Expressions in Number tab or by using Num(), and in Dimensions you have to use Num(DimensionName, '###0') as calculated dimension in the front end or you can also do the same in the back end load script like below