hi,
I am working with vb.net and sql express. i have created a crystal report in my application. There is a field called InOut in my table,its Of Integer datatype. I would like to display the value of this field in string format.(eg:- if the value of field is 1,then i have to display it as "In" if it is 0, display it as "Out" in the crystal report.) what i have to do for this?can any one help me?
pls give me a step by step prcedure

thanks in advance..

__________________
sumith

you can extract the data out 1st, then compare.
Say for example, I'm using a label called "lblResult" to show whether it's "In", or "Out".

Dim data as integer = dataread("InOut")
if data = 0 then
  lblResult.Text = "Out"
elseif data = 1 then
  lblResult.Text = "In"
End if

to use the dataread, you need to declare it as a DataReader 1st. It can be declared by using this,
"dim dataread as SQLDataReader = sqlcommand.exucutereader"

Hope that this helps...

but i need to display the details in a crystal report. in crystal report,how to write the formula?? please help me.