Ritch-Text from a SQL database Field into Data Band containing a value

[luke]

when I bring Ritch-Text from a SQL database Field into my Data Band containing a value , It Shows the text in the field but doesn't Swap the variable attached in that text.

If you Add a Ritch-text in the field as an expression it then displays , I need it to do the same ,but as a SQL field value.

Iv attached a file for analyses

[Lech Kulikowski]

Hello Luke,

In your example, the database contains not rtf, but plain text.
For plain text and for rtf the code will be different, could you provide a more specific example with rtf?

Thank you.

[luke]

I have attached excel DB without the RTF Text i want to disply ,instead iv provided the RTF file that i need to be stored in excel "SQL DB" Please Replace {ClientName}

[luke]

I need to Store the RTF Text in a SQL field ,This text will Contain Values like {ClientName} that is in the text of the rtf ,I need StimulSoft to resolve the rtf as text as well as the variables within.

I really hope this helps , i am not sure how to store the RTF in an Excel field ,i think excel auto converts it to text making it difficult to demonstrate.
RAW RTF :

{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang7177\deflangfe7177{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}}
{\colortbl ;\red251\green178\blue74;}
{\stylesheet{ Normal;}{\s1 heading 1;}}
{\*\generator Riched20 10.0.17763}{\*\mmathPr\mdispDef1\mwrapIndent1440 }\viewkind4\uc1
\pard\keep\keepn\widctlpar\s1\sl360\slmult1\qj\tx851\tx1701\tx2552\tqr\tx8505\cf1\b\f0\fs40 GENERAL TERMS AND CONDITIONS \par

\pard\widctlpar\sl360\slmult1\qj\tx851\tx1701\tx2552\tqr\tx8505\cf0\b0\fs24\par

\pard\keep\keepn\widctlpar\fi-567\li567\sa320\sl360\slmult1\qj\fs22 1.\tab\ul\b SPECIAL ENDORSEMENTS\par

\par

\pard\keep\keepn\widctlpar\fi-567\li567\sa320\sl360\slmult1\qj\fs22 12.\tab\ul\b ACCEPTANCE\par

\pard\widctlpar\sl360\slmult1\qj\tx851\tx1701\tx2552\tqr\tx8505\ulnone\b0\fs24\par
By signing below, it has carefully read and fully un signed by each party's manuscript signature.\par
\par
Accepted for and on behalf of the Client:\par
\par
Name of Client:\tab\{9CLIENTNAME\}\par
\par
\par
\par
Signed At __________________________________ this ________day of ____________________20______\par
\par
\par
\par
\par
Signed By\tab ___________________________________\tab Signature ____________________________________\par
\tab\tab Authorized Signatory for and on behalf of the Client \tab\par
\par
\par
Accepted for and on behalf of (Pty) Ltd.\par
}

[luke]

I could provide a demo database instead of excel if that helps, because i know excel auto converts the raw into text.

Here is a BAK database file for you to restore on Microsoft SQL as the backend for the report

[Lech Kulikowski]

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.

[luke]

Thank you for all the effort.

[Lech Kulikowski]

Hello,

The RichText component editor allows you to edit text, but it also inserts various control commands, such as text encoding switching.
So if you want to insert an expression into RichText, you should first type it in a plain text editor, such as Notepad++, and then paste it in RichText.
In this case, if the expression contains only English text, everything will go fine.
But if it contains different national characters, the editor will insert its control codes right into the expression, and most likely the report will stop compiling at all.

Thank you.

[luke]

Thank you for the feed back ,I will look at it now.

[Lech Kulikowski]

Hello,

You are welcome.