I am working on a report that is being created in Crystal but part of the information comes from our SQL server tables and the other part comes from a table created in dbase IV. The information from the dbase IV is braught into a SQL server table but everthing that is converted comes in as a nvarchar. Do to this anything that would orginally be a nuber is not changing to be used for adding totals together. I had a work around that was working for getting just the sum by itself but would not be recognized for bringing into the Crystal Report to be linked with the other two tables already used. (1 from SQL Server for amounts, and other converted from dbase IV for address information)
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formatting a nvarchar to use with Crystal Reports
- Thread starter timely
- Start date
Similar threads
- Locked
- Question