Announcement

Collapse
No announcement yet.

Report Creator and Casting double to money

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Report Creator and Casting double to money

    In Navicat 11 I am designing a report. One of the columns I am using is a type double, but I cast it to money. select price::money from table_of_prices. While in the SQL editor, the results displayed are what I expect, but when I copy/past my query into the datapipeline piece of the design report, the price fields are not formatted as money. They are just strings. If the value is 10.00, it's shown as 10 in the report.

  • #2
    Got it. Just didn't expect to have to format an already formatted column.
    Left hand side of design view expand text (if it isn't already expanded) then choose DisplayFormat.

    Comment

    Working...
    X