• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3074
  • Last Modified:

conditional font size for crystal report field

in the formula workshop of Crystal version 9, I am trying to make strings above a certain length a smaller size and different font, something like below, which is obviously wrong.

if ({myfield.ClientName}.length > 40) then
font.size=9
font.style = arialnarrow
end if

Can this be done, and if so, what is the syntax?
0
waltraud2000
Asked:
waltraud2000
  • 3
  • 2
  • 2
  • +1
1 Solution
 
wykabryanCommented:
No within 9 it can not be done.  What you could do though is create another section below it and conditionally suppress one or the other if the lenght> 40.
0
 
waltraud2000Author Commented:
In this case it is a crosstab, and client will not accept all entries in this field being in a small font. She was willing to accept just one unusually long entry in that small font. My above attempt was supposed to be a workaround for not being able to grow the field in a crosstab.

So I guess there is no way to conditionally change one entry's format within a crosstab in version 9?
0
 
wykabryanCommented:
No. there is not in 9, 10, 11, or 12(possible).. just to help you out with that..
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
jgbreedenCommented:
In 8.5, when I right-click on a field in the report, I can go to Format Field, click on the Font tab, and click the formula button next to font size, name, color or whatever.  If you go into the formula for size, you just need to return the numeric for the size you want, i.e. if (length({ClientName}) > 40 then 9 else 12.  Same thing with the font name, just return a string that matches a font name.
0
 
mlmccCommented:
That does work in a crosstab.

Right click the cross tab field
Click FORMAT FIELD
Click the FONT TAB
Click the formula button bext to SIZE
If Length(CurrentFieldValue) > 40 then
8
else
10

Similarly for the font

mlmcc
0
 
mlmccCommented:
For the font use

If Length(CurrentFieldValue) > 40 then
   "Arial Narrow"
else
   "Arial"

mlmcc
0
 
wykabryanCommented:
Right Cross tab will allow font changes. jgbreeden in the later version there isnt a place for formulas next to the format text font area. (X+2)
0
 
waltraud2000Author Commented:
Was coming back to say I'd found the solution here, and others beat me to it:

http://www.experts-exchange.com/Database/Reporting_/Business_Objects/Q_22428311.html?sfQueryTermInfo=1+condit+crystal+format+report

Thanks everyone!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now