Stored Procedure passed to Crystal is rounding decimal places

I have a stored procedure.  When I run it on SQL server I see all 5 decimal places.  However, when I bring the data from this stored procedure into my crystal report, the data is being rounded to 2 decimal places.  I have formatted the field on the report to show 4 decimal places, but all I see is the rounded number.  Any idea on how to see 4 decimal places on my report?
maverick0728Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
Do you also have the rounding set to 4 decimals?

mlmcc
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Are you using any kind of conditional formatting on the field?  There's an issue in Crystal Reports where the default number of decimals (typically 2) supercedes conditional formatting for the number of decimal places.  I ran into this when I was trying to conditionally show 4 decimals for some records and 2 for others.  I had to first set the default number of places to 4 then conditionally change the value based on my business rules.
0
 
mlmccCommented:
Rhinok also made that suggestion.  You should have accepted his comment as the answer
I can reopen the question so you can change the answer you acceted
p
mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.