Skip to Content
author's profile photo
Former Member

Excluding records within Crystal 11.0 report

Post Author: Almow

CA Forum: Crystal Reports

I'm new to Crsytal and am trying to exclude a group of duplicated records when one set of criteria is met for one record within the group. The code that current exists within the report will exclude the record that meets the parameter conditions, but the other related records that do not meet the condition still appear on the report. Please see example below.

Business Partner Class Action

106029100 0003 0001

106029100 0024 0003

106029847 0015 0001

106029847 0003 0001

Both of these business partners are included in the selection parameter for Business Partner. In another parameter we have specified that we only want to see those business partners that do not have class of 15 and action of 1. This is the result that get now:

Business Partner Class Action

106029100 0003 0001

106029100 0024 0003

106029847 0003 0001

The only record that has been excluded is the one that contains a class of 15 and action of 1. The business partner 106029847 still shows up on the report because it has other classes and actions that do not meet the exclusion criteria. How do I remove all the records related to 106029847 from the report?

Here is the logic that we currently have in place within the Select Expert section:

If {?Operator} = "=" then

({BCONT.CCLASS} = {?Contact Class} and {BCONT.ACTIVITY} = {?Contact Action})and

{BUT000.CRDAT} in {?BP Created On} and

{BUT000.PARTNER} = {?Business Partner}and

{BUT000.CRUSR} LIKE {?BP Created By}

Else If {?Operator} = "<>" then

({BCONT.CCLASS} <> {?Contact Class} or {BCONT.ACTIVITY} <> {?Contact Action})and

{BUT000.CRDAT} in {?BP Created On} and

{BUT000.PARTNER} = {?Business Partner}and

{BUT000.CRUSR} LIKE {?BP Created By}

Any help would be greatly appreciated!!!!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 10:41 PM

    Post Author: JKitz

    CA Forum: Crystal Reports

    Can you try to explain the purpose of each Parameter? Some of those just don't seem real useful and could trigger something wrong in your records selection.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 03:36 PM

    Post Author: Almow

    CA Forum: Crystal Reports

    Sure I can explain the purpose of each parameter. Again this is within the Select Expert section.

    Prior to executing the report the user has the ability to select the following:

    Business Partner (BUT000.PARTNER) - they can enter a range or single values

    Created on Date (BUT000.CRDAT) - this is the business partner creation date. They can enter in a range or single values.

    Created By (BUT000.CRUSR) - this is who created the business partner. They can enter in single values or leave blank.

    Operator Field (?Operator) - this pertains to the Contact Class and Contact Action. They can either select equal to (=) or not equal to (<>). There's an IF statement for each option.

    Contact Class (BCONT.CCLASS) - they can enter a range or single values.

    Contact Action (BCONT.ACTIVITY) - they can enter a range or single values.

    The report should display a list of Business Partners #s, Business Partner Names, date created and created by based on the Operator selected and Contact classes and actions entered within parameter section.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Oct 03, 2007 at 05:46 PM

    Post Author: JKitz

    CA Forum: Crystal Reports

    I apologize for not getting back to you on this. I have been in Texas for the past week on business and have not had the time to look at the forums. I will take a look at this tonight and see if I can provide some help (if this is still an issue)

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Oct 03, 2007 at 07:07 PM

    Post Author: plm

    CA Forum: Crystal Reports

    Hi,

    Are you trying to remove 106029847 because it's got the same Class and Action as 106029100?

    Add comment
    10|10000 characters needed characters exceeded