Answered by:
Background Image property in SSRS2008.

Question
-
Hi All,
i created a report in which i have to embed an image in the textbox along with one numeric value. When i embed the image in the BackgroundImage property, the image is repeating many times in the text box. In SSRS2005 there is a property "BackgroundRepeat:NotRepeat" which shows the image once in the text box. But in SSRS 2008 there is no such value against BackgroundRepeat property,so the image is repeating in my text box. can any one please throw some light on this property in SSRS2008.
TIA
Tuesday, June 3, 2008 11:39 AM
Answers
-
"Clip" is definitely the correct setting for the desired behavior.
You seem to be running into a bug in the CTP build you are using. It is working correctly in SSRS 2008 RC0.
-- Robert
Thursday, June 5, 2008 4:31 PM -
Just to give an update on the background image issue we were having, which we've fixed by making changes to the reports. We had tables with groupings in them and in the expressions for the textboxes, we were setting certain textboxes to blank, as in "", depending on a condition where there was no data for that specific entry. For the background image, we'd do a switch statement or even an iff statement where we'd set the background image in that textbox depending on the value of the textbox, using Me.Value, we assign red/yellow/green light image. In 2005 this worked fine, however in 2008 we need to set the "" as keyword Nothing for the textbox value. Then, somewhere in our switch or iff statement we need to check for IsNothing(Me.Value) and then assign it with some dummy image, in 2005 at this part of the process we could assign the image as Nothing or "" and it'd work. The dummy image has been our work around and it works now. Not filing a connect bug for this as I assume this is normal behavior for 2008.
On a side note, one other issue that I came across that was breaking the textbox images was the check for IsNothing(Me.Value) breaks, always resulting in True, if there is a javascript action in the Jump to URL property of a texbox/image/etc., in the report header. We were using it to open a new window to link to our website. Works fine if not in the report header though. Kind of far fetched, but I'll file a connect bug just incase, as this also worked in 2005.
Thursday, July 24, 2008 9:26 PM
All replies
-
Did you try setting it to "Clip"? It should be equivalent setting.
-- Robert
Wednesday, June 4, 2008 8:25 PM -
When i tried this property, in design window the textbox is showing single image but when i saw the report in preview window the image is repeating. is there any additionla property i have to set after setting the "clip" value against the BackgroundRepeat property?
TIA
Thursday, June 5, 2008 10:52 AM -
"Clip" is definitely the correct setting for the desired behavior.
You seem to be running into a bug in the CTP build you are using. It is working correctly in SSRS 2008 RC0.
-- Robert
Thursday, June 5, 2008 4:31 PM -
Thursday, July 17, 2008 10:19 PM
-
Please submit a bug via connect with a RC0-based repro.
Thanks,
Robert
Friday, July 18, 2008 12:38 AM -
Just to give an update on the background image issue we were having, which we've fixed by making changes to the reports. We had tables with groupings in them and in the expressions for the textboxes, we were setting certain textboxes to blank, as in "", depending on a condition where there was no data for that specific entry. For the background image, we'd do a switch statement or even an iff statement where we'd set the background image in that textbox depending on the value of the textbox, using Me.Value, we assign red/yellow/green light image. In 2005 this worked fine, however in 2008 we need to set the "" as keyword Nothing for the textbox value. Then, somewhere in our switch or iff statement we need to check for IsNothing(Me.Value) and then assign it with some dummy image, in 2005 at this part of the process we could assign the image as Nothing or "" and it'd work. The dummy image has been our work around and it works now. Not filing a connect bug for this as I assume this is normal behavior for 2008.
On a side note, one other issue that I came across that was breaking the textbox images was the check for IsNothing(Me.Value) breaks, always resulting in True, if there is a javascript action in the Jump to URL property of a texbox/image/etc., in the report header. We were using it to open a new window to link to our website. Works fine if not in the report header though. Kind of far fetched, but I'll file a connect bug just incase, as this also worked in 2005.
Thursday, July 24, 2008 9:26 PM -
Thanks John for getting back on this - yes, please file a connect bug and include the comments above.
-- Robert
Friday, July 25, 2008 2:55 AM -
Hi,
is there any solution for the Image repeating bug?
I am using the "Clip" value for the BackgroundRepeat property, but the image keeps repeating in my tablix cells.
Thursday, February 23, 2012 9:54 AM -
I found that I was only getting the repeating Background image 'feature' despite having BackgroundRepeat set to 'Clip' when using an image encoded in a database field or where the name of the embeded image was coming from the database i.e. Value was set to an Expression.
What I found worked was to set BackgroundRepeat to the Expression ="Clip".
Note that I'm working in 2013/2014 RDL/RDLC but it seems to be the same issue.
- Edited by Stuart F Baker Tuesday, April 28, 2015 11:35 AM
- Proposed as answer by Stuart F Baker Tuesday, April 28, 2015 12:37 PM
Tuesday, April 28, 2015 11:26 AM -
Thanks.Sunday, October 27, 2019 7:47 PM