|
ToText (Sum ({waste.id}))
Is this the right syntax to get the conversion from numeric to words in crystal reports ?
|
|
|
|
|
it doesnt convert into words.. just converts it into string format..
The name is Sandeep
|
|
|
|
|
Sir, Does the crystal Reports provide the facility for conversion of numeric into English words?
|
|
|
|
|
Thanks every body i got the answer.
|
|
|
|
|
dear preeti,
plz make ur question clear.. to what format do u want to change your number?? anyways, you must try the inbuilt functions provided in crystal report. create a new formula with those functions.
The name is Sandeep
|
|
|
|
|
Actually i want to Convert my Grand Total which is a rounding off in database by the datatype float . I want to write my grand total in words such as if the grand total comes 867.36 which is in the databse comes 867 I want the in words its should be written as eight hundred sixty seven not eight hundred sixty seven and thirty six paisa
If you want to knopw about me please email me on preetniki@gmail.com
|
|
|
|
|
hi Preeti,
Use following function to change Numeric Value to word in Crystal report
Towords(NumericVariable)
Hope this Helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
see...
giving an example
UpperCase("Rupees " +
ToWords (Sum (Value))
+ " AND PAISE " + ToWords(
Sum (Value) + " only")
dis might help you
Regards Pushpa
|
|
|
|
|
in the table i have four rows having the following data
1.1
2.1
3.3
4.7
the total come 11.00
after rounding
and in words the output is eleven and
is there any way to eliminate the string and
|
|
|
|
|
your output gives 11.2
and if you want to skip "And" then dont add "AND" string
UpperCase("Rupees " +
ToWords (Sum (Value))
+ " only")
|
|
|
|
|
No , Sorry i did not mean that. Actually the addition of four values are 11.3
when i round it off the result comes 11.0
then the conversion into English Words gives me eleven and output(may be due to .0).
I am not using the and string in the formula .
It is the output that is coming with and string.
I need to eliminate and string
-- modified at 8:11 Wednesday 23rd May, 2007
|
|
|
|
|
Hi friends..!
My Problem is regarding Setup of my application which i am
facing..is.. i want to check whether the product i am
installing has been previously installed or not? i am using
Install shield express edition for creating setup of mmy VB
appplication. I am acertaining this with help of following function which is an API function defined in MSI.dll:
"MsiQueryProductState(ProductCode)"
Now when the function return me that there's an instance of the application i am installing what i want is...I want to forcefullly return the Exitcode from currently opened form.
As i have learnt that .. it is the Exitcode which is responsible
for the installer to proceed further after getting an exitcode
'0' from the exe which it fires . I can get the install state of
my application with the above function i.e. Whether it's
already installed or not.. if it is already installed then i want the exe, which calls this function, to forcefully return an Exitcode '1' so
that after getting Exitcode '1' the Parent Setup shud get
terminated immediatley without going further.
Thanx n Regards
IPS
IPS
|
|
|
|
|
try Environment.Exit(exitCode)
topcoderjax - Remember, Google is your friend.
|
|
|
|
|
VB6 doesn't have an Environment class, so you have to call into the Win32 API to set the exit code your you VB6 app before it exists:
Private Declare Sub ExitProcess Lib "kernel32" (ByVal uExitCode As Long)
.
.
. ' Somewhere in your code, just before it exits, do this...
ExitProcess somenumber
But, as with everything, there's always a catch[^].
|
|
|
|
|
hi ,
can i do some coding work for exit code ? (Exitcode which tells the installer abt the suucessful completion of an Exe which the installer fires during its execution. Exitcode-1 shows that application hasn't cpmpleted successfully.. whereas Exitcode-0 shows successful completion of the application.. upon getting which the installer proceeds further! ) in the deployment project.
|
|
|
|
|
Assign the value to the Environment.ExitCode property.
---
single minded; short sighted; long gone;
|
|
|
|
|
Is it possible to to write the code line(Environment.ExitCode) in the deployment project(vb.net 2005).
Please provide an example.
|
|
|
|
|
Of course not. YOu need to add code to the command line application to return the code you want it to.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
Hi ,
I was trying to set the Yahoo.com as the start page using the following registry.
My Computer\HKEY_CURENT_USER\Software\Microsoft\Internet Explorer\Main\start page
It is done successfully.
Now my query is based on disabling the textbox , which is placed in the
Tools\Internet Options\Address.
I mean can i disable the address textbox by manipulating the regstry values.
|
|
|
|
|
I doubt it. You may be able to *hide* it, as that is an IE toolbar setting.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
No , I need to disable it.
Is there any way out?
|
|
|
|
|
You can only hide it as far as I know. What is a browser without browsing capabilities?
The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.
|
|
|
|
|
Hi ,
My question is based on the textbox in the internet option\Tools\address textbox not the address box in the window explorer.
is there any way out to disable that textbox which exist there in the internet option\Tools\address .
and one moe thing i wanted this thing to be done in the current user account .not in evry account.
Please Help .
|
|
|
|
|
This is normally done using Group Policy. Using GP's you can set the home page and disable the tab page it's on. No, you cannot disable JUST that textbox.
None of this requires any code to be written. Just an understanding of how Group Policy works. I suggest picking up the Windows XP or Windows Server 2003 Resource Kit.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
