Skip to Content
0
Former Member
Jun 01, 2009 at 04:22 PM

CrossTab Report Query

22 Views

Hello,

I am trying to set up a crosstab report using the sample data below but want to avoid it counting the records below 14 times. For example if I insert the Int.CallType field into the crosstab, it will display 14 records but this is supposed to be just 2.

The problem lies with the decision table where 1 field (Decision.RuleName) has multiple values.

Customer.ID | Interaction.Number | Decision.RuleName | Decision.Decision | Int.CallType

1 | 455 | CoverageCheck | Accept | New

1 | 455 | SecurityCheck | Declined | New

1 | 455 | ExcludedCheck | Accept | New

1 | 455 | BureauCheck | Accept | New

1 | 455 | PreviousCustomerCheck | Declined | New

1 | 455 | LocationCheck | Accept | New

1 | 455 | ScoreCheck | Accept | New

2 | 456 | CoverageCheck | Accept | New

2 | 456 | SecurityCheck | Declined | New

2 | 456 | ExcludedCheck | Accept | New

2 | 456 | BureauCheck | Accept | New

2 | 456 | PreviousCustomerCheck | Declined | New

2 | 456 | LocationCheck | Accept | New

2 | 456 | ScoreCheck | Accept | New

If I create a detail report and group by Customer.ID the report picks and displays a seemingly random rule name and if I add a formula field (if Decision.rulename = "SecurityCheck" and Decision.Decision = "Declined" then "Declined") it remains blank for some of the records. If I remove the grouping the report is visible as per example above including the formula field result. This however will display the data as per sample above.

Any help would be appreciated.

Thanks,

WA