This is a migrated thread and some comments may be shown as answers.

Adding 2nd filter to Crosstab

1 Answer 65 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Michael
Top achievements
Rank 1
Iron
Iron
Michael asked on 19 Apr 2021, 04:27 PM

I have two report parameters, one for date, another for Sales Rep. They are visible, and I am using them to filter the report. I can add the first date filter to the Crosstab, but when I add the second filter to the Crosstab, I get an error for the operator. I changed to from "=" to "Like", because it is a string, but that did not resolve the issue. What I am doing wrong?

Error: "An error has occurred while processing Table 'Cosstab1': Cannot perform '=' operation on System.String and System.Object[]."

1 Answer, 1 is accepted

Sort by
0
Michael
Top achievements
Rank 1
Iron
Iron
answered on 19 Apr 2021, 04:47 PM
Ahhhh, I figured out my issue. I had the parameter set to use multiple values, so the filter needs to be set to "IN".
Tags
Report Designer (standalone)
Asked by
Michael
Top achievements
Rank 1
Iron
Iron
Answers by
Michael
Top achievements
Rank 1
Iron
Iron
Share this question
or