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

Struggling to write a Iif or Switch statement in the expression for the following:

If the cell value is "Y" then nothing

If TODAY() is 10 day or less prior to SV3...

You need CHARINDEX() to find the position of the second dash (if it exists).

This almost works:

use tempdb;

go

SELECT OrderNo

, CHARINDEX('-',OrderNo,4) AS FindDash

, LEFT(OrderNo,CHARINDEX('-',OrderNo,4)) AS NoSuffix

FROM (

SELECT 'SO-123456' AS OrderNo

UNION ALL

SELECT 'SO-123456-01'

UNION...

If you can avoid using UNION, I probably would. (Maybe SQL Server acts different than it's stepbrother Access, where union query performance was appalling, but I don't know.)

Are you querying...

What options did you choose when you installed SSRS? "Install but do not configure"? If you did a default install, the install script should have created a ReportServer database....

How about...

SELECT ClientID

--,MAX(ServiceDate) AS LastSvcDate

FROM #Services

GROUP BY ClientID

HAVING MAX(ServiceDate)<DATEADD(d,-80,GETDATE());

Then just join that back to the Client table to get the client info...