Crystal Reports Formula Workshop boolean condition to string

Posted by Jay on Stack Overflow See other posts from Stack Overflow or by Jay
Published on 2010-04-14T21:06:22Z Indexed on 2010/04/14 21:23 UTC
Read the original article Hit count: 439

Filed under:

crystal

|

reports

|

boolean

|

string

Hello,

I'm currently trying to create a report using Crystal Reports that comes with Visual Studio 2008.

I would like to include a field of type boolean on my report that shows a string rather than true or false. The string should contain either contain a € or a % sign.

How would I go about doing this in the Formula Workshop?

I've tried things like e.g.

if {tblAankoopDetails.SoortKorting} = true then "€" else "%"

However this never seems to work and results in warnings such as "The formula result must be a number".

This should be fairly simple but this is my first go at using Crystal Reports.

Help would be much appreciated.

Jay

© Stack Overflow or respective owner

Related posts about crystal

Crystal Reports .Net Guidance

as seen on Stack Overflow - Search for 'Stack Overflow'
We have been using .Net and Visual Studio for the last six years, and early on developed a number of web based reporting applications using the .Net version of Crystal Reports that was bundled with Visual Studio. My overall opinion of that product has been, to say the least, rather unimpressed. … >>> More
Crystal reports 11 RDC (COM API) displays printer dialog even when I tell it not to prompt

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Crystal Reports 11's RDC (COM) API to print. My code looks like this: HRESULT res = m_Report->SelectPrinter(b_driver, b_device, b_port); if (FAILED(res)) return res; // For these calls, the #import wrapper throws on error m_Report->PutPrinterDuplex(dmDuplex); m_Report->PutPaperSize(dmPaperSize); m_Report->PutPaperSource((CRPaperSource)pdlg->GetDevMode()->dmDefaultSource); if… >>> More
Crystal Reports alternative that can use db connection on web.config?

as seen on Stack Overflow - Search for 'Stack Overflow'
Crystal reports isn't working on different servers because they use different connection strings and crystal reports can't use the connection string stored on the web.config to access the database. Is there an alternative to crystal reports that can use the connection string on the web.config file… >>> More
Crystal Reports: Save Time with Formula Sharing

as seen on ASP alliance - Search for 'ASP alliance'
Once a report library grows to a certain size there are always going to be common formulas which are needed repeatedly. Having easier access to them can save a lot of development time. >>> More
Automate delivery of Crystal Reports With a Windows Service

as seen on ASP alliance - Search for 'ASP alliance'
In this article, Vince demonstrates the creation of a Windows Service to automatically run and send a Crystal Report as an email attachment. After a basic introduction, he examines the creation of the database and windows service with the help of relevant source code and explanations. Towards the… >>> More

Related posts about reports

Grep Crystal Reports (with Sub-reports)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need a way to quickly search a large number of Crystal reports (with sub-reports) for the names of several stored procedures. (Trying to find dependencies.) I'm running Windows XP and downloaded this grep program - http://www.wingrep.com/download.htm. So far, I'm not convinced that it's working… >>> More
Scheduling parameterized reports in Crystal Reports Server

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to set up a report to run monthly in Crystal Reports Server 2008 that will give me the next month's Affordable Care Plan termination dates. However, as far as I can tell, I can only give it a particular date string, not "7 days after the report is scheduled". How do I do this? (Same question… >>> More
SQL Server Reports IDE for creating reports

as seen on Stack Overflow - Search for 'Stack Overflow'
I have to modify SQL Server reports. It is not easy to modify directly XML report file (*.rdl). Is there any IDE for editing SQL Server Reports? >>> More
Alternate line colors in reports using Crystal Reports

as seen on C# Corner - Search for 'C# Corner'
Sometimes when we have a big reports displaying heavy textual information, one technique to visualize data in a consistent way is to shade line in alternate colors. In this article, I will show how Crystal Reports enables this technique very easily. >>> More
How to convert SSRS 2008 Server reports to SSRS 2008 Client Reports

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a large SSRS 2008 Server Report Project (more than 200 reports). Currently my companystrategy has been changed and we want to convert these server reports to client reports. All of the Server reports uses Storeprocedures (or in some cases from the SQl Functions) All of them work properly… >>> More