Print Page | Close Window

Connecing String to Number Fields

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19144
Printed Date: 20 Apr 2025 at 8:10am


Topic: Connecing String to Number Fields
Posted By: Chase
Subject: Connecing String to Number Fields
Date Posted: 19 Feb 2013 at 3:38am
In one of my databased, the field is stored as a text, in the other, as a number. I know I need to convert the text to number in a connection formula but am having difficulty with the syntax. Can anyone offer some help?


Replies:
Posted By: hilfy
Date Posted: 19 Feb 2013 at 4:40am
What type of database are you using?  Also, have you considered converting the number to text instead of the text to a number?
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: Chase
Date Posted: 19 Feb 2013 at 4:58am

ODBC (RDO) is the most I know about the DB. Converting to text  would work for me, too. The problem is it seems I need to insert a command at the database expert, which is an SQL query. I don't really have a firm grasp on SQL.


Posted By: hilfy
Date Posted: 19 Feb 2013 at 7:12am
Is there someone in your organization who can help you with this?  You would need to write a single command that returns all of the data for the report.  No knowing what type of database you're connecting to, there's no one here who can help you with that part as the syntax is different between different databases.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window