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.

Is there a reason you are using a VARCHAR instead of a numeric type? If you used INT or some other numeric type, this would be pretty easy.

Can you post some dummy data so we can see what your data looks like? Are you importing this from somewhere or entering it manually? The reason I...