Question Re: Truncation in Numeric Field in Technology Q&A

Truncation in Numeric Field

Former Member — Tue, 24 Feb 2009 18:01:14 GMT

Hi ,

I am using Crystal report 2008 and Visual Studio 2008(C#) .

In CR designer for number fields I am setting AllowFieldClipping to False(Un Checked) ,

It works fine in the Designer , but when I put the same report in CrystalReportViewer, the numeric feilds are Clipping .. i need to display this field as #####..

Can anyone help me to overcome this...

Thanks in Advance,

Salah.

Re: Truncation in Numeric Field

Former Member — Tue, 24 Feb 2009 18:39:55 GMT

Hi,

Try placing the fields which are getting clipped in Text object.

You can achieve that as follows:

Open the report in crystal report designer.

Right click in crystat report and add the Text object.

Now drag the numeric field in text objects .

check in designer whether report is working fine.

Then save the report.

Open the same report through your .Net application and crystal report viewer.

Hope this helps!!!

Thanks,

Prasad Kanchan

Re: Truncation in Numeric Field

Former Member — Tue, 24 Feb 2009 19:03:25 GMT

Hi Prasad,

Thanks for your Reply....

But i dont want to clipping that field.. it is happening already in CrystalReportViewer,even if the 'Allow Field Clipping' is unchecked.. i want to truncate that field value as ####..That is not happening in the .net application.

Thanks..

Salah

Re: Truncation in Numeric Field

Former Member — Wed, 25 Feb 2009 19:29:26 GMT

Give it a try by enabling the Can Grow property from the designer, and view the report from the .net app.

Re: Truncation in Numeric Field

Former Member — Fri, 27 Feb 2009 06:27:18 GMT

Thanks For your reply,

But i am getting same result in both cases(Enabled and disabled). The field is not truncating. i am not thinking its a Crystal Report issue.. Becouse Truncation is working properly in CR Designer as well as all the other DHTL viewers....

Salah..

Edited by: salahudheen muhammed on Mar 6, 2009 11:20 AM

Re: Truncation in Numeric Field

Former Member — Mon, 09 Mar 2009 21:50:14 GMT

See this thread:

Ludek