Hi,
I want to add a color transparency in textbox on ssrs report on the basis of qty. Sample has been attached.
Any suggestion or anyone familiar with this would be appreciable.
Regards,
Zohan
*This post is locked for comments
Hi Zohan,
Using Sparklines & Data Bars to Visualize Data in SQL Server Reporting Services Reports
When you click view the cell's properties in the property window, there should be a Background Color property. Then you can create conditions. e.g =IIF(Fields!Column.Value = "Approved", "Green", "No Color") Here is an example::
=iif(Fields!Date.Value < today() AND Fields!ID.Value = "a", "RED",
iif(Fields!Date.Value < today() AND Fields!ID.Value = "b", "BLUE",
iif(Fields!Date.Value >= today() AND Fields!ID.Value = "a", "GREEN",
iif(Fields!Date.Value >= today() AND Fields!ID.Value = "b", "YELLOW","WHITE"))))
This checks the date value of "Date" and compares it to today, as well as the text value of "ID" and compares it to "a" or "b".
If the text value is a and the date is before today, make the field red, if its b and before today, then make it blue. If the date value is today or later and the text value is a, then make it green and if the date value is today or later and the text value is b then make it yellow. If none of the conditions match, then make it white.
However when you have many conditions you might prefer 'switch' logic:
=switch( Fields!Date.Value < today() and (Fields!ID.Value = "a" or Fields!ID.Value = "c"), "red",
Fields!Date.Value < today() and (Fields!ID.Value = "b"), "blue",
Fields!Date.Value >= today() and (Fields!ID.Value = "a" or Fields!ID.Value = "c"), "green",
Fields!Date.Value >= today() and (Fields!ID.Value = "b"), "yellow")
etc
(Why not create the report in Excel which has such conditional formatting features?)
This isn't transparency. If you set background transparency based on the value, the background would have a solid color across the whole cell, which would be more or less transparent.
What you're talking about are data bars.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (