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

Сonversation on different topics
Post Reply
luke
Posts: 42
Joined: Fri Jun 03, 2022 6:57 am

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

Post by 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 :geek:
Attachments
RitchTextProblem.zip
(9.26 KiB) Downloaded 85 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

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

Post by 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
Posts: 42
Joined: Fri Jun 03, 2022 6:57 am

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

Post by 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}
Attachments
RitchText Database Veriable ReplaementDB.xlsx
(10.75 KiB) Downloaded 82 times
RitchText Database Veriable Replaement.mrt
(5.33 KiB) Downloaded 78 times
GENT.rtf
(44.36 KiB) Downloaded 304 times
luke
Posts: 42
Joined: Fri Jun 03, 2022 6:57 am

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

Post by 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
Posts: 42
Joined: Fri Jun 03, 2022 6:57 am

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

Post by luke »

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

Here is a BAK database file for you to restore on Microsoft SQL as the backend for the report :)
Attachments
HTML-OUTPUT-EXAMPLE-DB-20220623141002-(7ad476ce-9879-4502-a929-e59d527597b8)-Full.zip
(425.87 KiB) Downloaded 71 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski »

Hello,

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

Thank you.
luke
Posts: 42
Joined: Fri Jun 03, 2022 6:57 am

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

Post by luke »

Thank you for all the effort.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

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

Post by 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.
Attachments
rtf v2.mrt
(9.52 KiB) Downloaded 84 times
luke
Posts: 42
Joined: Fri Jun 03, 2022 6:57 am

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

Post by luke »

Thank you for the feed back ,I will look at it now.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski »

Hello,

You are welcome.
Post Reply