Format issue in Export to Excel in RDLC Reoprt

Hello Friends,

I have face some datatype issue in standard export to excel function on RDLC Report.

When we export the data in excel file than system has export some decimal field in text format

So user is doesn’t able to use some excel function like (SUM,MIN,MAX,etc)

See, the following snapshot.

When I have select the some decimal field in excel file than excel doesn’t show the sum of that field:

What is issue and what is the solution:

Issue: it is our programming error. We doesn't give the proper format for textbox in RDLC report.

Solution: Never use the format function for decimal field. Always give the proper format using format property of textbox

After update this small changes in report.

System has properly export the data in excel and I could able use the SUM function of excel

 Done.