I think its because in some cases I have values for today but not today last year. I have no idea how to remedy that. Back to the drawing board!

These are helpful replies, and give me a little direction. I'm going to work on it some more. If I get stuck again, I'll trying and build exactly what's happening....

Thanks for your reply also.

I didn't do a very good job setting this up. I just tried to create a quick example to ask about a concept - Is...

Thanks for your response!

I should have made my example a little harder. My production project is much bigger, but I was trying to use the bare minimum so as not...

I don't know if I'm fully understanding, but are you looking for something like this? (Forgive me - I'm not totally sure on your date format so I switched it...

The online courses will introduce you to the basics. I think they are helpful in terms of getting you used to the language and concepts. Then read these threads. This...

Honest question - Is this the wrong forum? I didn't know whether to post it in the SSRS forum or not. For the life of me I can't figure this...

...the more I check, the more it does seem like the DATA files are not refreshing properly. That's at least part of the problem.

You got it. Basically, I'm not sure how to structure the query or the bar graph to make it move around. For example, I have a class that has 100...

I agree with Andy. Also, in some cases I've had to put the SQL statement in a common table expression and check for nulls with a CASE statement. I guess...

Thanks Derek. Would that create a permanent table called outputTable? Just to clarify, I already have a stored procedure created. I just need to put the results of the sp...

EDIT: checking above reply that came while writing post...

Thanks for pointing that out. I fixed the script.

Hi Craig,

This is very helpful! I've actually read several things you've posted in the forums, and gained understanding and solutions. Don't worry at all about the first response. Rereading the...

Actually I am a complete newbie. I was hired on at a medical school to create statistical reports and dashboards since I'm basically the only one who knows the business...