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

Dual Screen Script for Ubuntu

I have experienced problems when installing two monitors in Ubuntu. Following script will help you to solve this problem. I had problems when saving below values so I created a script and put it to the startup. #!/bin/sh xrandr --output VGA-0 --mode 1920x1080 --pos 1280x0 --rotate normal --output DVI-I-1 --off --output DVI-I-0 --mode 1280x1024 --pos 0x0 --rotate normal --output HDMI-0 --off
Post a Comment
Read more

MYSQL Compare data in different Databases

Following statement will compare values in two databases and gives you records that not matched. SELECT stage,live,path,scope_id FROM ( SELECT (CASE WHEN (S.value = L.value) THEN '' ELSE 'N/M' END) as matched, S.scope_id, S.path, S.value AS 'stage', L.value AS 'live' FROM cin_stage.core_config_data S INNER JOIN cin_live.core_config_data L ON S.path = L.path ) RES WHERE matched = 'N/M' ORDER BY scope_id
Post a Comment
Read more