I found this problem on a client machine that had a mixed history of components being installed and removed, where they had previously been able to connect Excel to a...

One technique I've seen is to control the report depending on the render format. I *think* when you include the report in the body of an email subscription that it's...

That's a "Functioning DBA" :p

djackson 22568 (5/29/2013)

---

Steph Locke (5/29/2013)

---

djackson 22568 (5/29/2013)

---

Steph Locke (5/29/2013)

---

Whilst on the topic of upvoting useful functionality... things like adding native alternating row colours in ssrs would be super handy...

https://connect.microsoft.com/SQLServer/feedback/details/483013/proper-support-for-banded-rows-green-bars

SSRS has...

I am assuming you are just including the TEMT_CLUSTER_SMALL fact table in the analysis, that's probably the right way to proceed, but I am wondering how useful clustering analysis is...

I think the issue is that you've set ID_NUM as a key. They aren't unique so the data mining tool is getting confused.

You don't need to change the data to...

What you're looking for is an "accumulating snapshot" fact table. This is a fairly common data-warehousing pattern.

There's heaps of information on how to create them which I won't repeat...

I'm glad you did the testing, and I agree with your conclusion. Testing for rows will be way more consistent and robust than testing for nothingness.

Sounds almost existential

This reminds me of a situation I encountered where a stored procedure was querying an Analysis Services cube, storing rows in a temp table and then returning results to Reporting...

What version of Reporting Services is this?

Do you have an SMTP server (or exchange) set up in the Reporting Services config utility on the server? Is it on a reachable...

Assuming your field1 and field2 are rows, you can create a row group. Generally groups rely on the dataset having the same value in a certain column.

e.g. If you have...

I don't think you should remove that.

Those lines are...

I would argue that the central lat/long of a particular ZIP code region is fine enough granularity. Unless you are a Telco or a Utility, mapping the exact coordinates of...

Thanks Lynn, good plan.

Gah! I hate how this forum errors out if you take too long writing a reply. Lost all of it 🙁

Anyway, here's a quick re-write.

Firstly, AXIS 0 is the columns,...