Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

color parameter Expand / Collapse
Author
Message
Posted Friday, October 9, 2009 5:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 20, 2010 4:13 AM
Points: 9, 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
Post #800645
Posted Friday, October 9, 2009 1:40 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 12:35 PM
Points: 858, Visits: 614
SQL Server doesn't support the concept of color. Are you talking about Reporting Services or something else?


Post #801061
Posted Sunday, October 11, 2009 10:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 20, 2010 4:13 AM
Points: 9, 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
Post #801324
Posted Sunday, October 11, 2009 12:10 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:00 PM
Points: 570, Visits: 387
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
Post #801336
Posted Monday, October 12, 2009 1:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 20, 2010 4:13 AM
Points: 9, 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
Post #801400
Posted Monday, October 12, 2009 1:37 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:00 PM
Points: 570, Visits: 387
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
Post #801407
Posted Monday, October 12, 2009 2:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 20, 2010 4:13 AM
Points: 9, Visits: 37
Yeeeeeeeeeeeees I think it's a good idea, I will do it
thank you
Ilyes
Post #801411
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse