Another Option would be to use the "Custom Code" area in the report properties to create a routine that would return a colour based on dollar value.

This way you do...

skitter

take a look at my earlier post on Pivot Play

>>>

Excel Add-In Called "Pivot Play".

This tool allows you to see the connection and select text strings used by the...

What a good article. I also liked Eric's trick of manually creating the qry file. Very neat.

For pivot tables, one way to kind-of get parameter-ish functionality when using an external...

Another way to do this using more of the native function of the Matrix would be to create a grouping column, where one group value is tied to the Articles...

Sorry about my CTE Post.

I did not see that both jmapledoram & SQL Noob had already posted this as an alternative.

matteo

I wonder if "Common Table Expressions" might also be an option here.

You could create two CTE's that match your temp table creation and then join them together as you indicated.

I...

Yup I ran into this for some views that i had that did a "Select * from table"

However for views, you can run a stored procedure "Sp_refreshView" that will rebuild...

hey okie_greg

You made one of the two points that i was going to make.

My second point was concerning the collation sequence.

If the two databases have different collation...