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,
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
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.
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.
