Joined: 14 Aug 2013
Online Status: Offline
Posts: 78
Posted: 10 Jan 2018 at 9:48am
DBlank,
I am not sure I am following you. I added a large textbox to a report with html tags and a prompt indicating this is where the text should be entered.
I exported to RTF but when I eidit the RTF, I still am seeing the same section size restrictions as before. I guess I am not understanding the HTML piece of it. Are you defining the text object as HTML or just putting an HTML prompt in it?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 11 Jan 2018 at 3:09am
I am concatenated the entire "letter" into one formula field and I am using HTML tags in that as the way to format that one field for the entirety of the way I wanted the letter to 'display'. This way when the letter is exported as an rtf it is just one section with multiple paragraphs.
For values that are still needed to be added by a user I decided to use color and bold tags and an "insert specific value here" text to prompt the user to 'finish the exported letter' before printing it.
When you place that formula field in the report canvas set it to be displayed as text interpretation = HTML text
I would recommend a simple test before spending hours building a complex.
Like build the letter header and pull in a few data items and a few places to 'add content'.
Export that and try editing it.
Joined: 14 Aug 2013
Online Status: Offline
Posts: 78
Posted: 11 Jan 2018 at 3:15am
OK, a couple last questions. lol.
When you say you are concatenating the entire letter into your formula, how are you doing that?
Is the entire letter text being pasted into an input parameter?
or is there a way you are selecting all of the text of the crystal report from a formula?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 11 Jan 2018 at 3:30am
You can also make it so it creates multiple 'letters' at once for different 'customers' by grouping on a customer ID. If you need to roll multiple rows into one item you can do that via a shared variable and then make your ultimate output place on the group footer.
Joined: 14 Aug 2013
Online Status: Offline
Posts: 78
Posted: 11 Jan 2018 at 4:24am
I just tried a quick test.
How do you get the report to recognize/interpret the HTML ?
I created a new formula and pasted your sample HTML into it and just replaced your table.FirstName field with my DB client name.
The client name gets picked up but the HTML tags are showing in the report as shown below. NOTE: I added spaces in the HTML tags so this forum post would not interpret the HTML.
< p >Dear John,< /p >" + "< p >The following foods < b >Add foods here< /b > are needed for dinner.< /p >
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum