Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Expression for Hiding/Showing Rows in Table Expand / Collapse
Author
Message
Posted Saturday, November 24, 2012 3:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, November 24, 2012 3:05 PM
Points: 1, Visits: 5
I am about as much of a newbie as possible. I've been working with Report Builder 3.0 for a week now. We have a piece of software built on SQL 2008R2. I want to build a custom report that will auto-populate from certain tables.

The problem: I want the report to list data from only the active session. The only way I see to differentiate between sessions is that in the SessionActivity dataset, the "SessionEnded" will be blank. My thought was an expression either to hide all rows not null in that column or show only rows that are null in that column.

I've been unable to successfully stumble through on my own. Any help would be greatly appreciated.
Post #1388340
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse