[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1912
  • Last Modified:

Scientific Notation in SSRS Report

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
keicy01
Asked:
keicy01
1 Solution
 
JestersGrindCommented:
You can use CDec(Fields!YourColumn.Value).

Greg


0
 
keicy01Author Commented:
Worked like a charm Greg, Thanks!
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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