Hi, How to add custom traffic light using image and place inside the cell table where the number exist and set the alignment in the right position ? Thanks

Hello, You have to add the 3 different traffic light as image and with an expression for the "Visibility" property you have set one to visible and the other to hidden, dependent of the value you have. With horizontal alignment you can place it left/center/right.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

I already have 3 different image. what I need is to set the background image horizontal alignment to the right side, but I did not find any property such BackgroundImageAlign, there is only TextAlign.. tx

Sorry, my fault, if you add an image into a cell of a table you can only use the padding property.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

padding property also affect the text position

Hi Octoni, From your description, you want to set the position of the BackgroundImage to the right side, right? When designing a report with Business Intelligence Development Studio, there are four properties for BackgroundImage, Source,Value,MIMEType and BackgroundRepeat. The backgroundImage is set in the left side by default, and we cant change the position of it. Based on your scenario, we can achieve your requirement thought another way. We add a column right of the column which contains number. And hide the border between this column and inserted column. Then its looks like one column. I assume the name of the column which you want to add a background image is column_A. The steps below are for your reference: 1.Right-click the handle of the column_A, select Insert Column, and then select Right. 2.Hide the border between column_A and inserted column. The details steps are like below. 1) Right-click the text-box that contains details data and select Text Box Properties, and then select Border in the left pane. 2) Click the right button below Preview, and then click OK button. Here have a screenshot for your reference: 3) Repeat the steps to hide the left border of the right text-box. This step is for the text-box which contains background image. 3.Drag an Image control to the text-box right of the text-box which contains number. 4.In the Image Properties, select an image in the Use this Image dropdown-list. 5.Select Visibility in the left pane, and select Show or hide based on an expression option. Click the button right of the text-box, type the following expression: =iif(fields!Number.Value is nothing,true,false) 6.Click OK. The report looks like below: If you have any questions, please feel free to ask. Regards, Charlie Liao

Hi Charlie, Thanks for the suggestion. actually that way is already in my plan to implement, however there are some reason that I could not use it, e.g : *) the report is in tabular format layout and contains lots of metrics columns, so I have to save the space width efficiently by not inserting any unnecessary column *) I use lots of header and sub header table, so if i use additional column for placing the image indicator, it will be hard to maintain the border expression.. so i still hope there is a way to place the image as cell background and set to the right side alignment.. cheers octoni