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

Data driven subscription

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
GinnyHi Ginny,
To know the exact error you will have to look into the ReportServer log
file; its default location is
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\LogFiles
Look at the latest ReportServerService__<time stamp>.log file for
description of the error.
Virat
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

CustomReportItem

Hi,
I am trying to find out information on how to use the CustomReportItem node.
The online documentation (and RDL specification) talks about accessing a
RichTextControl as an example but does not give details on full
implementation required. If CustomReportItem is currently supported
(searching this board seems to imply it is not supported in current release?)
can someone point me in the direction of a code example or guide on how to
use this node if one exists.
Thanks,
RichardThe structure/implementation for CustomReportItem will change significantly
in RS 2005. The functionality will be available in the upcoming RS 2005 Beta
3 (actually is already in the last community preview releases of SQL 2005).
Not sure if the documentation will be already contained in the RS 2005 Beta
3 BOL release though.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"R.Shiels" <R.Shiels@.discussions.microsoft.com> wrote in message
news:6D369D32-9B26-43C7-A1D7-48BEA896B75B@.microsoft.com...
> Hi,
> I am trying to find out information on how to use the CustomReportItem
node.
> The online documentation (and RDL specification) talks about accessing a
> RichTextControl as an example but does not give details on full
> implementation required. If CustomReportItem is currently supported
> (searching this board seems to imply it is not supported in current
release?)
> can someone point me in the direction of a code example or guide on how to
> use this node if one exists.
> Thanks,
> Richard
>