Cross tab formula

[jen9814]

I am trying to create a simple if then statement. I would like to only include certain fields for a column in a cross tab and not display the totals for the fields I don't want. I have tried the formulas below and it still shows the totals for the not included field and the column name is blank.

If data.field in ["NQ", "QB", "QI", "QN"] then data.field2

I have also tried if {data.field} <> "**" then data.field2

 

[synapsevampire]

Go to the Report->Edit Selection Formula->Record (this is version dependent, please remember to post this) and place the criteria:

data.field in ["NQ", "QB", "QI", "QN"]

-k

 

[jen9814]

I have version 9. Will doing a record selection limit all my cross-tabs and detail section to only contain the criteria I select? Thanks.

 

[lbass]

Yes, synapsevampire's suggestion would limit the records in all areas of the report. If you only want to limit them for this crosstab, then use your formula as the column field and highlight it while in the crosstab expert->group options->select "Specified order"->use the dropdown to add the groups you want displayed (don't select the blank space at the top of the dropdown)->go to the "Others" tab and select "Discard all others".

-LB

 

[jen9814]

That worked great. Thanks for the help.