crystal report format text "vb.net"

[Georg]

Hi,
I'am using "Visual Basic 2005" and Ado.net .Iin a crystal report i want to
format a texfield as followed ###-#######-## and other string functions ,
but no succees.
Before I used Msaccess and i put an inputmask on the field in the table
directly. The field is showed properly in the forms and reports. Now , i
will convert this application into ado.net but i see only text without the
mask.
can i achieve this in a crystal report ?

kindly regards, Georg

 

[Cor Ligthert[MVP]]

Georg,

Although that help with crystal reports is mostly almost impossible.

What do you mean with convert this application into ado.net.

Ado net is not a program language or program generator or whatever.

Cor

 

[Mr. Arnold]

Hi,
I'am using "Visual Basic 2005" and Ado.net .Iin a crystal report i want to
format a texfield as followed ###-#######-## and other string functions ,
but no succees.

The field on the report band you should be able to right-click the field and
go to the format menu and format the field's data.

If you cannot do that, then you should be able to take Formula using string
functions on the field to format its data.

Before I used Msaccess and i put an inputmask on the field in the table
directly. The field is showed properly in the forms and reports. Now , i
will convert this application into ado.net but i see only text without
the mask.
can i achieve this in a crystal report ?

You also can bind a Crystal Report to a SQL Server Stored procedure. And by
using string manipulation in the Stored Procedure, format the field into the
format you want, output the field in the result set and bind the result set
with the formatted data to the report.