I'm new to Navicat. I'm importing data from an ODBC connection from a Pervasive SQL database to a MS SQL Express 2008 R2 database.
When the import is done I modify the data fields to the type I want. I have a few fields with sales totals which in the table I have them set as "money" type fields.
When I use them in the report the same fields show as "string" type. I have attached screen shoots for samples. What I want in the report is have $ symbols for the number fields and I can't do that right now. I suppose it is becuase the field types are seen as strings.
Can someone help me with this?