Replace values with complex one when using word template

(0) Share

Report

Posted on by Community Member Microsoft Employee

I use word template to create custom reports. But for some fields, I want to replace the value with other thing than what CRM supplies, for example for Yes/No values I want to replace T/F. is it possible ?

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Replace values with complex one when using word template

Hi babak,

If you solved the problem or received help from an answer, please mark it as verified to encourage the community to provide more and more a better support.

Thank you.

Francesco

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report
RE: Replace values with complex one when using word template

Hi babak,

CRM word template is built to work with only Plain text and Image control.

When I need to deal with boolean or double/decimal value I create a dedicated print attribute which I format as needed every time the related attribute change.

An example follows:

new_booleanattribute has a related new_booleanattributeprint

new_decimalattribute has a related new_decimalattributeprint

every time new_booleanattribute change, I write "Yes" into new_booleanattributeprint if true, and "No" if false

every time new_decimalattribute change, I write value.ToString(neededformat) into new_decimalattributeprint

This is the safest and fastest solution, without losing time searching for unsupported solutions.

Please let me know if you solve.

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com