Cross Tab ignores Selection Criteria

[bdjb]

How can I create a cross tab in Crystal 11 that won't ignore the overall Selection Criteria? When run, the detail data is correct, but the Cross Tab pulls in everything

thanks in advance

 

[IanWaterman]

sounds like you are suppressing data so it does not show in details.

You will need to create a formula which only evaluates displayed data

If ... what ever your suupression condition.. = false then numberfield else 0

use that in your cross tab

Alternatively if you can stop suppressing data and filter out in select statement.

Ian

 

[bdjb]

Thanks for the reply, I'm not suppressing anything in the details, only using the select statements. If I select only OH files in my selection statement, I get just OH, but in the cross tab, I'll get all states if that makes sense?

 

[IanWaterman]

That is not possible.

Please show select statement and sql generated.

Did you design report or have you inherited it

Check following
Section expert for details line - if the formula box opposite suppression is red there is a conditional suppression formula.

In main menu Report->Select formula-> Group if there is a formula there you have conditional suppression

Ian

 

[bdjb]

OK. so group selection formulas are ignored by the crosstab?

 

[lbass]

Well, actually group selection is not suppression, but selection based on data already returned from the database. And yes, group selection is ignored by crosstabs unless they are set up to build in the group selection criteria. For help with this, please explain the crosstab set up (rows, columns, summary field and type of summary). Show content of any formulas. Also show the group selection formula.

-LB

 

[bdjb]

Thanks LB,
I have a listing of Clients for the rows, then count of files by Office and state

Chicago Cinci
IL IN OH
Client1 15 3 5
Client2 7 1 4
Client3 12 12 5
Client4 8 3 22


The group selection is:
Maximum ({@Complaint Submitted}, {Entities.EntityID}) in WeekToDateFromSun

@COmplaint Submitted is:
If {EQAnswer.FieldNum} = 8 And {EQAnswer.EntityRole} = 'FORECLOSURE' Then CDATE({EQAnswer.AnswerText}) Else
CDATE('01/01/1900')

Let me know what else I can provide, and thank you!

 

[lbass]

Try creating a formula like this to use as the summary field instead of {table.file}:

if Maximum ({@Complaint Submitted}, {Entities.EntityID}) in WeekToDateFromSun then
{table.file} else
{@null}

...where {@null} is a new formula that you open and save without entering anything. Use a count as the summary field for this formula.

-LB