How do I designate how values in a column returned in the SQL behind a Flex Report should be formatted? I'm thinking specifically about the formatting of a percentage (decimal) vs. a count (integer).
It seems to me that the column formatting should be defined in the Flex Report. Originally, I thought we could derived the formatting from the name/alias of the column (i.e. NbrStudents vs. PctStudents), but then I quickly realized that it would be awkward to specify decimal places or other formatting attributes.
For charts, the UI to add formatting to a Flex Report doesn't seem too bad. For tables, it's a different story because we don't know beforehand how many columns will be returned.
How do I designate how values in a column returned in the SQL behind a Flex Report should be formatted? I'm thinking specifically about the formatting of a percentage (decimal) vs. a count (integer).
It seems to me that the column formatting should be defined in the Flex Report. Originally, I thought we could derived the formatting from the name/alias of the column (i.e. NbrStudents vs. PctStudents), but then I quickly realized that it would be awkward to specify decimal places or other formatting attributes.
For charts, the UI to add formatting to a Flex Report doesn't seem too bad. For tables, it's a different story because we don't know beforehand how many columns will be returned.