CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2008
    Posts
    3

    Unhappy Using a "If" and "Then" Statement in Crystal 9

    Hi,

    Writing code is my weakness so, please bare with me as I give too much info & an attachment. I'm pulling duplicate records from a field that has multiple member types {Member_Types.MEMBER_TYPE} & I need to adjust the report. What I want to do is pull only the duplicate records that contain a duplicate + 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 & NM - I don't want it to show on the report.

    The weird part is it looks like the report is running an SP:{CALL "iMIS"."dbo"."AACAP_GET_DUPLICATE_RECS_SP";1}

    Below is the duplicate match key we're using:
    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))

    I hope I was able to explain that correctly? Any help would be appreciated.

    Thanks,

    DJ
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured