SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


color parameter


color parameter

Author
Message
lyeslink
lyeslink
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 37
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....

Ilyas
dsdeming
dsdeming
SSC Eights!
SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)SSC Eights! (880 reputation)

Group: General Forum Members
Points: 880 Visits: 647
SQL Server doesn't support the concept of color. Are you talking about Reporting Services or something else?



lyeslink
lyeslink
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 37
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???

Lyes
Ivan Donev
Ivan Donev
SSChasing Mays
SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)

Group: General Forum Members
Points: 625 Visits: 414
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.

/ivan
lyeslink
lyeslink
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 37
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
Ivan Donev
Ivan Donev
SSChasing Mays
SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)SSChasing Mays (625 reputation)

Group: General Forum Members
Points: 625 Visits: 414
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.

/ivan
lyeslink
lyeslink
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 37
Yeeeeeeeeeeeees I think it's a good idea, I will do it
thank you
Ilyes
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search