Thanks for the reply, Steve. Just so you know, I did Google and search for an answer but didn't find anything which helped which is why I ended up...

My experience has been that it's best to have your users view SSRS reports in Internet Explorer. In most cases reports were okay in Firefox, but even then sometimes...

I had to do this for the first time recently and found that using SSIS is the best way to go. You can both load the XML files into...

Thanks for the replies, everyone, much appreciated.

Looks like i'll need to start hanging around SQL user groups, i'm sure there's one near me where I live. I'll...

pshields (8/22/2013)

---

I am doing something similar to what you are trying to do using one tablix. The dataset contains 5 weeks of data. The tablix has two columns....

Yeah, I tried a few different things including the rectangle. Ultimately the best way is to have all the data in the same dataset when using a tablix, using...

Just wondering if anyone might have any ideas. I didn't get a response to this question in the MSDN forum, either, do I need to give additional information?

Thanks for all of the help. I have it working now and using the actual client file which is all parsed out the way I want it. Now...

LOL, glad I could help facilitate some education on date formats and querying. I think this is one of the more confusing areas of querying data.

I'm also mostly an...

Thanks for the reply, really appreciate it. I think you are correct regarding a date table and i'd normally have something like that in a data warehouse design. ...

Sorry, I managed to figure out what was going on. It actually had nothing to do with the dates.

Ugh, i'm under a little bit of pressure this...

Excellent, thanks for the input, everyone. I have modified my design, please find it attached.

Some notes -

ALZDBA - you are correct, I did not plan for the fact...

Thanks for the response, Tom. One reason why I split the WorkoutMethod into their own table is so I can use those values in a drop-down menu in the...