Million Seperator

Dear Sir,

I am Facing Problem with The number Format. Instaed of Thosand Separator I want Million Separator..

For Eg: in Crsyal Report The Number will Display Like this 5,633,000.00. Instaed of This format I want this Number to be display Like 56,33,000.00. How i can Do that,,

Thanks in Advance

AmbilyUse Formula field having this code

stringvar Amount:="453453455.00";
stringvar s:=mid(Amount,1,len(Amount)-3);
select len(s)
case 3 : s & ".00"
case 4 : left(s,1) & "," & right(s,3)& ".00"
case 5 : left(s,2) & "," & right(s,3)& ".00"
case 6 : left(s,1) & "," & mid(s,2,2) & "," & right(s,3)& ".00"
case 7 : left(s,2) & "," & mid(s,2,2) & "," & right(s,3)& ".00"
case 8 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& ".00"
case 9 : left(s,2) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& ".00"
case 10 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
default : s & ".00"

Madhivanan|||may i ask how to modify your script to get thousands separator?. i have case statement in my formula for differernt format. Don't want the .xx if they are both zeros.|||Hi 9e9+
Can you post the number and exepeted formated number?

Madhivanan|||Hi Madhi,

Thank you For your Fast Reply...

But i am Not Able to get the format..even though i analysed the function...but it is displaying The same format ,which crytsal report is giving.
Can u plz suggest any Other Function..|||Can you post the code you used?

Madhivanan|||Function (Currencyvar v1)
stringvar s:=mid(Totext(V1),2,len(Totext(V1))-4);
//stringvar str[100]=split(s,",");
//stringVar array str:=split(s,",");


//stringvar s=join(s2,",")

stringvar X:=mid(Totext(V1),Len(Totext(V1))-2,Len(Totext(V1)));
select len(S)
case 3 : s & X
case 4 : left(s,1) & "," & right(s,3)& X
case 5 : left(s,2) & "," & right(s,3)& X
case 6 : left(s,1) & "," & mid(s,2,2) & "," & right(s,3)&X
case 7 : left(s,2) & "," & mid(s,3,2) & "," & right(s,3)& X
case 8 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& X
case 9 : left(s,2) & "," & mid(s,3,2) & "," & mid(s,5,2) & "," & right(s,3)& X
case 10 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & mid(s,6,2) & "," & right(s,3)& X
default : s & ".00" ;

This is the code i used. I rewrote the code bcecoz, By default The crystal report is taking $ symbol also with the Number format.
Now i am struggling becoz it will take the Thousand Seperator (,) also. So while taking leng\th , it will count The & symbol and Thousand seperator.
I dont want those...
So i am trying to Split the Number into array (,) and Join again with out Commas.
Can you help me.
I cant change the Reprt options again..coz already 150+ reports addaed..Now for all reports i hav to Update this Format..
or pls suggest me, any short cut method is available ...
Thanks
Ambily|||Hi Mr Madhi,

Thanks a Lot for ur Support.. The problem was Simple...But It troubled a Lot
I wrote A functon with ur code

Function (Currencyvar v1)
Numbervar A:=(Tonumber(V1));
stringvar s:=Totext(A);
stringvar X:=mid(Totext(V1),Len(Totext(V1))-2,Len(Totext(V1)));
select len(s)
case 3 : s & X
case 4 : left(s,1) & "," & right(s,3)& X
case 5 : left(s,2) & "," & right(s,3)& X
case 6 : left(s,1) & "," & mid(s,2,2) & "," & right(s,3)&X
case 7 : left(s,2) & "," & mid(s,3,2) & "," & right(s,3)& X
case 8 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & right(s,3)& X
case 9 : left(s,2) & "," & mid(s,3,2) & "," & mid(s,4,2) & "," & right(s,3)& X
case 10 : left(s,1) & "," & mid(s,2,2) & "," & mid(s,4,2) & "," & mid(s,6,2) & "," & right(s,3)& X
default : s & ".00" ;

Now i am getting The currency format , which i need

Once again Thanks!!!

Ambily

Migration VFP to MS SQL Server 2000

Dear Friends,
I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to
share the experience with you, if you have undergone such a task. Is
there any utility for achieving
this.
Any white paper or link for guidance on the same.
I wannted to migrate the whole database to MS SQL Server 2000. I wanted
to migrate the table
structures and procedures to MS SQL Server 2000.
Please shed some light please.
Regards
Kumar
--
Posted via http://dbforums.comFoxPro 7 includes an Upsizing Wizard that will move your schema and data
into SQLServer. I believe this wizard was also in 5.
However, I suggest you take the opportunity to redesign your database in SQL
rather than just rely on the Wizard. Your database will probably need design
changes to take best advantage of the SQL platform. When you have designed
your SQL schema you can use SQLServer DTS to help transform the data from
FoxPro to SQL.
Your code will certainly need re-writing. The syntax and behaviour of SQL
statements in FoxPro (SELECT, INSERT, UPDATE, DELETE) are quite different to
Transact-SQL. I don?t know of any tools to help with this process.
--
David Portas
--
Please reply only to the newsgroup
--|||In news:3561073.1068013648@.dbforums.com,
sgnerd <member23530@.dbforums.com> posted:
> Dear Friends,
> I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to share the experience with you, if you have
undergone such a task. Is there any utility for achieving this. Any white
paper or link for guidance on the same.
> I wannted to migrate the whole database to MS SQL Server 2000. I wanted to
migrate the table structures and procedures to MS SQL Server 2000.
Hi Kumar,
If you have Visual FoxPro available there's an Upsizing Wizard that will do
what you want. For more information try
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgUpsizing_Visual_FoxPro_Databases.asp .
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@.mvps.org, www.cindywinegarden.com

Migration from VFP to MS SQL Server 2000

Dear Friends,

I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to

share the experience with you, if you have undergone such a task. Is
there any utility for achieving

this.

Any white paper or link for guidance on the same.

I wannted to migrate the whole database to MS SQL Server 2000. I
wanted to migrate the table

structures and procedures to MS SQL Server 2000.

Please shed some light please.

Regards
KumarReplied in microsoft.public.sqlserver.server

Please don't multi-post.

--
David Portas
----
Please reply only to the newsgroup
--

Migration

Dear Experts
Can any one please help me in MIGRATION of table from Foxpro 2.5 and MSVisualFoxpro 6 to MSSqlServer 2000
I had a large no of table in foxpro now i want all of them in SQL SERVER 2000
Thanks and RegardsThere really isn't a lot to the process. I don't believe that FoxPro 2.5 supported project files, so you'll probably have to treat each DBF file as a separate entity. You can use the DTS import wizard to haul the raw data into SQL Server tables, then you'll want to review the FoxPro indicies to determine which ones make sense for your application.

-PatP|||Thank u so much Pat Phelan, well i will start by doing the way you said

Thanks