Hi All,
I have a list of folders per department
i.e.
HR
Sales
etc
Each of these folders are assigned a group and have been given the default
role of browswer
However when the user logs into the reporting services site, they can see
all the folders - go into them however if they try to browse a report which
they do not have permissions to they get a Page cannot be dsiplayed error?
Surely there is a better way of doing this.
When my user goes into RS, I would either like them to see only the folder
they have been assigned to or at least not even be able to access the
folders at all that they have not been assigned to.
How do I do this.
Please help.
Thanks
KNot sure what you mean. If a user does not have access to an item on the
server, it will not display in Report Manager. Try removing all role
assignments from an item and see if they can see it.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kathy" <joe@.soap.com> wrote in message
news:poydnaDzeqHOL3rcRVn-pQ@.is.co.za...
> Hi All,
> I have a list of folders per department
> i.e.
> HR
> Sales
> etc
> Each of these folders are assigned a group and have been given the default
> role of browswer
> However when the user logs into the reporting services site, they can see
> all the folders - go into them however if they try to browse a report
> which
> they do not have permissions to they get a Page cannot be dsiplayed error?
> Surely there is a better way of doing this.
> When my user goes into RS, I would either like them to see only the folder
> they have been assigned to or at least not even be able to access the
> folders at all that they have not been assigned to.
> How do I do this.
> Please help.
> Thanks
> K
>sql
Showing posts with label folders. Show all posts
Showing posts with label folders. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Hide Breadcrumbs
My users access SQL reports via weblinks from a Sharepoint portal. Even
though they don't have backward access through the folders, they can still
hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
Thanks for the help
JDJD,
It sounds like you are copying the URL out of Internet Explorer and
making it the source of web part in SharePoint. There are actually
SharePoint web parts that have been provided by Microsoft for this. For
more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
If you want to keep using URLs, you can use the ReportViewer control to
open the report instead of opening a Report Manager URL. The Report
Viewer control does not show the report WITHIN Report Manager, so there
are no breadcrumbs.
With:
server name = goodwin
Report Server virtual directory = reportserver
report path = Production/Reports/
report name = Report1
The URL would look like this:
http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
To modify toolbar options, you can use some ReportViewer parameters.
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
Hope this helps!
-Josh
JDArsenault wrote:
> My users access SQL reports via weblinks from a Sharepoint portal. Even
> though they don't have backward access through the folders, they can still
> hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> Thanks for the help
> JD|||Josh,
Just what the doctor ordered!
Thanks
JD
"Josh" wrote:
> JD,
> It sounds like you are copying the URL out of Internet Explorer and
> making it the source of web part in SharePoint. There are actually
> SharePoint web parts that have been provided by Microsoft for this. For
> more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
> If you want to keep using URLs, you can use the ReportViewer control to
> open the report instead of opening a Report Manager URL. The Report
> Viewer control does not show the report WITHIN Report Manager, so there
> are no breadcrumbs.
> With:
> server name = goodwin
> Report Server virtual directory = reportserver
> report path = Production/Reports/
> report name = Report1
> The URL would look like this:
> http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
> To modify toolbar options, you can use some ReportViewer parameters.
> http://msdn2.microsoft.com/en-us/library/ms152835.aspx
> Hope this helps!
> -Josh
>
> JDArsenault wrote:
> > My users access SQL reports via weblinks from a Sharepoint portal. Even
> > though they don't have backward access through the folders, they can still
> > hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> >
> > Thanks for the help
> >
> > JD
>
though they don't have backward access through the folders, they can still
hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
Thanks for the help
JDJD,
It sounds like you are copying the URL out of Internet Explorer and
making it the source of web part in SharePoint. There are actually
SharePoint web parts that have been provided by Microsoft for this. For
more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
If you want to keep using URLs, you can use the ReportViewer control to
open the report instead of opening a Report Manager URL. The Report
Viewer control does not show the report WITHIN Report Manager, so there
are no breadcrumbs.
With:
server name = goodwin
Report Server virtual directory = reportserver
report path = Production/Reports/
report name = Report1
The URL would look like this:
http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
To modify toolbar options, you can use some ReportViewer parameters.
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
Hope this helps!
-Josh
JDArsenault wrote:
> My users access SQL reports via weblinks from a Sharepoint portal. Even
> though they don't have backward access through the folders, they can still
> hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> Thanks for the help
> JD|||Josh,
Just what the doctor ordered!
Thanks
JD
"Josh" wrote:
> JD,
> It sounds like you are copying the URL out of Internet Explorer and
> making it the source of web part in SharePoint. There are actually
> SharePoint web parts that have been provided by Microsoft for this. For
> more info, go to http://msdn2.microsoft.com/en-us/library/ms159772.aspx
> If you want to keep using URLs, you can use the ReportViewer control to
> open the report instead of opening a Report Manager URL. The Report
> Viewer control does not show the report WITHIN Report Manager, so there
> are no breadcrumbs.
> With:
> server name = goodwin
> Report Server virtual directory = reportserver
> report path = Production/Reports/
> report name = Report1
> The URL would look like this:
> http://goodwin/reportserver/Pages/ReportViewer.aspx?/Production/Reports/Report1
> To modify toolbar options, you can use some ReportViewer parameters.
> http://msdn2.microsoft.com/en-us/library/ms152835.aspx
> Hope this helps!
> -Josh
>
> JDArsenault wrote:
> > My users access SQL reports via weblinks from a Sharepoint portal. Even
> > though they don't have backward access through the folders, they can still
> > hee the breadcrumbs. How do I hide the breadcrumbs to the folder heirarchy?
> >
> > Thanks for the help
> >
> > JD
>
Subscribe to:
Posts (Atom)