Adding multiple role assignments all at once

Is there a way to add multiple role assignments to a report definition all at once?

Instead of going to the Report Manager, selecting each individual report definition, and then clicking on "New Role Assignment" multiple times to add users, is there a way to add multiple users all at once?

You can write a script and use rs.exe.

Here is a pointer to the tool. There should also be information for example scripts.

http://msdn2.microsoft.com/en-us/library/ms162839.aspx

adding commas into integer

while selecting the field, I want it to be display with commas.
for example,
10000 become 10,000
without decimal placed at the end.
I have tried using smallmoney format but there is decimal places.Take a look at DECIMAL datatype
"dapdap" <dapdap@.discussions.microsoft.com> wrote in message
news:22FBBC46-4B9D-4377-A806-D4D79EE81013@.microsoft.com...
> while selecting the field, I want it to be display with commas.
> for example,
> 10000 become 10,000
> without decimal placed at the end.
> I have tried using smallmoney format but there is decimal places.|||Formatting is controlled by your client application, not by SQL Server. Ask
this question in a forum for the app or programming language you are using.
Certainly you could get SQL to return a string instead of a number but why
would you want to do that with the obvious divantages for performance,
complexity and special handling at the client?
David Portas
SQL Server MVP
--
"dapdap" wrote:

> while selecting the field, I want it to be display with commas.
> for example,
> 10000 become 10,000
> without decimal placed at the end.
> I have tried using smallmoney format but there is decimal places.|||>> selecting the field, I want it to be display with commas. <<
Let's get back to the basics of an RDBMS. Rows are not records; fields
are not columns; tables are not files. In a tiered architecture, the
display formatting is done in the front end and never in the database.
A good SQL programmer avoids proprietary datatypes.