After much reading and testing, I've concluded that the "List" control DOES NOT OPERATE AS EXPECTED as relates to the KeepTogether property.

Only repeating detail items "may" stay together but if...

I'll reply myself again after much testing and searching on the web.

The Toggle, a.k.a. drilldown functionality of SSRS is so glitchy, jumpy, twitchy, and slow that IMO it is absolutely...

Thanks much Joe - almost there...

Please look here as well.. http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/bf2c5abf4b75b8ce/ee66f4ba0e4fe0bc?hl=en#ee66f4ba0e4fe0bc

I have read many, many articles and have tried many methods however - I still cannot link a "Parent...

Thanks for your assistance but still no-go.

To be clear - I am dealing with 2 Datasets.

Parent Dataset has the ClientID and a collection of Client contacts.  The child dataset also contains the...

Joe,

I've posted already here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=394442

but.. can you explain how one "syncronizes data regions" as a replacement for subreports ?  How do I tell the Child region which row I'm on...

Well it's me replying to myself again...

To remove any doubt about my report and perhaps it being complex or buggy, I created a new SIMPLE report with a tiny amount...

Ok Finally....

There is no visible "Expression" editor for the "Hidden" attribute of the parent "Visibility" attribute for a table row - BUT - you can edit one anyway...

So, I set...

Wow Joe - yes...

Why am I returning 255 columns, my bad.  Thanks for your brilliant insight and I just may use a multi-resultset XML Object/attribute pair to solve my problem.

Thanks again Doc...

In the end, I have a simple 3 level hierarchy, each level having attributes.  I will joining to this "hierarchy thing" quite often and it seemed that an...

Well Doc - I trust you I guess...

Just doesn't seem to really provide any help, effective help anyway.  Guess I won't be using Indexed views after all especially when you...

The point of what ?

I don't need an alternative, just want to know how Indexed views behave.  It it helps you, then change my sql example to this:

Select (1 ID...

Ouch that suks...  Can anyone else validate this ?

Was hoping to hear that only the columns involved in the actual index would be used but - when was the last...

Well-

Only after dropping and recreating the SQL 2K5 table was I able to proceed properly.

My best guess is that I had "reset" the table - meaning - I changed the...

Thanks - it does help a bit and validates more that UC's are in fact unique indexes.

At one point in time I thought I was "saving" either space, or processing...

You're correct Steve and thanks for the comments.

However, my "States" example was 100% pure example.  It exists only to show that someone can have multiple indexes on a table, with...