Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Reduce decimal places in Data Set for Report Builder

  Asked By: Bhavani    Date: Mar 24    Category: Sharepoint    Views: 1363

I am using SQL Server Business Intelligence Development Studio to build some reports. I have a data set which is connected to a SharePoint list and one of the columns contains a percentage value. In SharePoint the value is 50% but when I retrieve the data in report builder it is 0.50000000000....

How can I reduce the decimal places or remove them completely? So that I can use the data for a graph.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Aditiya Kapale     Answered On: Mar 24

Here is the expression

=Cdbl(Fields!ows_Per.Value)*100

to get back 50%  on the reporting builder  chart/table

 
Didn't find what you were looking for? Find more on Reduce decimal places in Data Set for Report Builder Or get search suggestion and latest updates.

Related Topics:



Tagged:              

 
 
 
 

Related Post