Advertisement

09.21.2007 at 04:18AM PDT, ID: 22843762
[x]
Attachment Details

Removing decimal places from a number SQL Server 2000

Asked by Kaporch in SQL Query Syntax, Crystal Reports Software, MS SQL Server

Tags: , , , ,

Is there a way to force a number to display without decimals in SQL Server 2000?  If not, a way in crystal reports to do the same?  I tried setting the decimal places to 0 in Crystal reports and I still see 2 decimal places. Start Free Trial
[+][-]09.21.2007 at 04:31AM PDT, ID: 19934627

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Query Syntax, Crystal Reports Software, MS SQL Server
Tags: sql, decimal, server, places, number
Sign Up Now!
Solution Provided By: Goodangel
Participating Experts: 3
Solution Grade: B
 
 
[+][-]09.21.2007 at 04:46AM PDT, ID: 19934732

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.21.2007 at 05:18AM PDT, ID: 19934889

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.21.2007 at 05:23AM PDT, ID: 19934913

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.21.2007 at 05:29AM PDT, ID: 19934950

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.21.2007 at 05:30AM PDT, ID: 19934953

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.21.2007 at 05:34AM PDT, ID: 19934973

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_1_20070628