Is it possible to do the following in Reporting Services...
In the query of the report have a column's critera be something along the
lines of this:
= ReportItem!Textbox25
In access it is possible through this syntax..
[Reports]![Report1]![Text5]
ThanksDon't worry I have sorted this out with a sub-report.
"ashvsaod" <ashvsaod@.hotmail.com> wrote in message
news:evkowNSeEHA.1036@.TK2MSFTNGP10.phx.gbl...
> Is it possible to do the following in Reporting Services...
> In the query of the report have a column's critera be something along the
> lines of this:
> = ReportItem!Textbox25
> In access it is possible through this syntax..
> [Reports]![Report1]![Text5]
> Thanks
>sql
Showing posts with label along. Show all posts
Showing posts with label along. Show all posts
Monday, March 26, 2012
Friday, March 23, 2012
Reporting Services permissions installation help
I have installed Report Services 2005 Developer Edition on a Vista
machine, along with SQL Server Database Engine 2005 Developer Edition.
I am not able to perform some functions, apparently due to permissions
but I do not know what to do.
When I open the Report Manager via Internet Explorer 7, I see the top
portion; "SQL Server Reporting Services" "Home" the folder icon to the
left of those; and the links for "Home, My Subscription, and Help".
But I do not see a link for "Site Settings".
And I do not see the Report Manager Toolbar, no Contents tab or
Properties tab, and no New Folder, no New Data Source etc.
I read somewhere that this might be due to the fact that IIS is
enabled with Anonymous Access turned on. But how do I check that?
And how do I turn it off?
Also, when publishing from Visual Studio, I get:
"The permissions granted to user <machine\userX> are insufficient for
performing this operation."
Also, when I open the Management Studio and connect to the Report
Server instance, I connect and see 3 folders (Home, Security and
Shared Shedules). But Properties is grayed for the instance, and if I
try to open any Roles or System Roles, I get 'permissions are
insufficient'.
I am connecting to the instance using Windows Authentication for
UserX, and UserX is a member of the Administrators group.
When I initially installed, I installed SQL Server DB and Reporting
Services at the same time and selected Mixed Mode and specified a 'sa'
password. The Built-In-Administrators do belong to the System
Administrator's role.
Any suggestions for where to look to be able to set permissions? Or
to be able to publish?
Thanks for any help.What edition of Windows Vista are you using? Only Business, Ultimate and
Enterprise.
It does sound like you have Anonymous Auth enabled on your web site since
by default only users in the Local Administrators group have full access to
report manager.
Check the following article and make sure you followed all the steps for
installing SRS on Vista.
http://support.microsoft.com/kb/934164
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MathewLeigh@.comcast.net
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Reporting Services permissions installation help
> Followup-To: microsoft.public.sqlserver.reportingsvcs
> I have installed Report Services 2005 Developer Edition on a Vista
> machine, along with SQL Server Database Engine 2005 Developer Edition.
> I am not able to perform some functions, apparently due to permissions
> but I do not know what to do.
> When I open the Report Manager via Internet Explorer 7, I see the top
> portion; "SQL Server Reporting Services" "Home" the folder icon to the
> left of those; and the links for "Home, My Subscription, and Help".
> But I do not see a link for "Site Settings".
> And I do not see the Report Manager Toolbar, no Contents tab or
> Properties tab, and no New Folder, no New Data Source etc.
> I read somewhere that this might be due to the fact that IIS is
> enabled with Anonymous Access turned on. But how do I check that?
> And how do I turn it off?
> Also, when publishing from Visual Studio, I get:
> "The permissions granted to user <machine\userX> are insufficient for
> performing this operation."
> Also, when I open the Management Studio and connect to the Report
> Server instance, I connect and see 3 folders (Home, Security and
> Shared Shedules). But Properties is grayed for the instance, and if I
> try to open any Roles or System Roles, I get 'permissions are
> insufficient'.
> I am connecting to the instance using Windows Authentication for
> UserX, and UserX is a member of the Administrators group.
> When I initially installed, I installed SQL Server DB and Reporting
> Services at the same time and selected Mixed Mode and specified a 'sa'
> password. The Built-In-Administrators do belong to the System
> Administrator's role.
> Any suggestions for where to look to be able to set permissions? Or
> to be able to publish?
> Thanks for any help.
>|||On Oct 9, 9:08 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> What edition of Windows Vista are you using? Only Business, Ultimate and
> Enterprise.
> It does sound like you have Anonymous Auth enabled on your web site since
> by default only users in the Local Administrators group have full access to
> report manager.
> Check the following article and make sure you followed all the steps for
> installing SRS on Vista.
> http://support.microsoft.com/kb/934164
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: MathewLe...@.comcast.net
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Reporting Services permissions installation help
> > Followup-To: microsoft.public.sqlserver.reportingsvcs
> > I have installed Report Services 2005 Developer Edition on a Vista
> > machine, along with SQL Server Database Engine 2005 Developer Edition.
> > I am not able to perform some functions, apparently due to permissions
> > but I do not know what to do.
> > When I open the Report Manager via Internet Explorer 7, I see the top
> > portion; "SQL Server Reporting Services" "Home" the folder icon to the
> > left of those; and the links for "Home, My Subscription, and Help".
> > But I do not see a link for "Site Settings".
> > And I do not see the Report Manager Toolbar, no Contents tab or
> > Properties tab, and no New Folder, no New Data Source etc.
> > I read somewhere that this might be due to the fact that IIS is
> > enabled with Anonymous Access turned on. But how do I check that?
> > And how do I turn it off?
> > Also, when publishing from Visual Studio, I get:
> > "The permissions granted to user <machine\userX> are insufficient for
> > performing this operation."
> > Also, when I open the Management Studio and connect to the Report
> > Server instance, I connect and see 3 folders (Home, Security and
> > Shared Shedules). But Properties is grayed for the instance, and if I
> > try to open any Roles or System Roles, I get 'permissions are
> > insufficient'.
> > I am connecting to the instance using Windows Authentication for
> > UserX, and UserX is a member of the Administrators group.
> > When I initially installed, I installed SQL Server DB and Reporting
> > Services at the same time and selected Mixed Mode and specified a 'sa'
> > password. The Built-In-Administrators do belong to the System
> > Administrator's role.
> > Any suggestions for where to look to be able to set permissions? Or
> > to be able to publish?
> > Thanks for any help.- Hide quoted text -
> - Show quoted text -
Chris,
Excellent! Thank you thank you thank you thank you!
The article was complete and detailed and gave me exactly the
information I needed. Thanks again!|||No problem.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MathewLeigh@.comcast.net
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Reporting Services permissions installation help
> Date: Tue, 09 Oct 2007 15:10:36 -0700
> On Oct 9, 9:08 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > What edition of Windows Vista are you using? Only Business, Ultimate and
> > Enterprise.
> >
> > It does sound like you have Anonymous Auth enabled on your web site
since
> > by default only users in the Local Administrators group have full
access to
> > report manager.
> >
> > Check the following article and make sure you followed all the steps for
> > installing SRS on Vista.
> >
> > http://support.microsoft.com/kb/934164
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> Chris,
> Excellent! Thank you thank you thank you thank you!
> The article was complete and detailed and gave me exactly the
> information I needed. Thanks again!
>|||I encountered exactly the same issue on my local Vista Ultimate with
Reporting Service installed at the same time when installing SQL2005
Developer, mixed mode with sa. Later on I added my local user name (already
in OS admin group) to the fixed SQL role as sysadmin. I following your
article step by step, added Trusted Sites, until #8. When I opened IE (run as
administrator) to opened the Report Manager, I still cannot see Properties at
the Home. Only Home, Subscriptions and Help are visible. Did I miss anything?
Thanks in advance.
Hugh
"Chris Alton [MSFT]" wrote:
> No problem.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > From: MathewLeigh@.comcast.net
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Re: Reporting Services permissions installation help
> > Date: Tue, 09 Oct 2007 15:10:36 -0700
> >
> > On Oct 9, 9:08 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > wrote:
> > > What edition of Windows Vista are you using? Only Business, Ultimate and
> > > Enterprise.
> > >
> > > It does sound like you have Anonymous Auth enabled on your web site
> since
> > > by default only users in the Local Administrators group have full
> access to
> > > report manager.
> > >
> > > Check the following article and make sure you followed all the steps for
> > > installing SRS on Vista.
> > >
> > > http://support.microsoft.com/kb/934164
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > >
> > >
> > >
> >
> > Chris,
> >
> > Excellent! Thank you thank you thank you thank you!
> >
> > The article was complete and detailed and gave me exactly the
> > information I needed. Thanks again!
> >
> >
>|||Hi Hugh ,
I am having the same problem using Vista Ultimate, SQL 2005 developer
edition and Report Server.
Did you resolve your issue?
I am following the article step by step no success. I do not see Site
Settings When I connect to the Report Server with Microsoft SQL Managment
Studio and right click on the server node the Properties are not available.
When I expand Home I am getting message
TITLE: Microsoft SQL Server Management Studi
----
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
The permissions granted to user 'ThePC\dimitre' are insufficient for
performing this operation. (rsAccessDenied) (Report Services SOAP Proxy
Source)
The permissions granted to user 'ThePC\dimitre' are insufficient for
performing this operation. (rsAccessDenied) (ReportingServicesLibrary)
Thanks
Mitko
machine, along with SQL Server Database Engine 2005 Developer Edition.
I am not able to perform some functions, apparently due to permissions
but I do not know what to do.
When I open the Report Manager via Internet Explorer 7, I see the top
portion; "SQL Server Reporting Services" "Home" the folder icon to the
left of those; and the links for "Home, My Subscription, and Help".
But I do not see a link for "Site Settings".
And I do not see the Report Manager Toolbar, no Contents tab or
Properties tab, and no New Folder, no New Data Source etc.
I read somewhere that this might be due to the fact that IIS is
enabled with Anonymous Access turned on. But how do I check that?
And how do I turn it off?
Also, when publishing from Visual Studio, I get:
"The permissions granted to user <machine\userX> are insufficient for
performing this operation."
Also, when I open the Management Studio and connect to the Report
Server instance, I connect and see 3 folders (Home, Security and
Shared Shedules). But Properties is grayed for the instance, and if I
try to open any Roles or System Roles, I get 'permissions are
insufficient'.
I am connecting to the instance using Windows Authentication for
UserX, and UserX is a member of the Administrators group.
When I initially installed, I installed SQL Server DB and Reporting
Services at the same time and selected Mixed Mode and specified a 'sa'
password. The Built-In-Administrators do belong to the System
Administrator's role.
Any suggestions for where to look to be able to set permissions? Or
to be able to publish?
Thanks for any help.What edition of Windows Vista are you using? Only Business, Ultimate and
Enterprise.
It does sound like you have Anonymous Auth enabled on your web site since
by default only users in the Local Administrators group have full access to
report manager.
Check the following article and make sure you followed all the steps for
installing SRS on Vista.
http://support.microsoft.com/kb/934164
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MathewLeigh@.comcast.net
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Reporting Services permissions installation help
> Followup-To: microsoft.public.sqlserver.reportingsvcs
> I have installed Report Services 2005 Developer Edition on a Vista
> machine, along with SQL Server Database Engine 2005 Developer Edition.
> I am not able to perform some functions, apparently due to permissions
> but I do not know what to do.
> When I open the Report Manager via Internet Explorer 7, I see the top
> portion; "SQL Server Reporting Services" "Home" the folder icon to the
> left of those; and the links for "Home, My Subscription, and Help".
> But I do not see a link for "Site Settings".
> And I do not see the Report Manager Toolbar, no Contents tab or
> Properties tab, and no New Folder, no New Data Source etc.
> I read somewhere that this might be due to the fact that IIS is
> enabled with Anonymous Access turned on. But how do I check that?
> And how do I turn it off?
> Also, when publishing from Visual Studio, I get:
> "The permissions granted to user <machine\userX> are insufficient for
> performing this operation."
> Also, when I open the Management Studio and connect to the Report
> Server instance, I connect and see 3 folders (Home, Security and
> Shared Shedules). But Properties is grayed for the instance, and if I
> try to open any Roles or System Roles, I get 'permissions are
> insufficient'.
> I am connecting to the instance using Windows Authentication for
> UserX, and UserX is a member of the Administrators group.
> When I initially installed, I installed SQL Server DB and Reporting
> Services at the same time and selected Mixed Mode and specified a 'sa'
> password. The Built-In-Administrators do belong to the System
> Administrator's role.
> Any suggestions for where to look to be able to set permissions? Or
> to be able to publish?
> Thanks for any help.
>|||On Oct 9, 9:08 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> What edition of Windows Vista are you using? Only Business, Ultimate and
> Enterprise.
> It does sound like you have Anonymous Auth enabled on your web site since
> by default only users in the Local Administrators group have full access to
> report manager.
> Check the following article and make sure you followed all the steps for
> installing SRS on Vista.
> http://support.microsoft.com/kb/934164
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: MathewLe...@.comcast.net
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Reporting Services permissions installation help
> > Followup-To: microsoft.public.sqlserver.reportingsvcs
> > I have installed Report Services 2005 Developer Edition on a Vista
> > machine, along with SQL Server Database Engine 2005 Developer Edition.
> > I am not able to perform some functions, apparently due to permissions
> > but I do not know what to do.
> > When I open the Report Manager via Internet Explorer 7, I see the top
> > portion; "SQL Server Reporting Services" "Home" the folder icon to the
> > left of those; and the links for "Home, My Subscription, and Help".
> > But I do not see a link for "Site Settings".
> > And I do not see the Report Manager Toolbar, no Contents tab or
> > Properties tab, and no New Folder, no New Data Source etc.
> > I read somewhere that this might be due to the fact that IIS is
> > enabled with Anonymous Access turned on. But how do I check that?
> > And how do I turn it off?
> > Also, when publishing from Visual Studio, I get:
> > "The permissions granted to user <machine\userX> are insufficient for
> > performing this operation."
> > Also, when I open the Management Studio and connect to the Report
> > Server instance, I connect and see 3 folders (Home, Security and
> > Shared Shedules). But Properties is grayed for the instance, and if I
> > try to open any Roles or System Roles, I get 'permissions are
> > insufficient'.
> > I am connecting to the instance using Windows Authentication for
> > UserX, and UserX is a member of the Administrators group.
> > When I initially installed, I installed SQL Server DB and Reporting
> > Services at the same time and selected Mixed Mode and specified a 'sa'
> > password. The Built-In-Administrators do belong to the System
> > Administrator's role.
> > Any suggestions for where to look to be able to set permissions? Or
> > to be able to publish?
> > Thanks for any help.- Hide quoted text -
> - Show quoted text -
Chris,
Excellent! Thank you thank you thank you thank you!
The article was complete and detailed and gave me exactly the
information I needed. Thanks again!|||No problem.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MathewLeigh@.comcast.net
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Reporting Services permissions installation help
> Date: Tue, 09 Oct 2007 15:10:36 -0700
> On Oct 9, 9:08 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > What edition of Windows Vista are you using? Only Business, Ultimate and
> > Enterprise.
> >
> > It does sound like you have Anonymous Auth enabled on your web site
since
> > by default only users in the Local Administrators group have full
access to
> > report manager.
> >
> > Check the following article and make sure you followed all the steps for
> > installing SRS on Vista.
> >
> > http://support.microsoft.com/kb/934164
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> Chris,
> Excellent! Thank you thank you thank you thank you!
> The article was complete and detailed and gave me exactly the
> information I needed. Thanks again!
>|||I encountered exactly the same issue on my local Vista Ultimate with
Reporting Service installed at the same time when installing SQL2005
Developer, mixed mode with sa. Later on I added my local user name (already
in OS admin group) to the fixed SQL role as sysadmin. I following your
article step by step, added Trusted Sites, until #8. When I opened IE (run as
administrator) to opened the Report Manager, I still cannot see Properties at
the Home. Only Home, Subscriptions and Help are visible. Did I miss anything?
Thanks in advance.
Hugh
"Chris Alton [MSFT]" wrote:
> No problem.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > From: MathewLeigh@.comcast.net
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Re: Reporting Services permissions installation help
> > Date: Tue, 09 Oct 2007 15:10:36 -0700
> >
> > On Oct 9, 9:08 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > wrote:
> > > What edition of Windows Vista are you using? Only Business, Ultimate and
> > > Enterprise.
> > >
> > > It does sound like you have Anonymous Auth enabled on your web site
> since
> > > by default only users in the Local Administrators group have full
> access to
> > > report manager.
> > >
> > > Check the following article and make sure you followed all the steps for
> > > installing SRS on Vista.
> > >
> > > http://support.microsoft.com/kb/934164
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > >
> > >
> > >
> >
> > Chris,
> >
> > Excellent! Thank you thank you thank you thank you!
> >
> > The article was complete and detailed and gave me exactly the
> > information I needed. Thanks again!
> >
> >
>|||Hi Hugh ,
I am having the same problem using Vista Ultimate, SQL 2005 developer
edition and Report Server.
Did you resolve your issue?
I am following the article step by step no success. I do not see Site
Settings When I connect to the Report Server with Microsoft SQL Managment
Studio and right click on the server node the Properties are not available.
When I expand Home I am getting message
TITLE: Microsoft SQL Server Management Studi
----
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
The permissions granted to user 'ThePC\dimitre' are insufficient for
performing this operation. (rsAccessDenied) (Report Services SOAP Proxy
Source)
The permissions granted to user 'ThePC\dimitre' are insufficient for
performing this operation. (rsAccessDenied) (ReportingServicesLibrary)
Thanks
Mitko
Reporting Services PageHeight & Pagewidth
Hi,
Is it possible to pass the pageheight and width through Url along with paramater to control report layout.
Kindly help!
Thanks,
Prabaharaprabu
Hello,
I don't think the page height or width are updateable, but you could check here. http://msdn2.microsoft.com/en-us/library/ms153586.aspx
Hope this helps.
Jarret
sqlMonday, March 12, 2012
reporting services in SQL server 2005 express edition
I want to know if reporting services are available in sql server 2005 express edition that is running along side visual web developer 2005 express edition because i cant see reporting services in the configuration tools. This is Urgent, that is of course if you have the time.
Thanks .
http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
"Reporting Services features are not yet available in SQL Server 2005 Express Edition."
|||
aus_nexxus:
http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
"Reporting Services features are not yet available in SQL Server 2005 Express Edition."
That is not correct Microsoft have now added advanced features for SQL Server Express which includes all but the Agent and database Mirroring with trade offs. Try the link below for details. Hope this helps.
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
|||So if Reporting Services features are not yet available in SQL Server 2005 Express Edition, does that mean i can not run reportviewer reports in remote proccessing mode.|||
So if Reporting Services features are not yet available in SQL Server 2005 Express Edition, does that mean i can not run reportviewer reports in remote proccessing mode.
It is available with the Advanced features download link I posted. Hope this helps.
|||Okay. So what happens to my applications database if i upgrade from sql server 2005 express edition to sql server 2005 express edition with Advanced services. I feel i need to enhance my reports with SQL server reporting services urgently.
Please remember that iam running the 2005 express edition with visual web developer 2005 express edition.
|||Nothing happens to your application you need to read what is in that link relevant to the advanced features. Hope this helps.|||Yes thanks. So help full|||
Nothing happens to your application you need to read what is in that link relevant to the advanced features. Hope this helps.
OH?
1. I had problems with User Instances..."could not create user instance..."
2. Ensured user instances was on in SQL Server...the app complained about user instances not supported.
3. Tried to run the ASP.NET Configuration tool against my application...it complains about user instances...
4. Uninstalled everything; reinstalled SQL Server Express with Advanced Features followed by VWD and Languages (as before)
5. It no longer complains about user instances...but it now tells me I have not created the security database that was created by default before and when I look in the apps folder...nada database...even my own is gone (thank goodness only a trial base) yet all my previously written files are there.
6. Based on 5 above, it tells me to run the command line utility called aspnet_sqlreg...when I look up the docs on this little gem, it says that it MUST NOT BE USED WHEN USER INSTANCES is enabled.
7. So here I sit, looking for help...find my issue quite quickly, only to fine a curt answer with links to features and stating...NO problems.
Nope. NO problems here!!!
Any more thoughts on this?
|||P.S. to my last post.
Sorry for being a Newbie, finding and exploring features I need/want.
|||
P.S. to my last post.
Sorry for being a Newbie, finding and exploring features I need/want.
No problem I am here to help, so here is the it is free but you need to this or it will not run list from Microsoft I knew there must be such list so go through it and let me know if you need more help.
http://msdn2.microsoft.com/en-us/library/ms365166.aspx
Subscribe to:
Posts (Atom)