Hi John,

SSRS always renders the colors specified with #000000 HEX RGB notation properly. What I mean by "properly" is that if you use a tool like MS Paint or Adobe...

Heh,

After SQL Server Central published the article, I found this really good reference on Custom Rounding:

http://support.microsoft.com/kb/196652

In the end of the page there are examples, and the SymArith function...

Sure, I wouldn't mind doing it. It would allow report authors to choose the method that suits them better. I will send you a draft when I am ready.

There is another way to apply "styles" to a report - by storing the report attributes, such as colour, in a database table and then retrieving them in a data...

You can't get SSRS to behave the way you have described.

You could, though, not format the row cells in any way and have the same navigation link on each...

Well, if you want to get Energy Revenue - Utility Revenue you could write MDX to do it. You can either create [Energy Revenue], [Utility Revenue], and [Energy - Utility...

If you want to have this as a calculated measure in your cube you can create one from Visual Studio Business Intelligence Dev Studio.

You may find this useful:

http://msdn.microsoft.com/en-us/library/ms166568.aspx

The calculated measures are not stored in the cube.

Only fact measures are - depending on the storage settings leaf data and aggregations, only aggregations or neither could be stored...

http://msdn.microsoft.com/en-us/library/ms175408(SQL.90).aspx

The attributes are always ordered alphabetically.

Try:

With Member [Revenue Energy]

As ([Measures].[Total Revenue], [Dimension Sector].[Sector Group].&[Energy])

Select [Measures].[Revenue Energy]

On columns from [EUS Fin Mart]

Welcome! Yes, it still lacks a bit of functionality but most things users ask for can be implemented in one way or another.

The closest you can probably go with SSRS is described here:

http://digitalcamel.blogspot.com/2008/02/database-dependent-duo-delivers.html

You can't achieve that in SSRS unless you separate the two reports and have a drill-through report (your subreport), which shows details about the item that the report user has...