Yep, they are all there. Thanks!

I still wonder why my installation doesn't have that as an option for me on the right-side of the screen. In my training class the...

Thanks to all who replied for the good ideas. I like the pivoting examples as those will help me as I continue down my learning curve.

***********************************************

If you're lucky your environment...

Stepping back for a moment and rethinking what I am trying to do I think that your way makes much more sense. Rather than doing a left 4 (which gives...

I knew I was making a mountain out of a mole hill. I just needed to add select queries within the Select query in order to make each count it's...

My apologies, I thought I had done so in my first post but my head is up in the clouds right now trying to figure this out. Let me try...

Unfortunately that doesn't help. I need to know how many territories are in each district and return each of those values into their own column.

What you are saying is:

SELECT ...

OK - The only thing I haven't fine-tooth-combed is the back-end data so I decided to redo all the back end stuff. I rewrote and reran my scripts which create...

yes - the data looks good when I do Explore Data. Looks just like it does in the Underlying sql table.

What is happening is that everything is perfect until i...

Thanks for the reply Steve.

Yes, in the datalayer I have a separate column for each attribute's name lookup, Alignment_Corp has a corresponding Disp_Align_Corp and so on for the other three...

still no luck.

I created individual attributes for each of the hierarchies levels. Everything works great until I modify the NAME property for the attributes that appear in the hierarchy. As...

GOTCHA!

That is exactly what I am doing but I didn't think it was an issue since it was just a lookup value, not used as the key column.

This will add...

Additional Info -

It only breaks after I add "algnment_name" to the Source name property of the attribute. If I do not add this property then the hierarchy runs just fine.

To...

This takes me back to pretty much the same problem i had before - although now the explanation (!) point is gone.

What happens after I finished this is that the...

Nomenclature... YEP.

I think I am starting to follow you here but, based upon your example, I don't see where I tie in the "display" value. Corp, Terr, Dist all have...

That does speak to a lot of the questions I had about SSRS, thanks! Most of the limitations you mentioned with Crystal don't exist though if you are using the...