Cross Tab Question

[dacards]

I have 2 Cross Tabs in one report and I need to delete some data from each. They each show # of cases per week per state. Both are pulled from data with parameter of ?State = Utah (which can be changed depending on report. Basically, I do NOT want to see data that = ?State (in this case Utah). I've been messing with the format cross-tab section but can seem to find a formula that works or where to put it.

Any help is greatly appreciated.

1st)

STATE TOTAL 4/30 5/7 5/14
Illinois 14 4 4 6
New York 5 2 3 0
Florida 1 0 1 0
Utah 0 0 0 0


2nd) _____ = Cell is blank

STATE TOTAL 4/30 5/7 5/14
______ 20 5 14 1
Missouri 10 5 3 2
New York 6 2 0 4
Florida 1 0 0 1
Utah 20 6 8 6

 

[lbass]

What is your record selection formula? How are you using the parameter so far? I don't follow your examples, since Utah appears in both with different numbers. Please provide more info about what the crosstabs are meant to do.

-LB

 

[dacards]

Sorry- I've been using Crystal for the past month or so, still a newbie.

RECORD SELECTION FORMULA
({MOD_TRB.Create Date} >= {?Start Date} and
{MOD_TRB.Create Date} <= {?End Date}) and
({MOD_TRB_Value 2} ={?Work Group}or
{MOD_TRB_Value 1}={?Work Group})

Value 1 and 2 = State location.

The two cross tabs show where cases are coming from and where they are going, I'm basically just counting Value 2 for the first one, and counting value 1 for the second.

1) Utah sends cases to the following states:

STATE TOTAL 4/30 5/7 5/14
Illinois 14 4 4 6
New York 5 2 3 0
Florida 1 0 1 0
Utah 0 0 0 0


2) Utah receives cases from the following states.

STATE TOTAL 4/30 5/7 5/14
______ 20 5 14 1
Missouri 10 5 3 2
New York 6 2 0 4
Florida 1 0 0 1
Utah 20 6 8 6

let me know if more information is needed to clarify. Thansk again for the help.

 

[lbass]

So you want to eliminate Utah (or the parameter selection) from each crosstab? If you are using Value 1 as the row field in the first crosstab, and Value 2 as the row field in the second crosstab, then I think you could change your record selection formula to:

{MOD_TRB.Create Date} >= {?Start Date} and
{MOD_TRB.Create Date} <= {?End Date} and
{MOD_TRB_Value 2} ={?Work Group} and
{MOD_TRB_Value 1} <> {?Work Group}

Use this for one of the crosstabs. Then insert a subreport in the report footer and add the following record selection formula in the subreport:

{MOD_TRB.Create Date} >= {?Start Date} and
{MOD_TRB.Create Date} <= {?End Date} and
{MOD_TRB_Value 1} ={?Work Group} and
{MOD_TRB_Value 2} <> {?Work Group}

Insert the second crosstab in the subreport. The subreport should be linnked to the main report on all parameter fields. Be sure to use the dropdown list in the lower left of the subreport linking screen to select the {?parm}, not the default {?pm-?parm} for each parameter.

-LB