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

Сonversation on different topics
Post Reply
luke
Posts: 19
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 8 times
Lech Kulikowski
Posts: 4576
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: 19
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 5 times
RitchText Database Veriable Replaement.mrt
(5.33 KiB) Downloaded 5 times
GENT.rtf
(44.36 KiB) Downloaded 4 times
luke
Posts: 19
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: 19
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 3 times
Lech Kulikowski
Posts: 4576
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: 19
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.
Post Reply