Easy Admin Question

OK, As an Admin on the server, domain, SQL Server and Reportin
Services, when I log into the Report Manager website, I see the folder
"User Folders". I can navigate into that and see everyone's personal
"My Reports" folders.
Now, I have made a developer a Reporting Services Admin by adding him
to the RS Site Role of "System Admin" so that he can modify and
extract some user's reports that they saved in their My Reports
location.
For some reason he is unable to see the "User Folders" folder. I have
verified he is assigned to the System Admin role in RS so I'm unsure
what else I need to do to allow him to see the "User Folders" folder.
Any help anyone could provide is greatly appreciated!
Thanks in advance.
MartinSystem Administrator role does not include permissions to access catalog
items.
Quoting BOL (http://msdn2.microsoft.com/en-us/library/ms156470.aspx)
The System Administrator role is a predefined role that includes tasks that
are useful for a report server administrator who has overall responsibility
for a report server, but not necessarily for the content within it.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<martinghale@.gmail.com> wrote in message
news:1173921810.864000.92000@.n59g2000hsh.googlegroups.com...
> OK, As an Admin on the server, domain, SQL Server and Reportin
> Services, when I log into the Report Manager website, I see the folder
> "User Folders". I can navigate into that and see everyone's personal
> "My Reports" folders.
> Now, I have made a developer a Reporting Services Admin by adding him
> to the RS Site Role of "System Admin" so that he can modify and
> extract some user's reports that they saved in their My Reports
> location.
> For some reason he is unable to see the "User Folders" folder. I have
> verified he is assigned to the System Admin role in RS so I'm unsure
> what else I need to do to allow him to see the "User Folders" folder.
> Any help anyone could provide is greatly appreciated!
> Thanks in advance.
> Martin
>|||Thank you Lev,
So after reading that and messing around with all the settings, I was
finely able to get it working. Had to set permissions at the Folder
and Report levels so that I, as an Admin, could 'control' a user's
reports they created and stored in their My Folders location.
Thanks for the link. It helped in my understanding and tracking this
down.

Dynamic SQL Cells

How can I make the values for certain cells in a table in a database show the day a folder was created?

On the same note, How can I make other values in other cells change (say the values 101 through 200 had to change to 1-100)?

For the first part, you would have to explicily 'store' the "day a folder was created" in the field.

On the second part, if you wanted to subtract 100 from a current field value, and replace the current field value with that subtracted value, you would use a query similar to this one.

Code Snippet

UPDATE MyTable

SET MyColumn = ( MyColumn - 100 )

WHERE MyColumn BETWEEN 101 and 200

|||How am I supposed to "store" the day a folder was created in a field?|||

Well, somewhere, somehow, the folder was created. It was not created in SQL Server. SQL Server does not know anything about file folders UNLESS we tell give it a value and tell it to store the data.

So, unless your 'process' that creates the folders is smart enough to add that data to SQL Server, it will be left up to you to determine the creation date, and to add that creation date to a field in a table.

You haven't provided enough information to get the type of help that you are seeking. Perhaps if you were to provide a better description of what is happening and what you desire to accomplish, someone here 'may' be able to assist you.