I assume you want something like this?

+ item1

+ item2

+ item3

- item4

item41

item42

item43

item44

+ item5

+ item6

+ item7

That is, you want to...

Sorry, I don't follow. Have you specified your parameter in the Report Parameters menu?

Can you elaborate? What is the error you get?

I haven't tried this before, but have you specified the ItemPath parameter under Report Parameters in the report?

That would be a good place to start.

In the Data Tab enter something like this:

Command type should be text.

Then in your layout, you can set your parameter, MyParam, in the Action property of...

Thanks both for your input, it's much appreciated.

GSquared (8/27/2008)

---

The problem is probably the common misuse of "ie", with "eg" being what was intended. After all, "FROM" is a predicate, just like "WHERE", which would make the...

GilaMonster (8/27/2008)

---

Thanks for doing the test, I got the same results running it on my machine, version 9.0.3054 Dev...

GSquared (8/27/2008)

---

I missed the TN column in the Where clause. That would be needed too.

Because of the B-tree nature of indexes, a non-clustered index should do just fine for...

Marios Philippopoulos (8/27/2008)

"At present, the missing index information is generated only for queries that meet these conditions:

- The query must have a predicate (ie. a WHERE clause) referencing a column...

GilaMonster (8/27/2008)

---

Marios Philippopoulos (8/27/2008)

---

One caveat is that indexes used in places other than in the WHERE clause of queries are not included in the DMVs, so, for example, indexes needed...

GilaMonster (8/27/2008)

---

Why does it have to be clustered? If it was me, I'd suggest a nonclustered index for that, (TN, CID) INCLUDE (IDt)

What's the selectivity of TN? How many...

GSquared (8/27/2008)

---

If that query is the only thing being considered, how about both?

create clustered index CIX_Table on dbo.Table (CID, IDt)

But, as always, things like inserts, updates, deletes, and...

G Bryant McClellan (8/27/2008)

---

That part I was aware of. It also skews the index usage counts when a new index is added because you don't necessarily see the difference. You...

For some reason, the following query also hangs. When I abort it, I get this error 3...