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...

Interesting question. The only way I can think of doing it is to declare the parameter as text and then use a value list and then filter that. ...

Can you post the SQL for your query?

You could probably do it with ROW_NUMBER() and then filter that.

SELECT [query fields], ROW_NUMBER() AS rn

FROM...

And then filter for rn<=20

Did you try the matrix wizard? I think that's what you're after.

That's not a pivot.

Easiest way to do what you are describing is to use Reporting Services and add a Grouping level to your table.

Is there a reason you can't just post the SQL in the body of your message? Sending people to your attachment is a good way to get no answers.