Report Distribution

Through report manager I am trying to see if it is possible
to set up a data-driven subscription, that will save the
file on a file share AND notifiy user via email based on values
stored in sql table.

I can get each to work as independent jobs but I want this to
be run as one.

Can this be done? How?

Thanks.

Not out of the box. Each subscription has only one delivery extension it uses. It is not possible to chain delivery extensions.

You can write a custom delivery extension that would do both of these operations. There's a printer delivery sample in the Samples that come with SQL Server 2000 Reporting Services and SQL Server 2005.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,
Me too wants to have some simillar to your requirement. Have you created some custom delivery extension for this purpose.

Regards;
Rakesh

Report Distribution

Through report manager I am trying to see if it is possible
to set up a data-driven subscription, that will save the
file on a file share AND notifiy user via email based on values
stored in sql table.

I can get each to work as independent jobs but I want this to
be run as one.

Can this be done? How?

Thanks.

Not out of the box. Each subscription has only one delivery extension it uses. It is not possible to chain delivery extensions.

You can write a custom delivery extension that would do both of these operations. There's a printer delivery sample in the Samples that come with SQL Server 2000 Reporting Services and SQL Server 2005.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,
Me too wants to have some simillar to your requirement. Have you created some custom delivery extension for this purpose.

Regards;
Rakesh

sql

Report conver to PDF format issue?

Hi All:

When i am trying to save the report (http) as PDF format, how can i make sure the format is what i want?

Becuase currently what i got is that it splits the report as half by saving PDF, and each half as one page.

Any helpf will be appreciated.

Cheers

Nick

Hi Nick,

Lets assume you want A4 format, lanscape.

Go to the report properties (main menu) and select the "Layout" tab. Now fill in these vaules:

Page height: 8.27in; Page width:11.69in; All four margin fiels 0.2in.

Click OK

Now click an empty spot on your report, so your "body" will be selected and check the layout / size properties.

It's important that the size of your body in the report is smaller than your page layout, minus your margins, so this should max. be 8.27-0.4 = 7.87in by 11.69-0.4 = 11.29in

Jeroen

|||

Thanks Jeroen Alblas,

i couldn't see four margin fields in report properties.

My report can print out just fit one page but not PDF format, which splits to two pages.

Cheers

Nick

|||

I found it.

Now it's working. I can print out as PDF format perfectly

Thanks Jeroen Alblas

Report Builder - Cannot Save Report

How can I resolve the matter of not being able to save a report using Report
Builder?
ERROR:
The permissions granted to user REPORTSERV\ittemp are insufficient for
performing this operationHi Terry
I think it has to do with your generel permissions, your administrator
should give your permission to save on relevant drives.
Martin
"Terry" wrote:
> How can I resolve the matter of not being able to save a report using Report
> Builder?
> ERROR:
> The permissions granted to user REPORTSERV\ittemp are insufficient for
> performing this operation