The first item selected would be Parameter(0). So the number would be (ListIndex-1)

If I have a multi-value parameter @OrderID, I can get the number of items selected using [@OrderID.Count]. Is that what you were looking for?

Now we're starting to get somewhere... We still need a couple of things: The create table scripts for the tables referenced in the views. Without them, it's impossible to...

Looks like if you had a ParentID (the ID of the parent/family of the child) in each of the queries you listed, you could just inner join them on ParentID,...

If you're trying to create a database on your local machine, then when you log into SQL Server, the instance should be something like YOUR_MACHINE_NAME\INSTANCE_NAME. Can you log in...

You owe it to yourself to make friends with Books On Line ( the help file for SQL Server ). Hidden very carefully under the F1 key. ...

What happened when you tried it using rectangles?

it would help a lot of you posted some dummy data for your tables. (CREATE TABLE and INSERT scripts).

Also, do the UNIONS and the NOT EXISTS separately. Maybe...

If you have dates in your table, you could use something like:

SELECT *

FROM Sales.Orders

WHERE Sales.Orders.OrderDate BETWEEN DATEADD(year,-1,GETDATE()) AND GETDATE();

You probably want to add 1 to the "one year ago" stuff...

BETWEEN...

Sorry, I should have clarified. You don't need the totals query at all. You can do the counting/totals whatever in SSRS. If you use a simple stored procedure...

Magy,

Thanks for the sample data... would be easier to consume if you did it like this or with create table/insert scripts. Just makes it easier to reproduce your problem...

If the date field is available, you could do something like this:

FORMAT(Fields!enrollDate.Value,"MMMM")

and it will format the date as a Monthname....

1="January" etc.

Drop a Matrix (not a tablix) onto the design surface of your report.

Drag [Staff] to the row,

[ServiceType] to the column

and drop the [Duration] to the value (intersection of Row &...

What happens if you create a stored procedure that has a different name, but is essentially the same stored procedure? Sounds like something is happening on the server we...

Why not just delete and recreate the dataset?