Writing a “If” & “Then” Statement in Crystal Reports 9

130 pts.
Tags:
Crystal Reports
Crystal Reports 9
iMIS
Programming Languages
Reporting
SQL
Hi,

I'm new to the site and reletively new to writing code so, please bare with me.  I'm trying to pull duplicate records from a field that has multiple member types {Member_Types.MEMBER_TYPE}. What I want to do is pull only the duplicate records that contain a valid member type.

  1. For example 2 records meet my duplicate criteria & have a member type of GEN & NM - I want to show on the report.
  2. But if 2 records meet my duplicate criteria & have a member type of NM & 01 - I don't want it to show on the report.  
 I hope I was able to explain that correctly?  Any help would be appreciated.

DJandLO



Software/Hardware used:
Crystal Reports 9, iMIS 10.6

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    How are you checking your duplicate criteria ?
    68,430 pointsBadges:
    report
  • DJandLO
    Currently we're using the match key below: UPPER(SUBSTRING(Name.ZIP,1,5) + (CASE WHEN Name.LAST_NAME<>'' THEN (SUBSTRING(Name.LAST_NAME,1,4) + SUBSTRING(Name.FIRST_NAME,1,1)) ELSE SUBSTRING(Name.COMPANY,1,5) END))
    130 pointsBadges:
    report
  • carlosdl
    I'm not sure to understand. That doesn't check for duplicates at all. I would expect something in your report's query.
    68,430 pointsBadges:
    report
  • DJandLO
    ok, I viewed the stored procedure it's calling and it's below: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].
    130 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following