Skip to main content

Remove comma from a String in Crystal Reports

I have a little problem regarding with following in Crystal Report

"Salary Sheet For "+ Monthname (month({PrintPaySlip;1.Salary_Date}))+ " "+ totext(TONumber({@FYear}))

Outout will be like follwos.

Salary Sheet For January 2,010

What i want is like follows (Without the comma)

Salary Sheet For January 2010

So the soultion would be like this.


"Salary Sheet For "+ Monthname (month({PrintPaySlip;1.Salary_Date}))+ " "+ totext(TONumber({@FYear}),0,"")


Thanks for looking a simple function.
but if you dont know....
it'll become Difficult....
Learn everything....
impossible but give a try...
Labels:

Comments

  1. ivyApril 1, 2012 at 12:33 AM

    Your idea coincides with mine.and I think it's better.

    ______________________________________________________________

    Rc Hobby|Rc Helicopter|Mini Rc Helicopter

    ReplyDelete

Post a Comment

Popular posts from this blog

Execute *.sql with .NET

Do you ever want to execute slq statements at once. I mean SQL Script file. Normally we are using like following commands to Execute Single SQL statement. SqlCommand cmd = new SqlCommand(sSQL, conn); cmd.ExecuteNonQuery(); cmd.Dispose(); but this way you can execute one command at a time. We cannot execute SQL script using above command. Normal SQL Script Like this. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__titleauth__au_id__0519C6AF]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[titleauthor] DROP CONSTRAINT FK__titleauth__au_id__0519C6AF GO CREATE TABLE [dbo].[authors] ( [au_id] [id] NOT NULL , [au_lname] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [au_fname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [phone] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [address] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [city] [varchar] (20) COLL...
4 comments
Read more

Expire Session When the Browser Close [Codeigniter]

I wanted user to log again to the site whenever they close the browser. i searched everywhere and i found the easiest way. application/config/config.php sess_expire_on_close = TRUE Easy Session Preferences You'll find the following Session related preferences in your file: Preference Default Options Description sess_cookie_name ci_session None The name you want the session cookie saved as. sess_expiration 7200 None The number of seconds you would like the session to last. The default value is 2 hours (7200 seconds). If you would like a non-expiring session set the value to zero: 0 sess_expire_on_close FALSE TRUE/FALSE (boolean) Whether to cause the session to expire automatically when the browser window is closed. sess_encrypt_cookie FALSE TRUE/FALSE (boolean) Whether to encrypt the session data. sess_use_database FALSE TRUE/FALSE (boolean) Whether to save the session data to a database. You must...
3 comments
Read more

Google Talk Secret Emoticons

Some of the basic emoticon like :) and :D works inside google talk and on typing will turn bold blue like: :) and :D . Some other notably useful emoticons are :( , :P , :O , : , :'( , :x , :-) , :-D , :-( , :-P , :-O , :- , :-x . However, if you use chat feature inside Gmail, there are few animated emoticons which aren't documented and hidden for normal users. One thing to keep in mind is that all emoticons are available for Gmail chat client but Google talk does not supports all of them. Google has beautifully added 'animated smileys' or 'emoticons' to the Gmail-integrated version of Google Talk. These emoticons begin by showing you what you typed, then rotate or morph into a more traditional smiley (Refresh this page to see what I mean). Most of them are black on white (like the text in chat), with a few splashes of color. If you hover mouse arrow over them, they again re-animate to create lovely effect. To use emoticons, you need to click the blue smiley-fac...
1 comment
Read more