Crosstab over Relational DB: Show/Hide rows based on values

[missinglinks]

Hi All,

I've created a crosstab based on relational data using dimensional functions using the technique suggested by Nimrod Avissar in this post (http://www.cognoise.com/index.php?topic=23391.0)

For the actual results I'm getting - the cross tab is displaying the correct information and I have a crosstab layout as per below.



               

	Current	Previous	Variance	Show
000001     Person1   Net Total	1,806.44	1,719.12	87.32	1
000002     Person2   Net Total	1,561.72	1,561.72	0	0
000003     Person3   Net Total	1,823.85	1,753.35	70.5	1
000004     Person4   Net Total	1,644.13	1,644.13	0	0

What I am now trying to achieve is where my column "Show" is 0, hide the row. The logic used to calculate "Show" is based on if the variance is +- 1 and if the parameter for "ShowVariance" is "Yes". The data displayed in the "Show" column is correct based on the inputs. How would you go about filtering out the "Show" records that = 0? I've tried doing just a simple filter where [Show] = 1 (but this still returns everything) as well as conditional filtering in the report layout. I'm at a bit of a loss as to what I else I could try.

Does anyone have any suggestions? Any thoughts will be greatly appreciated.