Report Delivery Option Missing

I have a SQL 2005 Reporting Server, and notice the only report delivery option
I see is 'export to a file share'. How to I enable the email option? Did
I perhaps miss something during installation?
Regards,
Pete Zerger, MCSE(Messaging), MVP - MOM
Co-founder and Webmaster, MOMResources.org
URL:http://www.momresources.org
BLOG: http://www.it-jedi.net/
mailto:pete.zerger@.gmail.com
...or find me in the forums at http://momcommunity.coAre your e-mail setting configured for ReportServer? You can check by going
to Report Services Configuration from Configuration Tools Under SqlServer2005.
"Pete Zerger" wrote:
> I have a SQL 2005 Reporting Server, and notice the only report delivery option
> I see is 'export to a file share'. How to I enable the email option? Did
> I perhaps miss something during installation?
> Regards,
> Pete Zerger, MCSE(Messaging), MVP - MOM
> Co-founder and Webmaster, MOMResources.org
> URL:http://www.momresources.org
> BLOG: http://www.it-jedi.net/
> mailto:pete.zerger@.gmail.com
> ...or find me in the forums at http://momcommunity.com
>
>

Report Builder Top N functionality

I'm not seeing any built-in functionality for Report Builder to get Top N values. Am I missing something? Is there a way to do this? If not, is there a way to simulate this functionality?

Thanks.

PJJ

This should help:

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032306508&CountryCode=US

Report Builder button missing - exec rep defs ticked & rep build ticked

I can see report builder in IE (I am report admin), but my users are not able to, despite having ticked 'report builder' against their name in folder security.

They have
Browser, Report Builder

Why can't they see it?

"Site Settings - Security - Config sys wide role defs - sys user " has "execute report defs" ticked.

Anyone, hmm?

They also need to be listed as System Users under Site Settings. In Report Manager (IE) click on Site Settings / Configure Site-Wide Security / Add a new role assignment with the userid and grant them System User status. Have the user refresh IE and they should see the Report Builder icon.

|||Confused....

We currently use AD groups to control user access to the RS.

An AD group is assigned one or more roles. e.g. 'browser','content manager'

How is it they are able to access the RS if they are not part of 'system user'?|||the solution:

create an AD group called report builder - add all your users who require RB access to this in IE, report manager: site settings - site wide security - new role assignment - enter ADReportBuilderGroupname and tick "system user"

Report Builder button missing - exec rep defs ticked & rep build ticked

I can see report builder in IE (I am report admin), but my users are not able to, despite having ticked 'report builder' against their name in folder security.

They have
Browser, Report Builder

Why can't they see it?

"Site Settings - Security - Config sys wide role defs - sys user " has "execute report defs" ticked.

Anyone, hmm?

They also need to be listed as System Users under Site Settings. In Report Manager (IE) click on Site Settings / Configure Site-Wide Security / Add a new role assignment with the userid and grant them System User status. Have the user refresh IE and they should see the Report Builder icon.

|||Confused....

We currently use AD groups to control user access to the RS.

An AD group is assigned one or more roles. e.g. 'browser','content manager'

How is it they are able to access the RS if they are not part of 'system user'?|||the solution:

create an AD group called report builder - add all your users who require RB access to this in IE, report manager: site settings - site wide security - new role assignment - enter ADReportBuilderGroupname and tick "system user"

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
>