Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Multi-line Input string Parameters Post Reply Post New Topic
<< Prev Page  of 3 Next >>
Author Message
statey603
Groupie
Groupie
Avatar

Joined: 14 Aug 2013
Online Status: Offline
Posts: 78
Quote statey603 Replybullet 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?

Thanks.

Edited by statey603 - 10 Jan 2018 at 10:20am
-bill
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
statey603
Groupie
Groupie
Avatar

Joined: 14 Aug 2013
Online Status: Offline
Posts: 78
Quote statey603 Replybullet 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?

Thanks
-bill
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Jan 2018 at 3:25am
I am creating a formula field in crystal.
In that formula field is where you concatenate the values

"<p>Dear " + table.FirstName + ",</p>" + "<p>The following foods <b>Add foods here</b> are needed for dinner.</p>"

IP IP Logged
statey603
Groupie
Groupie
Avatar

Joined: 14 Aug 2013
Online Status: Offline
Posts: 78
Quote statey603 Replybullet Posted: 11 Jan 2018 at 3:26am
OK, I see what you mean now.

Thank you.
-bill
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Jan 2018 at 3:26am
I am not sure this idea will work for what you need but it was a work around I found that I was able to get value out of.
IP IP Logged
statey603
Groupie
Groupie
Avatar

Joined: 14 Aug 2013
Online Status: Offline
Posts: 78
Quote statey603 Replybullet Posted: 11 Jan 2018 at 3:29am
I will try to create a minimal report to test it out and see if it will work for us.

I really appreciate all of your assistance with this.

Thanks,
Bill
-bill
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
statey603
Groupie
Groupie
Avatar

Joined: 14 Aug 2013
Online Status: Offline
Posts: 78
Quote statey603 Replybullet 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 >

thanks


-bill
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Jan 2018 at 4:27am
Right click on the formula field
select Format Field
select Paragraph Tab
Change "Text Interpretation:" to HTML text
IP IP Logged
<< Prev Page  of 3 Next >>
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.015 seconds.