Solved

Crystal Reports Formulas

Posted on 2013-02-07
2
244 Views
Last Modified: 2013-02-07
I am working with Crystal Reports XI connecting to a SQL Database.  I would like to use a formula to suppress the field ***{MC_PurchaseOrder_TTX.MDesc}*** starting that if

{MC_PurchaseOrder_TTX.MExtDesc} ***Field Type: Memo*** is not blank then suppress {MC_PurchaseOrder_TTX.MDesc}.

Is this possible?

Thank you,

Bobbi
0
Comment
Question by:bmessmore
[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
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 38864992
In the 'suppress' conditional format button for the {MC_PurchaseOrder_TTX.MDesc} field you can do...


if isnull({MC_PurchaseOrder_TTX.MExtDesc}) then   //don't suppress
    false
else if trim({MC_PurchaseOrder_TTX.MExtDesc})>"" then  //suppress
     true
else    //don't suppress
   false


(Right-click {MC_PurchaseOrder_TTX.MDesc}, choose Format Field, and on the common tab, use the X+2 button corresponding to Suppress.)
0
 

Author Comment

by:bmessmore
ID: 38865151
Perfect.  Thank you!
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal reports subreports as total of main report 13 89
Crystal Reports Version 7 4 51
Crystal reports vb.net 2 72
Custom Chart Legends in Crystal Reports 2013 2 12
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

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