CRYSTAL REPORT - Print on multiple lines property in Formula field

[ahathunder]

Hi Cystal Report Experts,

I want to print the formula field in multiple lines. Print on multiple lines property is ignored for formula field. please let me know the alternate way of doing this.

Thanks in advance

 

[CsaintAZ]

Ahathunder,

Could you provide a little detail on what you are trying to print on multiple lines? What is the formula? Where have you placed the formula in your report? By this I mean; In the page header? Group section? Detail section?

What files are you using in your report?

 

[ahathunder]

CsaintAZ,

Thanks for your reply. I will explain you my requirement in detail.

I want to pass a string from VB to crystal report, which will print on multiple lines in the detail section (This string is dynamic value which is get from VB form not from database). For that I am using one formula field which has no formula value, obsolutely empty. At the time of calling the crystal report I am replacing the text with formula by using the following command.

CystalReport.ReportFileName = strReportFileName
...
CrystalReport.Formulas(0) = "Comment='" & txtUserComment
& "'"
...
CrystalReport.Action = 1

Note:

Report Type: Custom Report
Formula Name: Comment

If information is not enogh please let me know, I will send you more detail.

Thanks in advance

 

[vionca]

What kind of output are you getting? Is it all appearing on one line and cutting off text that won't fit on the page?

If that is the case, try resizing the text box (that's where I'm assuming the formula output is written to). instead of using a text box like this:

---------------------------------------------------| |
---------------------------------------------------

use one like this

----------------------------------| |
| |
| |
| |
----------------------------------

vionca