Solved

Scientific Notation in SSRS Report

Posted on 2009-05-05
2
1,704 Views
Last Modified: 2012-05-06
Hi,
I have a table in a SSRS report and for some fields the value is being displayed in Scientific Notation ex 4E-05.  How can I format this field to show the decimal conversion of this field. .00004 instead?  I see alot of posts about converting decimal to scientific but not the opposite format.
Thanks
0
Comment
Question by:keicy01
2 Comments
 
LVL 21

Accepted Solution

by:
JestersGrind earned 250 total points
ID: 24305284
You can use CDec(Fields!YourColumn.Value).

Greg


0
 

Author Closing Comment

by:keicy01
ID: 31578023
Worked like a charm Greg, Thanks!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question