Rowgroup Subtotal formatting in the columns' total section

Question

Rowgroup Subtotal formatting in the columns' total section

Ninja's_RGR'us

SSC Guru

Points: 294069
More actions
January 11, 2011 at 7:48 am

#230278

See screenshot.
I have 3 row groups and 1 column groups.
I have totals on all the groups except the 3rd rowgroup (only the groups with totals have been marked on the screenshot).
I need to keep the grey formatting going all the way to the end of the line. 4 hours wasted on this silly little detail and I'm out of ideas.
Here's what I have "working" right now. Everything is fine except for the formatting of the total of the columns group section.
=IIF(NOT INSCOPE("matrix1_IsOD") OR NOT INSCOPE("matrix1_Shortcut_Dimension_2_Code"), "SteelBlue", IIF(NOT INSCOPE("matrix1_ItemFamily"), "SlateGray", "White"))

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Linda Claes Old Hand Points: 308 More actions · Answer 1

Hi Ninja,

Did you look at the deployed version of your report as well? I found that the scope (at least in RS2005) differs between design and deployed version. What I always do is: make a copy of my report where in the matrix I show the scopes eg. using expression:

=IIF(INSCOPE("matrix1_IsOD"), "matrix_IsOD", "")

+ IIF(INSCOPE("matrix1_Shortcut_Dimension_2_Code"), vbCrLf + "matrix1_Shortcut_Dimension_2_Code", "")

This always helps me to figure out the correct expression using the scope in my matrix (this expression would be based on the deployed version as this is what the users will see).

Hope this helps in finding the solution.

Kind regards,

Linda

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Thanks for the help.

And the least I can say is WOW that's screwed up.

However I was able to get myself out of it with this "simple" expression :

=IIF(NOT INSCOPE("RowGroup1") OR NOT INSCOPE("OnlyColGroup"),

IIF(INSCOPE("RowGroup1") AND NOT INSCOPE("RowGroup2"), "SlateGray", "SteelBlue"),

IIF(NOT INSCOPE("RowGroup2"), "SlateGray", "White"))

Linda Claes Old Hand Points: 308 More actions · Answer 3

You're welcome.

Happy to see that you found the solution.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Another quick question for ya. Have you noticed in ssrs 2k5 that when you deploy to overwrite a report, the overwrite doesn't work or only works partially??

Any workaround except manually deleting the report first from the web interface (or is there a way to automate this)?

Linda Claes Old Hand Points: 308 More actions · Answer 5

Hi Ninja,

I indeed saw this behaviour before. Especially changing the obligatory parameters is causing me headaches. For that reason we have a custom reporting services script (.rss file) that will delete the report before uploading it again.

The following article should give you a start on building your own rss script:

http://msftrsprodsamples.codeplex.com/wikipage?title=SS2005%21Script%20Samples%20%28Reporting%20Services%29&referringTitle=Home

Kind regards,

Linda

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Linda Claes (1/18/2011)
Hi Ninja,
I indeed saw this behaviour before. Especially changing the obligatory parameters is causing me headaches. For that reason we have a custom reporting services script (.rss file) that will delete the report before uploading it again.
The following article should give you a start on building your own rss script:
http://msftrsprodsamples.codeplex.com/wikipage?title=SS2005%21Script%20Samples%20%28Reporting%20Services%29&referringTitle=Home
Kind regards,
Linda

Thanks again. Any ways you could share that script by editing out any login info and server names? I assume this shouldn't take very long.

TIA either way.

Linda Claes Old Hand Points: 308 More actions · Answer 7

Hi Ninja,

Unfortunately using my script will not help you a lot as it contains some company specific code. Maybe you have a better start with the following article: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/86883afe-b214-445e-9c8c-100a40324646

Kind regards,

Linda

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 8

Awesome.

One last question.. Got any links on how to configure the external tools so that I can link this script and make my own single click deploy function?

Linda Claes Old Hand Points: 308 More actions · Answer 9

Hi Ninja,

No, I haven't put effort yet in creating such a tool. I'm still running this rss script from the command prompt so in case you find/create a tool to automate this process I would be very interested as well.

Kind regards,

Linda

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 10

Glad to. I'd most likely turn it into a short article or script as well.

Thanks again.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 11

And now high jacking my own thread for the 2 time.

I have bids installed in french. I'm sick of not getting the info about error messages because I don't guess the correct translation.

How do I show the english error message without reinstalling ssrs?