Report Builder was unable to paste successfully RDLC/SSRS Reports

Hi All,

Report Builder was unable to paste successfully:

Many of you will be aware of above error while copying a text box or any Report Item for that matter.


This issue has been there for a quite a long time now. This issue comes when there is a Custom Code in your expression.


There is no direct method to copy an item as of now, but below are few methods to copy the text box by work around.

1) Using Apostrophe before expression so that it will be considered as a comment. After copying you need to remove the Apostrophe.

Or

Using Double Quote at start and end of expression so that it can be treated as String. After copying you need to remove the Double Quote.




2) Adding a blank text box, then select the expression. Copy & paste the expression to new text box.






Thanks & Regards,
Nandesh Gowda

Unicode Field Caption on Pages/Reports MS Dynamics NAV

Hi All, 

Microsoft Dynamics supports Unicode data from NAV 2013 on wards. so we can store Unicode data in database. So obviously we can print the same in reports.

But what about Unicode Field Caption on Pages, Reports, etc.

One of the option is by export and import of objects from object designer 

1) Export the object to text file from Object Designer--> Tools--> Translate--> Export

For ex : Below are the few rows of exported  payment terms table.
T3-P2818-L30:Payment Terms
T3-P8629-A1033-L999:Payment Terms
T3-P4960-V1000-P2818-L128:PaymentTermsTranslation
T3-F1-P2818-L128:Code
T3-F1-P8629-A1033-L999:Code
T3-F2-P2818-L128:Due Date Calculation


2) Then open the exported text file and add a new row for the field you want to translate to the needed language.

For ex : To translate Code field caption of Payment Terms Table to Khmer (Cambodian Language) we need to add below row

T3-F1-P8629-A1107-L999:លេខកូដ

Where Language Code : A1107 (Khmer)
Translated String :លេខកូដ

T3-P2818-L30:Payment Terms
T3-P8629-A1033-L999:Payment Terms
T3-P4960-V1000-P2818-L128:PaymentTermsTranslation
T3-F1-P2818-L128:Code
T3-F1-P8629-A1033-L999:Code
T3-F1-P8629-A1107-L999:លេខកូដ
T3-F2-P2818-L128:Due Date Calculation


3) Save the Text file in UTF-8 Format. You cannot import directly this file as it is in UTF-8 format.If the file doesn't contain any unicode data then we could have imported it directly from Object Designer--> Tools--> Translate--> Import.


4) Instead we add these file in Translations folder under NAV Service Folder Directory. If there are multiple instances then under the respective instance folder you add these translations.


5) Restart the service and open NAV client to see the changes.


Other option can be to store the translated caption strings in database itself in some tables. And then add the fields which stores translated string to reports directly.

Thanks & Regards, 
Nandesh Gowda

Display a check box in NAV RDLC Reports

Hi All,

There may be a requirement to print a check box ( Boolean field) in reports.

There are few ways to achieve the same

• Using Images and controlling the visibility property based on condition.
• Using Indicators to a Boolean field 
• Using Wingding fonts

I will discuss the last 2 options here

• Using Indicators to a Boolean field : Select Indicator Control from Tool Box.

Then add the expression Boolean field ( return value 0 and 1)for Indicator by going to Indicator     Properties and give the relevant Indicator states as shown below

Finally save and run the report

• Using Wingdings2 font : Add the expression as shown in the figure and change the font to Wingdings2.

Finally save and run the report

Thanks & Regards,
Nandesh Gowda