Adding new web.config custom section

Hello All,
I want to add custom cofiguration section to the report server web.config
and use this configuration from the RDL, can it be done? and if the answer is
yes, how it can be done.
Thank youOn Oct 7, 1:21 pm, Shlomi <Shl...@.discussions.microsoft.com> wrote:
> Hello All,
> I want to add custom cofiguration section to the report server web.config
> and use this configuration from the RDL, can it be done? and if the answer is
> yes, how it can be done.
> Thank you
You might be able to reference the Web config file from custom code in
the report (via: Layout view >> Report drop-down >> Report
Properties... >> Code tab). You might be able to reference it via a
call to Configurations.AppSettings(...). Of course this is a long
shot. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||thank you,
i will be thankful if you can give me an example f custom configuration
section for the web.config
"EMartinez" wrote:
> On Oct 7, 1:21 pm, Shlomi <Shl...@.discussions.microsoft.com> wrote:
> > Hello All,
> >
> > I want to add custom cofiguration section to the report server web.config
> > and use this configuration from the RDL, can it be done? and if the answer is
> > yes, how it can be done.
> >
> > Thank you
>
> You might be able to reference the Web config file from custom code in
> the report (via: Layout view >> Report drop-down >> Report
> Properties... >> Code tab). You might be able to reference it via a
> call to Configurations.AppSettings(...). Of course this is a long
> shot. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Adding Multiple Users to Database

In the users section of a database, I can select multiple users and
delete them from being able to access the DB in one keystroke (or so).
Can I do the reverse? If I deleted everyone, is there an SP or a
location that I can select multiple users and grant them access to the
DB quickly?
Thus far, all I've found is to select each user one at a time and give
them "public" access to the database.
(It's a good thing we are not a big company! I tried to restrict
access to all but a couple users to a particular DB only to discover
that I had the wrong DB selected. I had to add each user back in
manually.)
Thanks!
-TimothyConsider using NT group membership to the database.
See sp_grantdbaccess in Books Online;
sp_grantdbaccess
Adds a security account in the current database for a Microsoft SQL
Server login or Microsoft Windows NT user or group, and enables it to be
granted permissions to perform activities in the database.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Adding footer of matrix reporting service

Hi EMartinez ,
A matrix table object cannot have a footer but if someone needs to put totals for all rows, he needs to right-click on the section of matrix table where it says "Rows" and then click "Subtotal" option. This would add a new row in the end of matrix table and bring totals automatically - no extra work needed.
I think you are talking about a simple data table object - yes that has this option.
thanks,
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.comOn Sep 6, 10:38 am, Ratan Udassi wrote:
> Hi EMartinez ,
> A matrix table object cannot have a footer but if someone needs to put totals for all rows, he needs to right-click on the section of matrix table where it says "Rows" and then click "Subtotal" option. This would add a new row in the end of matrix table and bring totals automatically - no extra work needed.
> I think you are talking about a simple data table object - yes that has this option.
> thanks,
> EggHeadCafe - .NET Developer Portal of Choicehttp://www.eggheadcafe.com
Actually, what you are referring to is the same thing that I was
explaining.
Regards,
Enrique Martinez
Sr. Software Consultant