Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About
Reportviewer

How to split numeric and decimal parts in ReportViewer

- 27.07.21 - ErcanOPAK

‘Int’ Function returns the integer protion of a number.

For integer part:
=Int(3.14159)  -> This gives the number 3

or you can use with that value comes from DataSource
=Int(Fields!TheDataSourceField.Value)


For decimal part:
=3.14159 - Int(3.14159)  -> This gives a value close to 0.14159

or you can use with that value comes from DataSource
=Fields!TheDataSourceField.Value - Int(Fields!TheDataSourceField.Value)



 

Related posts:

How to change ReportViewer Date Format
How to format decimal number like "00.00" in ReportViewer
How to control "a checkBox is checked or not" in RDL reportview
How to make some specific word(s) Bold or Underline in ReportViewer
Rename Report while exporting to PDF or Excel in Microsoft ReportViewer
Post Views: 0

Post navigation

How to prevent to install a specific Windows 10 Update or Driver
How to display total sum of seconds in hh:mm:ss format in ReportViewer

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

August 2022
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Jul    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (362)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (234)
  • Find numbers with more than two decimal places in SQL (203)
  • Confirm before process with ASPxButton in Devexpress (199)
  • Add Constraint to SQL Table to ensure email contains @ (199)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (198)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (197)
  • How to make some specific word(s) Bold or Underline in ReportViewer (191)
  • Devexpress ASPxGridview Column Grouping in Code (183)
  • Tense Changes When Using Reported Speech (171)

Recent Posts

  • How to create the ShowBlanksValue and ShowNonBlanksValue items in Devex Grid
  • How to get ‘n’th row in Sql Query with OFFSET FETCH NEXT and ROW_NUMBER()
  • How to change the style of scrollbar with CSS
  • How to add scroll bar to div in Asp.Net
  • How to solve “Fatal: Not possible to fast-forward, aborting” problem
  • How to add Output Parameter to SqlDataSource
  • How to get stored procedure parameters details in SQL
  • How to add default value for Entity Framework migrations for DateTime and Bool
  • String Interpolation, String Format, String Concat and String Builder in C#
  • How to get triggers create and update date in SQL

Recent Posts

  • How to create the ShowBlanksValue and ShowNonBlanksValue items in Devex Grid
  • How to get ‘n’th row in Sql Query with OFFSET FETCH NEXT and ROW_NUMBER()
  • How to change the style of scrollbar with CSS
  • How to add scroll bar to div in Asp.Net
  • How to solve “Fatal: Not possible to fast-forward, aborting” problem

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (362)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (234)
  • Find numbers with more than two decimal places in SQL (203)
  • Confirm before process with ASPxButton in Devexpress (199)
  • Add Constraint to SQL Table to ensure email contains @ (199)

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

© 2022 ErcanOPAK.com

Proudly powered by WordPress | Theme: Xblog Plus by wpthemespace.com