Numeric field appearing with comma in report even after custom formatting RSS

• • Reply
  

  rpk2006

  Member

  631 Points

  631 Posts

  Numeric field appearing with comma in report even after custom formatting

  Jan 12, 2012 10:55 AM|LINK

  My report is connected to a stored procedure. In Field Explorer there is an integer column which is not insert on the report but it is used as a query string parameter when a hyperlinked field is clicked on the report.

  This integer field, RecNo, is coming to Field Explorer in the format: #,###. I don't want to use comma and want to use a number like: ####.

  How to truncate comma?

• • Reply
  

  ssjGanesh

  Participant

  1970 Points

  1395 Posts

  Re: Numeric field appearing with comma in report even after custom formatting

  Jan 12, 2012 12:21 PM|LINK

  After u got like, 

  #,### 

  U just split them by ,(Delimiter) then it stored like,

  arr[0]=#;

  arr[1]=###;

  Then u can concatenate like, arr[0]+arr[1] 

  it produce #####

  Be what u want to be...Do wat u want to do...
  
  Mark as answer,if it helped U!
• • Reply
  

  rpk2006

  Member

  631 Points

  631 Posts

  Re: Numeric field appearing with comma in report even after custom formatting

  Jan 13, 2012 03:31 AM|LINK

  Is there any truncate option to replace comma with blank and than Trim the text?

• • Reply
  

  ssjGanesh

  Participant

  1970 Points

  1395 Posts

  Re: Numeric field appearing with comma in report even after custom formatting

  Jan 13, 2012 05:01 AM|LINK

  As of my knowledge split() is a best way coz in future if u have the same problem with any other special characters like,

  ,,!,@,#,$,%,^.,<, u can use the same function to remove it,

  Here is the Table valued function  i have used.

  <div>

  USE [dbWeServe]
  GO
  
  /****** Object: UserDefinedFunction [dbo].[FN_splitID] Script Date: 01/12/2012 21:57:47 ******/
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  -- =============================================
  -- Author: Ganesh.S
  -- Create date: 31st Dec.,
  -- Description: For spliting the memberId and insert into tblAttendance 
  -- =============================================
  
  -- select * from FN_splitID('3,5,8',',')

  
  CREATE FUNCTION [dbo].[FN_splitID](@NonSplited nvarchar(MAX) , @Delimiter char(1))
  
  RETURNS @temptable TABLE (ReferenceId1 nvarchar(50) not null ) 
  AS
  BEGIN
  	 
  
   declare @idx int 
   declare @Splited varchar(8000) 
        
   select @idx = 1 
   if len(@NonSplited)<1 or @NonSplited is null return 
        
   while @idx!= 0 
   begin 
   set @idx = charindex(@Delimiter,@NonSplited) 
   if @idx!=0 
   set @Splited= left(@NonSplited,@idx - 1) 
   else 
   set @Splited = @NonSplited 
            
   if(len(@Splited)>0) 
   insert into @temptable(ReferenceId1) values(@Splited) 
    
   set @NonSplited = right(@NonSplited,len(@NonSplited) - @idx) 
   if len(@NonSplited) = 0 break 
   end
  
   RETURN 
  
  END
  
  GO
  
  
  

  </div>
  Be what u want to be...Do wat u want to do...
  
  Mark as answer,if it helped U!
  • Marked as answer by Ming Xu - MSFT on Jan 31, 2012 03:03 PM