[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

conditional font size for crystal report field

Posted on 2008-10-27
8
Medium Priority
?
2,974 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
  • 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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 101

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 101

Accepted Solution

by:
mlmcc earned 1000 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

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…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

591 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