Does Report Services 2005 have a Report Distribution engine. So that I
can for instance say; I want user 'A' to get report 'B' in a format of
'C' at 17:05 every day.
Many thanks
DavidYes, it is called Subscriptions. You can specify all of that. It is
available both Standard and Enterprise. However, Enterprise adds data driven
subscriptions.
Here is from books online about data driven subscriptions:
>>>
A data-driven subscription provides a way to deliver reports to a list of
subscribers that is determined at run time. You can use data-driven
subscriptions as follows:
a.. Customize report output at run time for each recipient of a delivery.
b.. Support the wide distribution of a report with a fluctuating list of
subscribers. For example, you can use data-driven subscriptions to
distribute a report throughout a large organization where subscribers vary
from one month to the next, or use other criteria that determines group
membership from an existing set of users.
A data-driven subscription differs from a standard subscription in the way
it gets subscription information. A data-driven subscription gets some
settings from a data source at run time, and other settings from the
subscription definition. Fixed aspects of a data-driven subscription include
the report that is delivered, the delivery extension, connection information
to an external data source that contains subscriber data, and a query that
retrieves subscription information. Dynamic settings of the subscription are
obtained from the query, including a subscriber list and user-specific
delivery extension preferences or parameter values. This data is retrieved
from a data source each time the subscription is processed.
>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<davidswain2005@.yahoo.co.uk> wrote in message
news:1141318397.513927.57680@.i39g2000cwa.googlegroups.com...
> Does Report Services 2005 have a Report Distribution engine. So that I
> can for instance say; I want user 'A' to get report 'B' in a format of
> 'C' at 17:05 every day.
>
> Many thanks
> David
>|||Yes, it's called creating a subscription
"davidswain2005@.yahoo.co.uk" wrote:
> Does Report Services 2005 have a Report Distribution engine. So that I
> can for instance say; I want user 'A' to get report 'B' in a format of
> 'C' at 17:05 every day.
>
> Many thanks
> David
>
Showing posts with label instance. Show all posts
Showing posts with label instance. Show all posts
Friday, March 30, 2012
Monday, March 12, 2012
report builder button missing
I have setup the RS on production server ( a named instance). The report
builder button is missing. I only can see new folder, new data source, upload
button on the http://servername/reports$instancename/Pages/Folder.aspx. I
have given myself all the rights in role setting.
I have searched in google. However only found something saying "by setting
the report server system property EnableReportDesignClientDownload to true".
However not found anything saying how to do that. checked every sql 2005
configuration tool. Not found anything to let you set that property.
Besides I have tried using
http://<servername>/reportserver/reportbuilder/reportbuilder.application
launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
My project due tomorrow. Please Help!! really appreciate it!!On May 29, 5:02 pm, Daisy <diy...@.msnews.group.post> wrote:
> I have setup the RS on production server ( a named instance). The report
> builder button is missing. I only can see new folder, new data source, upload
> button on thehttp://servername/reports$instancename/Pages/Folder.aspx. I
> have given myself all the rights in role setting.
> I have searched in google. However only found something saying "by setting
> the report server system property EnableReportDesignClientDownload to true".
> However not found anything saying how to do that. checked every sql 2005
> configuration tool. Not found anything to let you set that property.
> Besides I have tried using
> http://<servername>/reportserver/reportbuilder/reportbuilder.application
> launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
> My project due tomorrow. Please Help!! really appreciate it!!
Go to Site Settings from the Report Manager page. Select 'Configure
system-level role definitions'
and edit an existing system role or create a new system role that
includes the Execute Report Definitions task. Then make sure your
user ID is assigned that system role.
HTH
toolman|||That really helps. Thanks a bunch!
"toolman" wrote:
> On May 29, 5:02 pm, Daisy <diy...@.msnews.group.post> wrote:
> > I have setup the RS on production server ( a named instance). The report
> > builder button is missing. I only can see new folder, new data source, upload
> > button on thehttp://servername/reports$instancename/Pages/Folder.aspx. I
> > have given myself all the rights in role setting.
> > I have searched in google. However only found something saying "by setting
> > the report server system property EnableReportDesignClientDownload to true".
> > However not found anything saying how to do that. checked every sql 2005
> > configuration tool. Not found anything to let you set that property.
> >
> > Besides I have tried using
> > http://<servername>/reportserver/reportbuilder/reportbuilder.application
> > launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
> >
> > My project due tomorrow. Please Help!! really appreciate it!!
> Go to Site Settings from the Report Manager page. Select 'Configure
> system-level role definitions'
> and edit an existing system role or create a new system role that
> includes the Execute Report Definitions task. Then make sure your
> user ID is assigned that system role.
> HTH
> toolman
>
builder button is missing. I only can see new folder, new data source, upload
button on the http://servername/reports$instancename/Pages/Folder.aspx. I
have given myself all the rights in role setting.
I have searched in google. However only found something saying "by setting
the report server system property EnableReportDesignClientDownload to true".
However not found anything saying how to do that. checked every sql 2005
configuration tool. Not found anything to let you set that property.
Besides I have tried using
http://<servername>/reportserver/reportbuilder/reportbuilder.application
launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
My project due tomorrow. Please Help!! really appreciate it!!On May 29, 5:02 pm, Daisy <diy...@.msnews.group.post> wrote:
> I have setup the RS on production server ( a named instance). The report
> builder button is missing. I only can see new folder, new data source, upload
> button on thehttp://servername/reports$instancename/Pages/Folder.aspx. I
> have given myself all the rights in role setting.
> I have searched in google. However only found something saying "by setting
> the report server system property EnableReportDesignClientDownload to true".
> However not found anything saying how to do that. checked every sql 2005
> configuration tool. Not found anything to let you set that property.
> Besides I have tried using
> http://<servername>/reportserver/reportbuilder/reportbuilder.application
> launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
> My project due tomorrow. Please Help!! really appreciate it!!
Go to Site Settings from the Report Manager page. Select 'Configure
system-level role definitions'
and edit an existing system role or create a new system role that
includes the Execute Report Definitions task. Then make sure your
user ID is assigned that system role.
HTH
toolman|||That really helps. Thanks a bunch!
"toolman" wrote:
> On May 29, 5:02 pm, Daisy <diy...@.msnews.group.post> wrote:
> > I have setup the RS on production server ( a named instance). The report
> > builder button is missing. I only can see new folder, new data source, upload
> > button on thehttp://servername/reports$instancename/Pages/Folder.aspx. I
> > have given myself all the rights in role setting.
> > I have searched in google. However only found something saying "by setting
> > the report server system property EnableReportDesignClientDownload to true".
> > However not found anything saying how to do that. checked every sql 2005
> > configuration tool. Not found anything to let you set that property.
> >
> > Besides I have tried using
> > http://<servername>/reportserver/reportbuilder/reportbuilder.application
> > launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
> >
> > My project due tomorrow. Please Help!! really appreciate it!!
> Go to Site Settings from the Report Manager page. Select 'Configure
> system-level role definitions'
> and edit an existing system role or create a new system role that
> includes the Execute Report Definitions task. Then make sure your
> user ID is assigned that system role.
> HTH
> toolman
>
Subscribe to:
Posts (Atom)