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


Background Images in Reporting Services


Background Images in Reporting Services

Author
Message
Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11437 Visits: 2730
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/awarren/3184.asp

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
bredins
bredins
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 40

Hi Andy,

Thanks for the article - a great summary.

I have been working with a number of these options recently. A particularly useful feature is being able to set the background image based on some criteria in the data using an expression. Something like a big red "DRAFT" watermark can be quite nice in certain circumstances.

One question: in SSRS 2000 SP2 we keep on getting situations where images are not displayed in the report (whether populated from the database, or an embedded image) - we simply get that irritating little red X in place of the image. This appears to happen when deployed to certain servers, but not on others. Any security issues or other pointers to solving this issue?

Rgds,





Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11437 Visits: 2730
I dont have a SQL2K instance installed anymore to experiment on, but my guess would be that it's a path problem more than a security problem, but it depends on how you stored your image. I'd try taking a report that works correctly and deploy to a different server to see what happens. Not a lot of help I know!

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Del Mitchell
Del Mitchell
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 6

Andy,

I developed a report with an IIF(PARAMETER.bla="DRAFT","draft","final") for the background.

Where draft and final are embeded images. In Visual Studio it works fantastic!, but when I upload neither image appears. I tried the same with external and used the actual file names and after uploading the image files I got the same results. In both instances it works fine in Visual Studio. Once uploaded, BEEP!

Any Ideas?

Cheers...Del


Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11437 Visits: 2730

It should work:-) I added a report to a project, then added two images as well. Source=external, value==IIF(Parameters!SetBack.Value="DRAFT","e2ead2.png","e2ead1.png"). Report worked fine in IDE or deployed. I would start by making sure both images got uploaded to the same folder as the report and that you can see them.

Note that while it doesnt apply to your issue, the parameter value will be case sensitive, so entering Draft, draft, or any other value other than upper case DRAFT will cause it to match to the else clause. Can be fixed by just coercing the input value to uppercase in the comparison.



Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Del Mitchell
Del Mitchell
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 6

Andy,

First off, thanks for taking a look! After a long day... I discoverd that the background was actually showing up, below my screen and fixed in place. In otherwords when I collaped my parameter selection portion of the report, up popped the word DRAFT.... And it stayed in the same place as I scrolled through the page. Strange behavior. When I exported it to a PDF file it appears on the first page... So I think I'm on the right track now. Now I've got to see if I can get it to appear on all of the pages of the PDF.

Again, Thanks, at the end of the day I enjoy working with SQL reporting much more than I did with Crystal.


Laique
Laique
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 12
Nice Article , But i have one problem here, I am embeded the image in the background of the report, But i want it in the center of the report. How Could i do this ?? I tryed a lots but didnt get.
shubhangim
shubhangim
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 10
I m having 1 doubt.I have to Put a water Mark logo in the body section of report. But that logo is conditional. In 1 condition it will be displayed or else it will be invisible . How to handle this IFF and where?
Plz help ....
shubhangim
shubhangim
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 10
In continuation tp my previous post . I tried to put
IIF(Fields!fk_Order_Status.value.indexof("PENDING_SHIPMENT")<>-1,"WaterMark"," Flower")

where WaterMark n Flower are my embedded images.
I wanna show Watermark in 1 condition n Flower in other.
But it is not wrking fine. Giving build errors. that Backgrung image is wrong.
Plz help it's urgent.....
ashende
ashende
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 72
Hi,
Thanks for the article. Here's my question. I need to print a 2 page form as a report. How do I add 2 images as page 1 and page 2?
Thanks.
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