Solved

Scientific Notation in SSRS Report

Posted on 2009-05-05
2
1,649 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
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…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now