Convert Number to Word in Crystal Report

How to write amount in word in crystal report. Today we are  discussing about to convert amount in word. i mean 12,082.00 in to "TWELVE THOUSAND EIGHTY-TWO ONLY" in Crystal report. if right(Totext({@total}),2)="00" then uppercase(ToWords({@total},0))+" "+"Only" else uppercase(ToWords({@total},0))+" AND  "+uppercase(ToWords(tonumber(right(Totext({@total}),2)),0))+" "+"Paisa  Only" ...

Read More

Create a Job in Sql Server

How to Create a job(Schedule) in Sql Server USE [msdb] GO BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1) BEGIN EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]' IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback END DECLARE...

Read More