delete a security group via the database

We have recently moved buildings at work and have gone from 2 domains to 1
domain. Now when i try and edit the security permission in the properties of
a report i get:
The user or group name 'carfax\domain users' is not recognized.
(rsUnknownUserName) Get Online Help
iis there any way to delete these at a database level or get round this at
all as i need to enable some of our users the functionality to subscribe to
reports and unless i can delete this it will be impossible to do.
Would i need to completely uninstall reporting services fix this problem?I am looking at scripting the deleting of this security group, would this be
the best way to go and could anyone give me any pointers?
Any help would be greatly appreciated
"Shaun Longhurst" wrote:
> We have recently moved buildings at work and have gone from 2 domains to 1
> domain. Now when i try and edit the security permission in the properties of
> a report i get:
> The user or group name 'carfax\domain users' is not recognized.
> (rsUnknownUserName) Get Online Help
> iis there any way to delete these at a database level or get round this at
> all as i need to enable some of our users the functionality to subscribe to
> reports and unless i can delete this it will be impossible to do.
> Would i need to completely uninstall reporting services fix this problem?
>|||I have also looked through the users and policy user role tables and cannot
find the invalid user anywhere.
Still pulling my hair out trying to sort this issue.
"Shaun Longhurst" wrote:
> I am looking at scripting the deleting of this security group, would this be
> the best way to go and could anyone give me any pointers?
>
> Any help would be greatly appreciated
>
> "Shaun Longhurst" wrote:
> > We have recently moved buildings at work and have gone from 2 domains to 1
> > domain. Now when i try and edit the security permission in the properties of
> > a report i get:
> >
> > The user or group name 'carfax\domain users' is not recognized.
> > (rsUnknownUserName) Get Online Help
> >
> > iis there any way to delete these at a database level or get round this at
> > all as i need to enable some of our users the functionality to subscribe to
> > reports and unless i can delete this it will be impossible to do.
> >
> > Would i need to completely uninstall reporting services fix this problem?
> >
> >

Defining custom column groups on a matrix report in report builder

I have table called Buildings which has market and sq. ft information.
I want to create a matrix report that has the market as the row group and
sq. ft ranges as the column group and shows the # of buildings in each
market that fall in the sq. ft ranges.
Sq. ft ranges are 0-5000, 5001-10000 etc...
My questions is a) is this something that can be done using report builder
b) how do i define the sq. ft ranges
c) how do I find the count of buildings whose sq. footage falls within the
range.
ThanksOn Nov 14, 1:18 pm, "shikarishambu" <shikarishamb...@.hotmail.com>
wrote:
> I have table called Buildings which has market and sq. ft information.
> I want to create a matrix report that has the market as the row group and
> sq. ft ranges as the column group and shows the # of buildings in each
> market that fall in the sq. ft ranges.
> Sq. ft ranges are 0-5000, 5001-10000 etc...
> My questions is a) is this something that can be done using report builder
> b) how do i define the sq. ft ranges
> c) how do I find the count of buildings whose sq. footage falls within the
> range.
> Thanks
A) Yes
B) In your Datasets window, right-click on the name of the dataset and
Add a new field. Call it "Sq Foot Range" and make it a calculated
field. Use an expression like
= Fields!SqFoot.Value - Fields!SqFoot.Value Mod 5000
Since you are shifting your range to include the evenly divided number
in the lower group, you really want
= CStr( ( (X-1) - (X-1) Mod 5000 ) + 1 ) & " to " & CStr( ( (X-1) -
(X-1) Mod 5000 ) + 5000 )
C) Create a Matrix with a Market in the Row Group, Sq Foot Range in
the Column Group, and Count( Fields!SqFoot.Value ) in the Details.
Hope that helps.
-- Scott