color parameter

  • Hello, I like to change the color of my columns through a parameter each time I want, but I don't know how to do it, can you help me please??

    PS: I want introduce all colors, is there any expression, like "allColors" or....


  • SQL Server doesn't support the concept of color. Are you talking about Reporting Services or something else?

  • Thank you for your response,

    Yes I am talking about reporting, I have to do somthing like a table with a simple columns, and I want being able to change the color of my columns(just in the header of my table) each time I want.

    I can give you an exampl:

    I have my table with 4 columns, "ProdID",Price","Quantity", and"summe"

    and I want to color these 4 cellules (which are the header of my table) with the same color, and be able to change it as I like.

    do you inderstand me???


  • If I understood correctly, you just have to select your header columns, then go to the Property windows in VS and in color selection window go to Expressions. From there you can choose how exactly you will pass the color to the expression. You can pass it like text (for example "Black" will color your cells in black, but here you have to stick only with the predefined colors in VS). Another way is just pass the RGB value of the color like #9b1212.

    I hope this might help you. Let me know if I can help you on that further more.


  • Yes, but the problem is that I want to put colors as parameter, in order to change the colors once my report will be stored in our intern server, so I have to put all the colors in this parameter, but I don't know how to do it and which expression I have to write

    I uesed this one: =Parameters!Colors.Value, but in this case, I have to put all the colors manually in the " avalibale values of parameters". I am looking for a special expression which contains all the colors

  • I haven't seen such an expression and I am not quite sure if it actually exists. As a workaround I can suggest you to create a table in your database where you can store those colors and use them for available values for the parameter in your report. This way you just have to populate the table once and reuse the values in whatever report you like.


  • Yeeeeeeeeeeeees I think it's a good idea, I will do it

    thank you


Viewing 7 posts - 1 through 7 (of 7 total)

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