I was looking around to see if I could answer your question, but what I found is that v1 may not work with SSRS 2014.

Check out this article.

Damian,

can someone create a stored procedure that brings all the data together into one dataset? I suppose you could write a stored procedure that creates a temporary table and...

Sounds like you could use a subscription to do this. That will handle sending the reports to each user. If you're not using Enterprise, you can use Jason Selburg's...

You can't store "spaces" in a date. Period. Dates are stored as numbers in T-SQL, and you can't store spaces in a numeric field.

For a newb, nice job posting!

This should do it... you might want to play with ROW_NUMBER() for a while... super handy once you figure out how it works.

SELECT y.Class

,...

"I need it to filter on the latest version of each of the 3 documents the person has to sign."

but there's no MAX(Date) anywhere... how are you returning the latest...

the usual way of dealing with a series of IIF statements is nesting them... Here's the barebones structure (which you've sorted out)

=IIF(<test>,<true part>,<false part>)

In your case, I think you...

You don't really have a new column for each day of the month, do you? If you do, that's the source of your problem.

A little normalization is a beautiful...

SSRS and Access reports are alike in that respect - they have their own sorting and grouping, so they'll override the sorting in the dataset. If you want something sorted...

Sounds like a homework assignment. what did you try?

Also, if you post your question like this, you're more likely to get answers...

Nice runnable code to recreate your problem....

CREATE TABLE...

you would need to join to a table of hours and outer join the two...

SELECT Hrs.[TheHour]

,Movie.[StartTime]

FROM Hrs LEFT JOIN Movie...

After looking at this and playing with it for a little while, I stand by my original conclusion - you need the UNsummarized data from somewhere. If you can talk...

do you have the unpivoted data somewhere?

Maybe this article?

https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

This is Lynn Pettis' calculation[/url] for first day of the next month...

select dateadd(mm, datediff(mm, 0, @ThisDate) + 1, 0) -- Beginning of next month

last day of the month is the...