Nilesh Gajjar - Business Central & NAV: June 2015

Saturday, June 27, 2015

Break Line in Mail Codeunit (Outlook Mail)

This summary is not available. Please click here to view the post.

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.

QR Code Print - Dynamics NAV

Hello Friends,

Recently I have developed the QR Code printing report in one of our domestic client.

I want to share code for QR Code printing.

QR Code Detail: QR codes (abbreviated from Quick Response code) are appearing in many different places today, and they are found to be quick and efficient when it comes to working with mobile phones and other devices which can read them. QR Code is a multipurpose instrument and it can hold all sorts of different types of valuable information like your company’s or your salesperson’s contact details, sales invoice information, promotional codes, location information, checksums, amounts, web links etc., which you can read using a QR code reader to automate some of the routine manual processes, like typing in things manually.

The QR code is a two-dimensional data-matrix which can be decoded very fast. The format is clearly defined and published as an ISO standard.