Suppress in Cross Tab 2

[jdaily]

I am running CR10 pulling from a SQL Svr.

I have a cross tab that I have set up and I want to surppress specific data from coming over into the cross tab.

Example:
I am pulling State, Program and Label for the Rows and the Quarters for the Columns. Then I have the Total payments for the summary field.

There is data that I want to exclude from coming over and I am currently at a loss as to how to do that. I have tried the select expert but I don't think it's working correctly.

Here is the criteria I want to exclude/suppress:
{V_PAIDITM.STLMNTMTHD_DOCNO} = "0";
(({V_PAIDITM.NDC11} in ["55555-5555-01", "55556-5556-01"]) and
({V_PAIDITM.QUARTER} in ["2003Q1", "2003Q2", "2003Q3", "2003Q4", "2004Q1", "2004Q2", "2004Q3", "2004Q4"]) and
{V_PAIDITM.CLM_TYP} = "RC");

I want to exclude the docno = 0 from everything. Then I want exclude the NDC11 codes in certain quarters and with a clm_typ of RC.

Any suggestions? I thought of using suppress in the format section of Detail and then Report Header (where the cross tab is located. It didn't work.

Thanks,

John

 

[synapsevampire]

Go to Report->Selection Formula->Record and place:

(
{V_PAIDITM.STLMNTMTHD_DOCNO} = "0"
)
and
(
{V_PAIDITM.NDC11} in ["55555-5555-01", "55556-5556-01"]
and
{V_PAIDITM.QUARTER} in ["2003Q1", "2003Q2", "2003Q3", "2003Q4", "2004Q1", "2004Q2", "2004Q3", "2004Q4"]
and
{V_PAIDITM.CLM_TYP} = "RC"
)

-k

 

[jdaily]

This looks good! I can see where I made a mistake.

What about using this to suppress the data from coming over into the cross tab?

 

[lbass]

Don't use suppression, as it will not affect the crosstab results. Use SV's formula except reverse it, as in:

(
{V_PAIDITM.STLMNTMTHD_DOCNO} <> "0"
) and
not(
{V_PAIDITM.NDC11} in ["55555-5555-01", "55556-5556-01"]
and
{V_PAIDITM.QUARTER} in ["2003Q1", "2003Q2", "2003Q3", "2003Q4", "2004Q1", "2004Q2", "2004Q3", "2004Q4"]
and
{V_PAIDITM.CLM_TYP} = "RC"
)

It is still unclear exactly what you want to report on. In the above, if docno <> 0 and if a record does not meet the combination of criteria in the second set of parens, the record will appear in the report.

-LB

 

[jdaily]

I think that is going to work. You are right, if the docid <> 0 and it doesn't meet the other criteria, I do want to see it.

Thanks lbass!