phone # display in report view in C#.NET

[judithSampathwa]

Hi there,

i have a question in C#.NET report viewer. i save the phone number in the database as [phone] . so if the use doesn't type in a phone number it will be saved as [() - ] which is show in side the squared brackets, without the squared brackets. in the report it sows as () - for the number that are not inserted. how can i avoid it and leave a blank over there??

please can someone help me!!!!!!!!!

thanks

[Momerath]

Don't insert the () and - in the database, they are formating, not part of the actual data. When you pull them from the database, apply formating to display. If the value is null (no number) then you don't display anything.

[judithSampathwa]

Don't insert the () and - in the database, they are formating, not part of the actual data. When you pull them from the database, apply formating to display. If the value is null (no number) then you don't display anything.

can you give more details please