Can't help thinking this would be a whole lot easier if you had a date field in the EmployeeRoles table...

Then you could just get the EmployeeID and Role With the...

The union query was just to create records I could manipulate based on the data you provided. I added the identity column because I needed a way to connect...

How do you know which values go together? Is there a primary key for the table that matches the records?

DOB LNAMEFNAMEMNAME

20140109 NULLNULL NULL

NULL NULLNULL JACK

NULL NULLJOHN NULL

NULL SMITHNULL NULL

End...

No idea what's going on. Any chance you can upload a copy of the report with some fake data embedded? The data source would be a union query, e.g.

SELECT...

Here's how to post data so people can mock up your data:

SELECT '3-31-2013' AS EOM_Date

, 'RA' AS Logs

, 'Valid' AS Reason

, 5 AS Units

UNION ALL

SELECT '3-31-2013'

, 'MA'

, 'Need to Complete'

,...

Right-click on the dataset, choose Add Calculated Field, and then add the calculated expression to your dataset. Then you can filter/sort on that column.

Welcome aboard, young Jedi.

Any chance you could post some sample data? I'm not sure if I understand what you mean or are trying to achieve. (So a simple example...

Got one to work... The part that tripped me up is that the gauge is expecting a numeric value for the state, so if you pass a string/text to it,...

Is there an index on the column "ID"? If not, there's your problem. Check the execution plan for the query - that will show you what's going on...

or maybe (From a database I had handy)

SELECT p.ProtocolNo

FROM Protocol p

WHERE NOT EXISTS (SELECT 1 FROM Enroll e WHERE e.ProtocolNo = p.ProtocolNo);

ProtocolNo is the primary key of Protocol, so that's...

Might have to go get his book... I'd love one that's actually easy to read. Lachev's book is pretty good, but a rough read.

Not sure you can do what you want (basically like the data in the margins in a phone book), but this is as close as I could find:

http://blogs.msdn.com/b/robertbruckner/archive/2008/10/26/fields-in-page-header.aspx

After further research...

Can't remember SSRS2008R2 really well, but I think it's pretty similar to 2010. Right-click on the design surface of your report, select Insert and at the very bottom of...

That was tongue in cheek... Jeff does everything in pure SQL.

You'll get a lot more responses if you make it easy for people to recreate your sample data easily. Here's an example:

SELECT '1' AS log_id

,'05/03/2014' AS inOutDate

, '08:28:32' AS...