Groups | Blog | Home
all groups > sql server reporting services > may 2007 >

sql server reporting services : Question about the Reporting Services interface


B. Chernick
5/29/2007 6:13:01 AM
I have been trying to develop my first report. One of the requirements is
that this be made available to the users with minimal permissions, i.e.
read-only. To that end I have set up a role that includes only the 'View'
tasks.

This appears to work as desired. However, so far the only way we have to
view the report is through the RS manager web page that comes with the
system. This caused my boss some confusion because the selection box and
Delete button in Details remain active in spite of the report's read-only
status. If a read-only user attempts to delete a report, he gets a visually
messy error message. My boss does not consider this good programming.

My question is this: Was this manager ever intended for general use or
should any major use of Reporting Services be accompanied by a home-grown
Bruce L-C [MVP]
5/31/2007 12:00:00 AM
When you bring up Report Manager are you seeing on the far right of the
toolbar Show Details or are you seeing Hide Details. I don't remember if I
had to configure anything to have Report Manager to default to the details
being hidden. If they are not hidden that would make it better for you. If
the details are hidden by default then I would not worry about this. I have
never had a user show the details. I have a wide range of users accessing my
reports: engineers, manufacturing operators, management, controllers
(accountants). I have casual once a month users and people that use it every
day and no one has ever had a problem with Report Manager being confusing
for them or them seeing and trying to delete a report. Indeed, if anyone has
ever even switched to detail view I have never heard about it.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Bruce L-C [MVP]
5/31/2007 12:00:00 AM
I am not aware of being able to disable this button. Does it default to
listview you want (mine does)?

Your boss has a choice, take what Report Manager gives which in my opinion
is just fine for general use or pay for a custom website that duplicates a
lot of the functionality.

Also, just an FYI. When you create subreports that the user does not access
directly, go to the properties for the report and click on the checkbox to
hide in listview.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


[quoted text, click to view]

Amarnath
5/31/2007 2:56:02 AM
You can achieve this in 3 ways
1. Through RM
2. URL access
3. Report View Control.

So in your context you can use URL and hide param and tool bar then it
should be ok.

Amarnath

[quoted text, click to view]
B. Chernick
5/31/2007 6:17:00 AM
I'm not sure I understand you.

[quoted text, click to view]
B. Chernick
5/31/2007 7:22:02 AM
That's just it. I cannot find anything in the options to disable the Show
Details/Hide Details button. (While I know it can't do any harm, my boss
wants it gone.)

[quoted text, click to view]
B. Chernick
5/31/2007 8:03:01 AM
I suppose I'll have to recommend a custom site to my boss. I'm afraid I'm
going to have to stand by what I said earlier. Displaying a non-functional
delete option looks like terrible programming to me.

[quoted text, click to view]
Bruce L-C [MVP]
5/31/2007 10:53:42 AM
If you do go with a custom site, the easiest way of dealing with this is to
have it on the same server as RS (otherwise you might have security issues)
and to utilize the new webform controls in VS 2005. Your web site should be
designed in 2.0 framework. Also, you definitely want to be on RS 2005 if you
are going to do this (the new webform control only works with RS 2005 and it
will make your job much much easier).


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button