convert a number into words

can anyone help me how to convert a number into words using crystal report formula?
thanksuse Towords() function.|||hi.. vidubhushan, thanx for your reply|||Also you need to truncate the last xx/100 part if it exists

Conversion Tools

Are there any tools to convert Crystal Reports to SSRS out there besides KTL's Crystal Converter?

http://www.microsoft.com/sql/technologies/reporting/partners/crystal-migration.mspx|||

I went through that list and most of those are services. I am looking for tools like Crystal Converter.|||

To my understanding, Crystal (Business Objects) disapprove commercial converters. For this reason, most vendors offer this as a service.

|||

Thank you for your help.

Conversion from vb.net 1.0 to vb.net 2.0 (Crystal Reports Error)

i am facing the crystal reports error when i convert my project from vb.net 1.0 to 2.0. can any one tell me how i remove these errors

waiting ........

you havn't said what the errors are. AND this is not the forum for your question.

You will be waiting a long time.

sqlsql

Conversion from Crystal Report

Hi all,
I am in the process of converting some reports from Crystal Reports to
Reporting Services.
I want to examine the value of a field in the next row. Crystal reports
provides the following functions for that purpose NextIsNull(), NextValue().
Is any equivalent method in Reporting Services?
Thanks
SamUnfortunately, no. We provide a Previous() function but not Next().
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:udsDvkMYEHA.2672@.tk2msftngp13.phx.gbl...
> Hi all,
> I am in the process of converting some reports from Crystal Reports to
> Reporting Services.
> I want to examine the value of a field in the next row. Crystal reports
> provides the following functions for that purpose NextIsNull(),
> NextValue().
> Is any equivalent method in Reporting Services?
> Thanks
> Sam
>

Controlling Crystal Reports 9.0 Grids with VB

Hello,
I'm new to Crystal reports and am finishing up my first vb app. I need to be able to control the "Draw Custom Line" property of the Crystal Reports grid within VB 6.0. Does anyone know the Grid property I use in VB to control this?
Thanks so much!
Tricia =)aha! After a full day of searching for the answer, I think I found a comparable solution to this problem. =)

Solution: Split Dual Axis Grid
- Bottom axis range from x to alert level
- Upper axis range from alert level to x

Pros:
- The alert level line can be placed on the grid and it can be a variable amount calculated in VB so that we can normalize the data appropriately.

Cons:
- the grid must have 2 data points in order to have the split axis option available. The problem with this is that we need to show the marker for each point in the event of a first time sampling and only one level to show on the grid. I am using the alert level for the second data point and so the markers are showing only the alert level line, but it still looks a bit funky, but at least I have the line!!!

Control number of report copies within Crystal

Hi all,

I need some way to control the number of report copies within Crystal. For example, is there any way i can set a formular so that CR will produce two copies of the report with the first copy will have a text field "Office copy" and the second copy will have a text field "Factory Copy" ??

Thanks and CheersYes it is possible (by passing your text as a parameter, for example).
You didn't mention if you are running report from CR or from a custom application, but in either case, you will have to run the report twice.