filter detail section of matrix report

[igor22]

Hi,
is there a way to filter details section of the report created using Matrix report type?
I just want to see rows that contain positive numbers.

Thanks,
Igor

 

[Catadmin]

You could go into the Expressions property and do something like:

=IIF(Myfield < 0, "", Myfield)

Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[igor22]

that solution will still show rows, it's just not going to display negative numbers in those rows.
I want to not to show those rows at all.

 

[Catadmin]

Then put the expression in the HIDDEN property of the row and change the "" to TRUE and the Myfield to FALSE.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Catadmin]

Oh, and don't forget to zero out your padding around the rows or you'll have white space.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"