smoothpay wrote:
date formats (any formats) don't work
currency fields are truncated (trailing zero is dropped off, e.g. 123.40 is printed as 123.4) and don't show currency symbol
Formatting works fine if do things correctly as shown in video tutorials ...
Let me give some explain here.
1) Please note that on the left side of Report Designer you can see [ Controls / Fields ].
When you design a report, you define some query and use some test db.
FIELDS from this SELECT query are listed under FIELDS section.
You should drag and drop that fields into report to use them.
This is the best way. This is the most right way.
Report knows that this is field from cursor.
Report knows its type and can use that info.
2) You instead have used EXPRESSION control. Even worse. You have wrap fields by $F() macro.
This macro is intended first of all, for reports of mail-merge type or such. For example:
==================
Hellow $F(fldFirstName)!
We want invite your company $F(fldCompanyName) to our event ...
....
==================
You see? Idea of Macros is to convert FIELD value into text ...
This is why in your report formatting of currency and date did not work.
Report engine see text but not numbers.
But still thank you for this finding, Matt! Our guys now want improve this to force formatting work with text also: engine will try convert text into a number...
This will work for 5.0b37 build. Just again, this is not very right way because you get internally double conversion: number -> text -> number.
3) also note, that in EXPRESSION control you should prefer use not MACROSES $MM(), but expressions.
Expressions start with '='
Examples:
=f1 the same as FIELD f1
=f1+f2 internally into your SELECT will be added SELECT (f1+f2), ... and DB engine self calc this expression.
It is obvious then that can be used any expression supported by SQL of DB engine.
======================
Hope this helps...
RESUME: there was no bug. But found a way to improve things with TEXT + formatting property.