January 24, 2008 at 1:20 pm
Hello
Is it possible to have conditional color appear on selected items in a parameter dropdownlist in SSRS?
eg. if an account is inactive display in red, otherwise normal color
Account 3
Account 4
Account 5
Account 6
Account 7
Account 8
(I could do this in Crystal using their RAS option.)
Thanks,
Joe
January 24, 2008 at 3:50 pm
I have not heard that this is possible in my experience but one thing you would be able to do is to display this in the label of the parameter value. So...
Account 1 - inactive
Account 2 - active
etc...
You may also setup multi parameters allowing the user to first select active or inactive or both and then a second list populated with the matching account numbers.
Hope this Helps!
-Ben
Ben Sullins
bensullins.com
Beer is my primary key...
January 24, 2008 at 4:15 pm
Thanks, Ben. yes, I'm already displaying the active/inactive within the label,
but would like to add the color difference if possible.
We used to be a Crystal shop, but have moved everything over to SSRS.
I could this in Crystal using their RAS option and was hoping there was a method.
Thanks,
Joe
January 24, 2008 at 4:45 pm
Yeah I don't think there is such an option for a report parameter. If you were setup with a cube you would be able to define this at the dimension/measure level but again I don't think it would show up in the parameter list...
Ben Sullins
bensullins.com
Beer is my primary key...
January 25, 2008 at 12:48 am
I think you can set colors to the parameters , I havent tried this out, but you should probably try using an expression like below in the available values option of the report parameter.
iif(Parameters!ServerName.Value = "ABCD", "Yellow".......
here is an article that has something similar implemented.
http://www.sqlservercentral.com/articles/Reporting+Services/61339/
January 30, 2008 at 12:11 pm
I am not using a drop-down list, but instead a single-column table. I make my selections by clicking on each textbox on the table and by configuring the Action property of the textbox to pass a report parameter called ServerName.
This is how I set the background-color property of each textbox in the table listing all my server instances:
=Iif(Parameters!ServerName.Value = Fields!ServerName.Value, "Yellow",iif(RowNumber(Nothing) Mod 2, "Blue", "White"))
The expression above means that if the parameter value equals the current value in the textbox, set the color to yellow; otherwise set it alternatively to Blue or White.
See this excellent article to which I owe the above:
"The Reporting Services 3-Trick Pony"
http://www.sqlservercentral.com/articles/Reporting+Services/61339/
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 30, 2008 at 4:08 pm
since the reporting parameters are NOT a part of report body (pls. look at xml behind that rdl file), they cannot be rendered, sorry. only items that are within tags can be rendered.
however, if you really, really, really want to change colors on them, you can still do it :-).
nothing is impossible! you would write an aspx page with that drop-down boxes where each item is color-coded.
then, you'll reference your asmx page (reporting services) into your web project and put your report on this page using the Report Viewer control.
i hope this helps.
maya
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply