• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

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?
0
maverick0728
Asked:
maverick0728
  • 2
1 Solution
 
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:
Do you also have the rounding set to 4 decimals?

mlmcc
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now