Background images won't show when exporting to Excel

Hello there,
I have a table with several cells that contain a value. Also for those cells
there's a specific background image, which is displayed depending on the
value contained (displayed) in the cell. Everything works fine, but when I
export the report to excel the background image is not displayed, only the
value.
Is there any way to achieve this ? (display and background image along with
the value?)
Is this a Excel's limitation or is it Reporting Services' ?
Is there any work around ?
Will the RS SP2 add this feature ?
Thanks in advance
CesarCesar;
this is an Excel limitation and backgroup images are not supported.
Unfortunatelly, there is no work around I am aware of.
"Cesar" wrote:
> Hello there,
> I have a table with several cells that contain a value. Also for those cells
> there's a specific background image, which is displayed depending on the
> value contained (displayed) in the cell. Everything works fine, but when I
> export the report to excel the background image is not displayed, only the
> value.
> Is there any way to achieve this ? (display and background image along with
> the value?)
> Is this a Excel's limitation or is it Reporting Services' ?
> Is there any work around ?
> Will the RS SP2 add this feature ?
> Thanks in advance
> Cesar

background images and external URLs sorting problem

I have created a report which uses an external .bmp accessed through a URL as
the background image of the header (i.e. to brand the report with the company
logo).
this works fine until I use the interactive sort function which causes the
image to disappear. refreshing the report brings back the image, but resets
the sort.
Does anybody know of any way to make the image reappear after using the sort?
thanks in advance!
--
BLVI have exactly the same problem. Have you managed to solve it in the mean
time?
"BLV" wrote:
> I have created a report which uses an external .bmp accessed through a URL as
> the background image of the header (i.e. to brand the report with the company
> logo).
> this works fine until I use the interactive sort function which causes the
> image to disappear. refreshing the report brings back the image, but resets
> the sort.
> Does anybody know of any way to make the image reappear after using the sort?
> thanks in advance!
> --
> BLV

Background image sizing

Hello,
I have a jpg image to use as report background. How can I strecth the image in order to fill the page background (i'm using PDF output) with my image ?

Thanks,
PierreIn report designer, go to the properties editor window and select "Body" for the report body from the drop down list.
The report body has a background image property. Note: page header and page footer are independent of the report body - but you can also use images in those page sections.

-- Robert|||Hello Robert,
thanks for the reply. I already Tryied these settings but I can't stretch the background image, just set the repeating style.

Since the report must be rendered as PDF only, how can I create a background image so that it fits perfctly to the resulting PDF ? I guess it depends on the DPI used in reporting services.

Thanks,
Pierre|||

Sorry, we don't have an option right now that would stretch the image.

If your image fits the physical page size (i.e. Report.PageSize - Report.Margins) at 96 dpi, it should also look fine then in PDF at higher resolutions.

-- Robert

|||

Hi Robert,
ok, hoping for the next release :-)

Thanks,
Pierre

sql

Background image sizing

Hello,
I have a jpg image to use as report background. How can I strecth the image in order to fill the page background (i'm using PDF output) with my image ?

Thanks,
PierreIn report designer, go to the properties editor window and select "Body" for the report body from the drop down list.
The report body has a background image property. Note: page header and page footer are independent of the report body - but you can also use images in those page sections.

-- Robert|||Hello Robert,
thanks for the reply. I already Tryied these settings but I can't stretch the background image, just set the repeating style.

Since the report must be rendered as PDF only, how can I create a background image so that it fits perfctly to the resulting PDF ? I guess it depends on the DPI used in reporting services.

Thanks,
Pierre|||

Sorry, we don't have an option right now that would stretch the image.

If your image fits the physical page size (i.e. Report.PageSize - Report.Margins) at 96 dpi, it should also look fine then in PDF at higher resolutions.

-- Robert

|||

Hi Robert,
ok, hoping for the next release :-)

Thanks,
Pierre

Background image or watermark disappears on 2nd page

I have a Background image and it disappears on the 2nd page when it is outputted to PDF. If I set the repeat property the background image starts partically again on the same page. On the Reports viewer it repeats on each page, but redering to PDF seems to have an issue. I have SP1 installed. What is the solution?Do you use embedded image?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"RobbRoss" <RobbRoss@.discussions.microsoft.com> wrote in message
news:EE3E9602-8486-47EC-9322-EC9372A557BB@.microsoft.com...
>I have a Background image and it disappears on the 2nd page when it is
>outputted to PDF. If I set the repeat property the background image starts
>partically again on the same page. On the Reports viewer it repeats on
>each page, but redering to PDF seems to have an issue. I have SP1
>installed. What is the solution?|||It is a bug.
Possible workaround is to use image that is big enough and set
BackgroundRepeat property to Repeat.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"RobbRoss" <RobbRoss@.discussions.microsoft.com> wrote in message
news:EE3E9602-8486-47EC-9322-EC9372A557BB@.microsoft.com...
>I have a Background image and it disappears on the 2nd page when it is
>outputted to PDF. If I set the repeat property the background image starts
>partically again on the same page. On the Reports viewer it repeats on
>each page, but redering to PDF seems to have an issue. I have SP1
>installed. What is the solution?

background color and background image after SP1

Hi,
after installing sp1 for sql server 2005 the properties "background
color" and "background image" do not show in HTML. They do show in TIF
or PDF export. Also the header and footer are rendered correctly in
HTML. Only the body of the report is always white!
Any suggestions?
Thank you
BennoI too am having this problem. I have found the following on the MS site. I
believe this applies to the problem, however, I have not tried this solution.
http://support.microsoft.com/?kbid=921395
"Benno" wrote:
> Hi,
> after installing sp1 for sql server 2005 the properties "background
> color" and "background image" do not show in HTML. They do show in TIF
> or PDF export. Also the header and footer are rendered correctly in
> HTML. Only the body of the report is always white!
> Any suggestions?
> Thank you
> Benno
>

Avoid caching image datatype

Hi all,

I have a database with 40GB of binary objects stored in image columns
in two tables.

Our database server is also used for another 15 databases.

SQL Server caches the image-column, causing the cache-hit-ratio to
dramatically decrease, since fetching a couple of binaries from the
image-column uses up the
memory, and throws other cached objects out of the cache.

Is there a way, and could someone tell me how, to avoid caching of
specific
columns/tables?

Regards
///Magnus"Marwin" <alice@.underlandet.com> wrote in message
news:f2216085.0501270242.4da6d365@.posting.google.c om...
> Hi all,
> I have a database with 40GB of binary objects stored in image columns
> in two tables.
> Our database server is also used for another 15 databases.
> SQL Server caches the image-column, causing the cache-hit-ratio to
> dramatically decrease, since fetching a couple of binaries from the
> image-column uses up the
> memory, and throws other cached objects out of the cache.
> Is there a way, and could someone tell me how, to avoid caching of
> specific
> columns/tables?
> Regards
> ///Magnus

I don't believe there's any way to do this, and if MSSQL is caching the
image data rather than other data, then that suggests that the image data is
required more often anyway. By the way, when you say "cache hit ratio", do
you mean "buffer cache hit ratio"? The first relates to re-use of query
plans from the cache, the second is re-use of data pages, so that's the one
you want to watch. If the buffer cache hit ratio is low, the best option is
probably to add more memory to your server, assuming that you're seeing a
significant performance hit.

Simon|||There is no way to do that on specific tables. SQL Server internally
implemented a sophisticated page replacement algorithm that keeps the most
frequently used data page in memory. So the hot frequently accessed
objects/pages will not be kicked out of cache just because some apps read a
lot of image data.

--
Gang He
Software Design Engineer
Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.
"Marwin" <alice@.underlandet.com> wrote in message
news:f2216085.0501270242.4da6d365@.posting.google.c om...
> Hi all,
> I have a database with 40GB of binary objects stored in image columns
> in two tables.
> Our database server is also used for another 15 databases.
> SQL Server caches the image-column, causing the cache-hit-ratio to
> dramatically decrease, since fetching a couple of binaries from the
> image-column uses up the
> memory, and throws other cached objects out of the cache.
> Is there a way, and could someone tell me how, to avoid caching of
> specific
> columns/tables?
> Regards
> ///Magnus