How to write a formula to change a font based upon data ?

Answers were Sorted based on User's Feedback



How to write a formula to change a font based upon data ?..

Answer / mlmcc

Select the field
Click FORMAT
Click FORMAT FIELD
Select the FONT tab
Click the FORMULA BUTTON to the right of FONT
if ({YourField} = Value) then
"Arial"
else
"Times New Roman"

Click SAVE Icon
Close the formula editor
Click OK on the FORMAT screen

Is This Answer Correct ?    21 Yes 9 No

How to write a formula to change a font based upon data ?..

Answer / parvathi

hi.........
its really good.
thanks for this code.
i resolved my bug depends on this...

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Crystal Reports Interview Questions

Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explain how is that possible ? Thanks in advance for the people posting the answers

3 Answers   Wipro,


What are the sections that we have in Crystal reports?

11 Answers  


How to Filter the Crystal reports?

12 Answers   CCIL, Mammut Building Systems,


When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From

3 Answers  


How can i normalize a Crystal Report..??

0 Answers   HCL,






I had an Interview yesterday for a Crystal Reports Developer position. Some of these I have not done in my reporting experience and I had just a half day's notice for the interview, hence no prep time :-( 1) Is there a way to be able to change an image(company logo) dynamically in a report? Example if you have 100 reports, and with the market uncertainity if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all teh reports at run time? 2) What is a SQL expression? 3) What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions) The interviewer really got me confused as I felt he was not clearly setting forth his questions but it could be that I was unable to understand his wording of the questions. I expect a big zero from his feedback but I am hoping this is an experience for future interviews that I face in crystal reports when I do get some more lined up. Thanks in advance! Anita New Jersey, USA.

5 Answers   Barclays,


How to add Crystal Reports(Standalone) to my VB.NET project

2 Answers  


Explain basic steps required to display a simple report in crystal?

0 Answers  


Can we add any database field once we have chosen ?Close? button?

2 Answers  


Is it possible to export crystal report with linked subreports in one excel sheet?If yes,then how?

4 Answers   IBM,


Suppose I have a crystal report with a linked subreport as well. Is there any way not to print the current record on the main report if no records are returned from the subreport?

0 Answers  


How many sub-reports can report can have?

4 Answers   IBM,


Categories