Keeping Report Pages from Showing

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Keeping Report Pages from Showing

Author

Topic

chrpeter
Starting Member

31 Posts

Posted - 2008-06-18 : 14:50:59

I have a report that pulls a customer balance.
In crystal there was a way to have the page not show up if it met a certain criteria(say if the balance was 0 or negative).

I'd rather not filter them in SQL because it takes a few calculations to figure out what their balance is, and I already have SRS doing that calculation.
So is there a way to have a report page not print based on a certain criteria?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-18 : 14:53:09

Just add a filter to the report.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

chrpeter
Starting Member

31 Posts

Posted - 2008-06-18 : 15:53:06

Can you elaborate a little?
I have a parameter the user can chose if they want to see these listings or not.
If this is Y, I need it filtered, if N no filter.

I tried =IIF(Parameters!BalOverZero = "Y", Fields!BalanceDue, 1.0)
and in the filter operator "<=" and value =0.0

In thinking about it, this doesn't work because BalanceDue isn't being summed up for each customer, and aggregate functions can't be put in the filter.

Any ideas?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-19 : 02:54:03

quote:
Originally posted by chrpeter

Can you elaborate a little?
I have a parameter the user can chose if they want to see these listings or not.
If this is Y, I need it filtered, if N no filter.

I tried =IIF(Parameters!BalOverZero = "Y", Fields!BalanceDue, 1.0)
and in the filter operator "<=" and value =0.0

In thinking about it, this doesn't work because BalanceDue isn't being summed up for each customer, and aggregate functions can't be put in the filter.

Any ideas?

Change the visibilty property of table/matrix used to display the balance.
Something like:-

=IIF(Parameters!BalOverZero = "Y", True, False) for hidden property

chrpeter
Starting Member

31 Posts

Posted - 2008-06-19 : 09:41:27

quote:
Originally posted by visakh16
Change the visibilty property of table/matrix used to display the balance.
Something like:-

=IIF(Parameters!BalOverZero = "Y", True, False) for hidden property

That's what I have right now, I'd like the whole page not to show up so people won't have to scroll through blank pages.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources