How to format cell according to different data type

Hi,
I have a table cell which could accomodate date,currency,numeric at run
time,how do I set up individual format for each type? I don't know vb
so I'd appreciated for any help.
ThanksGetting the difference between curency and numeric is a challenge, for the
rest you can do a nested iif expression for the format property eg:
=iif(isdate( Fields!Yourfield.Value),"dd MMM
yyyy",isnumeric(Fields!Yourfield.Value),"N","C")
"ottawa111" wrote:
> Hi,
> I have a table cell which could accomodate date,currency,numeric at run
> time,how do I set up individual format for each type? I don't know vb
> so I'd appreciated for any help.
> Thanks
>|||Thanks a lot

How to format cell / data apprearecnce under a table

Hello All,

I uploaded custtable under the database, the data looks fine except that the name that apprears has a lot of distance e.g

it should be :

firstname lastname however the format appears very strange:

firstname lastname

firstname lastname

fistname lastname

Same is the case with the address, I need to adjust or format the apperance that appears on the cell. Is there a way/ sql statement to format the data under the table so that the apprearence looks okay.

I will really appreciate any sort of help on this one.

Thanks,

Rashi

Check the positioning properties of the grid/cell.

You could try trimming leading 'space' characters in the SELECT query, e.g., ltrim( FirstName ), ltrim( LastName ).