locked
colors RRS feed

  • Question

  • how to use ms excel 2007 color codes in ssrs 2005?
    can u plz give/provide me the ms excel 2007 color codes.
    Friday, August 20, 2010 4:58 AM

Answers

  • Hi KUAMR,

    To apply the same color in SSRS as you would see in excel 2007, please follow the below.

    1. In Excel select a cell where you have a color applied.

    2. In the tool bar click the arrow in fill color and select more colors

    3. Then click on the custom tab

    4. select color model to RGB

    5. Note down the values for Red, Green and Blue

    6. In SSRS, click the textbox you need

    7. In the properties window click on (Color or BackgroundColor) or Color property you need and click the down arrow; then select more colors

    8. In the dialog that opens, set the color custom to RGB

    9. Set the values of Red, Green and Blue to the value noted in step 5

    10. This should now give you the exactly the same color as you had in excel.

    Hope this helps. regads


    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
    • Proposed as answer by Jerry Nee Monday, August 23, 2010 3:54 AM
    • Marked as answer by Jerry Nee Friday, August 27, 2010 9:39 AM
    Friday, August 20, 2010 6:06 AM

All replies

  • I think you may need to look at the color pallette and choose the similar color in reporting services as well. Check if this link is helpful to you.

    Regards,


    Phani Note: Please mark the post as answered if it answers your question.
    Friday, August 20, 2010 5:11 AM
  • Hi KUAMR,

    To apply the same color in SSRS as you would see in excel 2007, please follow the below.

    1. In Excel select a cell where you have a color applied.

    2. In the tool bar click the arrow in fill color and select more colors

    3. Then click on the custom tab

    4. select color model to RGB

    5. Note down the values for Red, Green and Blue

    6. In SSRS, click the textbox you need

    7. In the properties window click on (Color or BackgroundColor) or Color property you need and click the down arrow; then select more colors

    8. In the dialog that opens, set the color custom to RGB

    9. Set the values of Red, Green and Blue to the value noted in step 5

    10. This should now give you the exactly the same color as you had in excel.

    Hope this helps. regads


    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
    • Proposed as answer by Jerry Nee Monday, August 23, 2010 3:54 AM
    • Marked as answer by Jerry Nee Friday, August 27, 2010 9:39 AM
    Friday, August 20, 2010 6:06 AM