How to eliminate the rows on the crosstab report

building reports desktopintelligence
1

Hello,

I have a crosstab report and user wants to illuminate all rows with the same value for all of the columns for the salesrep.
They don’t want to see this salesrep on report. How can I do it?

Thank you in advance.

darina (BOB member since 2002-12-03)

2

I don’t quite follow you, but I think you can achieve what you need if you create an alerter?

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Nick,

Thank you for responce.
The report look like

NO Date/TIME | A B C D E F G
1 7/21/04 8:00AM 1 1 1 1 1 1 1
2 7/21/04 8:05AM 1 1 1 1 1 1 1
3 7/21/04 8:10AM 1 1 1 1 1 1 1

How can I illuminate all of the rows if it is the same value, using alerter?

Thank you

darina (BOB member since 2002-12-03)

4

So you mean only in the situation where A=1 and B=1 and C=1 etc, then the entire row should be green, lets say? What I’d probably do would be to create a new variable called Equality which will be along the lines of:

If A=B and B=C and… (etc) Then 1 Else 0

Then you create an alerter which says essentially if Equality is 1 then green format, bold text etc? Does that help?

Nick Daniels :uk: (BOB member since 2002-08-15)

5

Nick,

I understand the formula, but alerter. I don’t need to see all the same values rows on report, what can I assign in alerter to delete the rows,
not display at all this page with all of the sectioning? How can I filter those same rows?

Thank you

darina (BOB member since 2002-12-03)

6

Nick,

Sorry, I used wrong word. I need to eliminate the rows.

Thank you

darina (BOB member since 2002-12-03)

7

I think you could use the same logic to create that new variable, then use it as a Filter - either a global filter or just on that table.

amybz :us: (BOB member since 2004-07-21)

8

Thank you

darina (BOB member since 2002-12-03)

9

darina… just put a filter on the Query Panel! :wink:

Christian Konrads :it: (BOB member since 2004-07-21)

10

Thank you

darina (BOB member since 2002-12-03)