logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Using “Transparent” option in SSRS, and prevent the ‘Not a Valid BackgroundColor’ Error

July 31, 2015 1 comment Article Intermediate, SSRS

 

In SSRS, if you’re building an expression to manage, for example, the background colour of a cell / shape, it’s easy to fall into the ‘Transparent Trap’

When building an expression, it’s easy to use the expression builder to add constants and built-in values.

This is particularly true of the colour pallet, given you need to know the specific colour names

 

The problem however if when you want to use a ‘No Color’ background.

Double clicking the ‘No Color’ value from the Pallett will insert “Transparent”

However, when you go to run this, you may receive the following warning…

Note: The warning will only generate if, after evaluating the statement, it needs to invoke the “Transparent” – ie, you won’t get the warning until it actually tries to use this colour – if your expression nearly always evaluates to a different colour, you may never see the warning.

Now, this warning isn’t going to break your report – you will get the correct result – but if you want to clear the error you simply need to go back to the expression editor, and replace “Transparent” to ‘Nothing’ (no quotes)

Your expression will now evaluate without generating a warning (remember, there’s a long-standing bug in SRSS whereby a warning won’t disappear until you restart the application, so don’t be alarmed if it’s still there to begin with)

And that’s it.

Related

Tags: BIDS, Conditional, Expression, Formatting, SSRS

1 comment

  • ryt September 8, 2016 at 1:14 pm - Reply

    tedt

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Showing a Picture Based on the Value of another Cell in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Showing Data Bars as a 'Proportion to Total' in Excel
Format or Remove Borders from a Slicer or Timeline in Excel
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
Using the same Named Range in multiple worksheets, but with different values, in Excel

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2021 - Theme by ThemeinProgress