Solved

conditional font size for crystal report field

Posted on 2008-10-27
8
2,717 Views
Last Modified: 2008-10-28
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
Comment
Question by:waltraud2000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 16

Expert Comment

by:wykabryan
ID: 22815412
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
 

Author Comment

by:waltraud2000
ID: 22815715
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
 
LVL 16

Expert Comment

by:wykabryan
ID: 22815732
No. there is not in 9, 10, 11, or 12(possible).. just to help you out with that..
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Expert Comment

by:jgbreeden
ID: 22818140
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 22819217
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
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 22819227
For the font use

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

mlmcc
0
 
LVL 16

Expert Comment

by:wykabryan
ID: 22820903
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
 

Author Comment

by:waltraud2000
ID: 22821901
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question