troubleshooting Question

Navicat data field type help

Avatar of Gerhardpet
GerhardpetFlag for Canada asked on
DatabasesMicrosoft SQL Server 2008SQL
5 Comments1 Solution1431 ViewsLast Modified:
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?
table-data-type  
report-query-data-type
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros