Solved

Crystal Reports formula for detail field value "1" to equal OK.

Posted on 2008-06-21
5
437 Views
Last Modified: 2013-11-26
I am using visual studio crystal reports.
A crystal reports detail field receives a value of "1" from a .net checkbox by default.
I need a sample formula for the detail field value "1" to convert to the value "OK".

If the .net checkbox is unchecked the detail field would show no value.

Thanks
0
Comment
Question by:dave_sky
  • 2
  • 2
5 Comments
 
LVL 13

Accepted Solution

by:
crgary_tx earned 250 total points
ID: 21837799
create a formula:
//@ok
if {table.field} = 1 then 'OK'
else
""

hth
Gary
0
 

Author Comment

by:dave_sky
ID: 21837965
Thanks for the response.

I used this formula:
if{tblSprinklerWorkorderDetail2.FunctionOK} = 1 then 'OK'
else
""
I get an error message - The result of selection formula must be a boolean.
0
 
LVL 8

Assisted Solution

by:RickJ
RickJ earned 250 total points
ID: 21839412
I think you have put the formula in a selection formula.
You need to create a formula field and drop it on the report.
In your field explorer right click on Formula Field and click "New"
Once it is created, drag from the explorer to your report.
0
 

Author Comment

by:dave_sky
ID: 21839473
RickJ,

You are so right. I was trying to create the formula in a selection formula.

Thanks for the rescue!
0
 
LVL 8

Expert Comment

by:RickJ
ID: 21839590
Thanks,
Glad I could help.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What namespace do I need to import? 2 29
Problem with SelectList in .NET MVC application 1 17
VB.NET 2008 Winforms Signing 13 19
Crystal Report sorting 6 11
A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 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