I have a CMS designer report and one of the fields is formatted as a number with 2 decimal places, ex. 12.34. However the summary line does not match this format. The summary always displays it a a whole number with no decimals, 12 as an example. Does anyone know why CMS does this or is it by design?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CMS Designer Report Summary Line Format
- Thread starter caper1175
- Start date
1) if the report was built in screenpainter through the terminal emulator (in cms custom folder), the fields can be set up differently. You would need to view the actual field and modify if necessary.
2) if it was built in Report designer (in designer reports folder) it normally follows the format of the data query. Sometimes when changes are made to the queries after the fact the formatting gets a bit messed up... don't know why. Try removing the table, saving the report, and then re-adding it and that might fix it up. That usually works for me.
2) if it was built in Report designer (in designer reports folder) it normally follows the format of the data query. Sometimes when changes are made to the queries after the fact the formatting gets a bit messed up... don't know why. Try removing the table, saving the report, and then re-adding it and that might fix it up. That usually works for me.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
