Data Driven subscription not working for PDF, IMAGE

Hi,
I worked on SQL Server tutorials in Books online, "Data Driven
Subscription". In this tutorial, reports are delivered via email on a
scheduled time. as per the tutorial emails are being delivered in "MHTML"
format but it does not deliver the report in "PDF" or "Image" format. The
report manager shows a status message that there was an error but there is
no way to know the exact error. It just says "1 errors". The reprot is
working absolutely fine as it is being delivered in "MHTML" format but not
in "PDF" or "IMAGE". Please assist.
Regards
GinnyJust check in errorlog file for any specific errors. Just manually run the
same report and see whether it gives the same error.
Amarnath
"Ginny" wrote:
> Hi,
> I worked on SQL Server tutorials in Books online, "Data Driven
> Subscription". In this tutorial, reports are delivered via email on a
> scheduled time. as per the tutorial emails are being delivered in "MHTML"
> format but it does not deliver the report in "PDF" or "Image" format. The
> report manager shows a status message that there was an error but there is
> no way to know the exact error. It just says "1 errors". The reprot is
> working absolutely fine as it is being delivered in "MHTML" format but not
> in "PDF" or "IMAGE". Please assist.
> Regards
> Ginny
>
>

Customizing report manager

I need to place a jpeg image of our company logo in the middle section of the Report Manager heading between the wording of "reporting services" and Home | My Subscriptions | Site Settings | Help

I am using SQL Reporting Services 2005 with SQL Server 2005 SRV Pack 2

Can someone point me in the right direction?

This is not possible. Report Manager was not designed to be customizable.

You can only edit the stylesheet (css) or replace some of the existing images (fixed size) by going to the installation directory and looking in the styles and images directories.

|||

I was able to accomplish what you are describing by:

1) Adding a custom image to the /images directory of the Report Manager virtual directory

2) Adding the following code to the ReportingServices.css stylesheet in the /styles directory of the Report Manager virtual directory:

#ui_sharedArea
{
background-image: url(..\images\{imagefilename.gif});
background-repeat: no-repeat;
background-position: center;
}

where imagefilename is the name of the image file you used in step 1

Customizing report manager

I need to place a jpeg image of our company logo in the middle section of the Report Manager heading between the wording of "reporting services" and Home | My Subscriptions | Site Settings | Help

I am using SQL Reporting Services 2005 with SQL Server 2005 SRV Pack 2

Can someone point me in the right direction?

This is not possible. Report Manager was not designed to be customizable.

You can only edit the stylesheet (css) or replace some of the existing images (fixed size) by going to the installation directory and looking in the styles and images directories.

|||

I was able to accomplish what you are describing by:

1) Adding a custom image to the /images directory of the Report Manager virtual directory

2) Adding the following code to the ReportingServices.css stylesheet in the /styles directory of the Report Manager virtual directory:

#ui_sharedArea
{
background-image: url(..\images\{imagefilename.gif});
background-repeat: no-repeat;
background-position: center;
}

where imagefilename is the name of the image file you used in step 1