SQL Server, SSRS and Crystal Reports

Showing posts with label Numbers. Show all posts

Tuesday, 20 October 2009

Format numbers in formula - CR

ToText({fldName}, 0)

0 indicates the number of decimal places

Posted by Dom Horton at 11:14 No comments:

Labels: CR, Format, Numbers, ToText

Older Posts Home

Subscribe to: Posts (Atom)

Salesforce DEV401

Salesforce ADM201

MBCS

Label Cloud

.NET Framework A3 A4 Access Rights Add Command After Update aggregate alter_table Alternate rows antivirus Array ASPNET Auxiliary AVG Bulk Insert Button Style Calendar table Carriage Return Cast Char CHAR(10) CHAR(13) CHAR(9) Character Codes Checkbox CHECKSUM CHECKSUM(NEWID()) Chr CHR(10) Colour Graduation Column alias Columns Common Table Expression comparison concatenates Condensing Conditional formatting Connectivity Continued convert Convert time to string Count CountDistinct CR CREATE TABLE Crystal Reports Crystal Reports Processing Engine CSS CTE current_timestamp CurrentDate CurrentDateTime data types Database name Dataset Datasetname Datasetname.commandtext. display a dataset query date Date and Time DateAdd DateDiff DateName Datepart Dates dateserial Datetime DBCC commands DBCC SQLPERF decimal Derived table Detailed or Overview report Diana Lite Disable display all Do DROP TABLE drop_table dropdown duplicate DY Else Embedded Images end of year Except financial year fiscal year FOR XML PATH Format Function GetDate Green bar Group Group Expert Group Header GroupNumber hexadecimal HtmlViewer.css If Iif IIS IIS7 Index Index usage INFORMATION_SCHEMA.COLUMNS InRepeatedGroupHeader Insert Install Installation Instr InteractiveHeight InteractiveSize Internet Information Services IsNothing isnull ISO 8601 Javascript Join lag Landscape Layout Left Len Length Limit Line Feed linebreak LinkScanner List of dates List of Value Limit Location Management Matrix MAXRECURSION metadata Missing Dates Missing Indexes Mod Modular Month MonthName Months Table Msg 409 multivalued NEWID() Nob Hill Software nth largest nth record Null Numbers Numbers Table Object_ID Outer Join Over page size Page x of y Pagination Parameter parameter label field Partition By Perfomance Portrait Preserve Printed by and time Processing Processing model Product Key query hint Query Tuning RAND() random RDL recordnumber recursion Redim remainder remove Repeat Group Header Replace Report Execution Reporting Services Configuration Reverse Row_Number rownumber RunningValue SAP Select All Select Case Self Join Service Pack Set Operation smalldatetime sp_executesql SP3 SQL SQL Commands SQL Server 2005 SQL Server 2005 System Views SQL Server 2008 R2 Sql Server Management Studio SQL Server Profiler SQL Server Reporting Services SQL Server Version SQL:BatchCompleted SSRS start of year Stored Procedures String String manipulation Stuff Subreport Switch sys.dm_db_index_usage_stats sys.dm_db_missing_index_details sys.dm_os_wait_stats sys.indexes System Views System Waits Tab TargetServerURL Templates Test Data Then Tick Time Time to String ToText Trigger Unicode Union uniqueidentifier uppercase URL URL command sections VBCRLF Version View Views Weekday While width Windows 7 Wingding WK XML Year

Blog Archive

▼ 2018 (2)
- ▼ June (1)
  - SQL - duplicate values
- ► May (1)

► 2017 (3)
- ► September (1)
- ► May (1)
- ► February (1)

► 2016 (2)
- ► October (1)
- ► June (1)

► 2015 (1)
- ► April (1)

► 2014 (1)
- ► May (1)

► 2013 (3)
- ► December (1)
- ► October (1)
- ► January (1)

► 2012 (4)
- ► November (1)
- ► September (2)
- ► August (1)

► 2011 (12)
- ► October (1)
- ► September (2)
- ► August (1)
- ► June (1)
- ► March (2)
- ► February (1)
- ► January (4)

► 2010 (36)
- ► November (6)
- ► September (4)
- ► August (2)
- ► July (4)
- ► June (4)
- ► May (5)
- ► April (3)
- ► March (4)
- ► February (1)
- ► January (3)

► 2009 (55)
- ► December (6)
- ► November (6)
- ► October (11)
- ► September (5)
- ► August (27)

Awesome Inc. theme. Powered by Blogger.