crash58
Technical User
- Oct 6, 2002
- 6
I am working on a report (v 8.5, SQL DB) that involves bibliographic citations in a subreport. The citation formula is comprised of multiple individual formulas, and thanks to lots of posts here, I found out how to format the text of those using html tags and turning on the paragraph text interpretation.
The formula is also the basis of the detail section, and the details are concatenated per article 2008325 in the knowledge base. Everything worked beautifully with my test object, except that once I turned on the html text interpretation, the font size jumped up a few points. I could not change it at the format subreport or format object level, and tried to change it using html tags within the main formula, and then got the error "A string can be at most 254 characters in length". The concatenated string is more than 254, that's the point, and unless the font size format code is in the formula, a 254+ string shows up just fine. I tested a shorter string result with the font size command, and the font changed as expected. I'm thinking the source of my problem is within the steps to concatenate the detail fields, and I'm out of ideas at this point on what to change. Any help out there would be most appreciated!
The formula is also the basis of the detail section, and the details are concatenated per article 2008325 in the knowledge base. Everything worked beautifully with my test object, except that once I turned on the html text interpretation, the font size jumped up a few points. I could not change it at the format subreport or format object level, and tried to change it using html tags within the main formula, and then got the error "A string can be at most 254 characters in length". The concatenated string is more than 254, that's the point, and unless the font size format code is in the formula, a 254+ string shows up just fine. I tested a shorter string result with the font size command, and the font changed as expected. I'm thinking the source of my problem is within the steps to concatenate the detail fields, and I'm out of ideas at this point on what to change. Any help out there would be most appreciated!