.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

report and domain group

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server

Good day.

Is it possible to make a report parameter, which get his values from Domain Group?

Best Regards,


View Complete Post

More Related Resource Links

User Profile Service - "The specified user or domain group was not found"

Hi there, I had configured the User Profile Service and all was working well (Syncing with AD etc.). However, something has gone wrong. The services still appear to be running; both Forefront Identity Manager services are running, and the services show as 'Started' in Central Administration. The 'My Profile' and 'My Site' options have disappeared though, and browsing to the My Sites page results in an error (Could not load user profile). To make matters much worse, it seems to have also broken the Central Administration site. If I try and go to 'Manage Service Applications' I get another error (The specified user or domain group was not found). This error seems to come up on around half of the pages on the Central Administration site. Looking up the error (abb6b174-0f71-413a-a27a-41cdc87b66d0) in the logs I find this: 09/06/2010 15:35:45.44  w3wp.exe (0x0868)                        0x06A0 SharePoint Portal Server       User Profiles                  cm6y High     User Profile Application Proxy failed to retrieve partitions from User Profile Application: Microsoft.Office.Server.UserProfiles.UserProfileA

Creating Dynamic Group Fields for a Crystal Report?

I have a VB.Net application which generates quite a few Crystal Reports. One report in particular has a Group Section. What I am trying to do with my VB.Net app is pass a value (a sql server column name used in the report). This value is represented by radio buttons. For example, the user may check either "ZipCode" or "State" or "Category" or "Type" or "Vendor". Each of these options represent a column in the database table used in the report. I simply want to be able to write the "SelectionFormula" using one of these options but not sure how to go about it. Thanks, Blake

SSRS Report Group Total

I am trying to make a report in SSRS with Data source CUBE. I have a column which is calculated and inside the group. I could not take group total for that item. Please any guide my calculated column expression is =(Fields!Count_of_Passengers.Value/Sum(Fields!Count_of_Passengers.Value, "LHSH"))*100  

Error: The specified user or domain group was not found.


Hi all,

So I am having this issue with SharePoint Central Administration. I am not able to get into many of the services within CA due to the above error. I have narrowed it down (I'm almost positive) to a user who was an administrator on the managed metadata service and is no longer with us and was removed from the AD. I have asked to have the account added back in, of course, we don't have the SID history. It was added and I used the stsadm cmdlet migrateuser -ignoresidhistory and I get the same exact error. I've tried this logged on as several diffeerent administrators including the domain administrator account and have received the same error.

Anyone have any ideas?


in crystal report i need to print each group in new page



i have one problem in crystal reports

i want print  group details ,for each group it should print in new page.

some thing like this




Transaction Number                Date                           Amount                           Remarks

   1111                                   10/1/2007                    300.00                                 JE999

   2222               &nb

report not visible in chrome/safari if row group is used


I am just getting started with SSRS (using 2008R2), and find that my reports, after deployment, show up empty (blank) when viewed in chrome or safari (windows). IE(8), FF and Opera work fine.

A simple table report (no grouping, etc) displays fine in all browsers, but if I add a row group, the data disppears from Chrome and Safari. The report page navigation is still present and has the right number of pages, but all display blank. Saving the report as PDF or Word file still works, so this appears to be an HTML or Javascript problem.

Is this a known problem and if so, is there a work around?



Group report splitting into multiple pages Need it in 1 page


1) Few of my group reports which have more than 500 rows are splitting into many pages without column header. (eg, page 1, page 2... etc.) I would like configure it to be in one page however large it may be.

2) I tried setting column header in group reports which are splitting into multiple pages but its not working.

Either I need achieve point 1 or point 2

Could you please help me how to achieve it?


Sum Issue in Group Footer and report Footer


In attached SSRS 2005 report i am grouping by date and within date i'm showing acconuts.
In group footer i'm trying to do sum depends on TYPE field.
For Receipt Column
=IIf((Fields!Type1.Value= "R"),Sum(Fields!Amount.Value),"")
For Disbursement Column
=IIf((Fields!Type1.Value= "D"),Sum(Fields!Amount.Value),"")

But report is putting sum either in RECEIPT or in DISBURSEMENT column depends on whatever record is 1st.

For Receipt Column in report footer
=IIf((Fields!Type1.Value="R"), Sum(Fields!Amount.Value), "$0.00")
For Disbursement Column in report footer
=IIf((Fields!Type1.Value="D"), Sum(Fields!Amount.Value), "$0.00")

Same way page footer is not showing the correct value.
Instead of $257673.61, it should have been 257673.61-9340-2875.98 = $245457.63
And Disbursement column in report footer instead of $0.00 it should be $12215.98
Any Suggestions what i'm doing wrong here.


Group headers of the main report are not repeating when used with subreports


Hi all,

  I have a SQL server 2008 report which has a main report and 2 subreports embedded. Each of the subreports are placed under a main group and the group headers of the main header are made to repeat with RONP property and Keep together properties set to true. If the subreport's data fits in one page the group headers are repeated. But when the subreport's data spans to more than one page the group headrs of the main report are not repeated. Please let me know if there is a workaround to achieve the same. I have tried putting the group headers in the page header, but this approach does not work fine. Please let me know if this can be achieved using coding.



Getting "A domain group is missing for one or more services" error when adding new node to existing


Hey all,

Current configuration:

2-node sql 2005 cluster

windows 2003 enterprise R2 w/ sp2 x64

sql 2005 enterprise x64 SP3


In the process of adding a third node into the existing 2-node cluster, we received the

"A domain group is missing for one or more services.  To install SQL 2005 as a failover cluster, domain groups must be specified for all the clustered services bing installed. To proceed, enter the missiong domain group information." 

The existing cluster functions properly and has been running w/o problems for a long while now.  An AD Global Group was created to support the cluster back when the cluster was initially created.


I found different suggestions from people online about this issue, any where from adding registry keys to take trailing blank space from sql resource group name, but none works. 


Any ideas?


Thank you in advance for any assistance.



Report Builder 3.0 renders empty page for Reports with Matrix (column group) in Landscape orientatio


I need some help.


If I create a Report with a Matrix Tablix (with row Groups and column groups) in landscape layout and preview it in print layout, the report generates me some extra empty page every 2nd page.

I don't understand the rule, why it's doing that.


My Report settings are:

  • PageSize: width: 29.7 cm, height: 21 cm
  • InteractiveSize: width: 29.7cm, height: 21 cm
  • Margins : 0cm,0cm,0cm,0cm
  • Report Body : widht: 25cm, height: 10cm

According my Report settings this shouldn't happen, should it. The width of my Tablix is max 22cm.

What I noticed is, that when I shrink the width of my Report Body to 21 cm (to the width of the portrait layout) or less, the emtpy pages disappear.

Or when I delete the column group, it also renders the report without some empty pages.

I think this problem has something to do with column groups.


Is this a bug or am I missing a setting?

Domain Group Policy to Map user folder in Sharepoint Library to network drive


This is complicated- and try as I might I can't get it right. I am running SBS 2008 SP2 with WSS 3.0 SP3.

I have my sharepoint site at http://companyweb. I have WebClient and WebPublishing services enabled.

The scenario I am trying for:

I have a document library in Sharepoint called Wellness Boxes. Inside this library each domain user has a folder- these folders are to store personal files. Each folder is configured with permissions via Sharepoint so that only the user and their direct manager has access. When a user enters the library, they only see their own folder.

I am trying to map this situation to network places. I want users to be able to click Start>Computer>Network and see a drive labeled Companyweb. Entering that drive will show them the document library Wellness Boxes, and only their own folder will be visible.

I need to do this at a domain level through Group Policy so it applies to all users and all computers. Drive letters do not matter. Permissions do matter.

Can anyone help me please?


Blog@ http://chrisdill.wordpress.com

Christopher Dill Network Engineer | Solace Healthcare Group, Inc. SBS 2008 | Exchange 2007 | WSS 3.0

Reporting Services 2005 - Scatter Report Unable to show category group



  I am using scatter chart to create some sort like


Quantity  Time  Machine Name

12 2010-09-10 04:21:11         M1

22 2010-09-10 19:21:11  M1

100 2010-09-11 05:21:11  M1

89 2010-09-11 07:21:11  M1


66 2010-09-12 07:21:11  M2

18 2010-09-13 07:21:11  M2


68  2010-09-12 07:21:11  M3


X-axis show me the quantity, Y-axis shows me the time and then machine name group its time and qty under different category group. How to make it.

I have tried to use scatter chart to display but I can only see the X and Y -axis and without category group shown...  

Infopath Question: XPath code to remove domain name from AccountID field in Person/Group Picker


I have an infopath email based submission form where I am using the Person/Group picker as a way for people to find people in the active directory to CC the form to. I was using the field "DisplayName" in the control and discovered that when you try to CC several employees, that it would disrupt the rules and you can't send the form.

I want to use the field "AccountID" but it includes the domain before the email alias (for ex. REDMOND\johndoe). Is there a formula code I could use to remove the domain from every email alias. Right now my CC formula is concat(SubmitterAlias, "; ", DisplayName)

Sql 2008 on Windows 2008 domain error: windows nt user or group not found

I am running sql 2008 R2 and win 2008 R2 and simply trying to add a new domain user into sql, but I get the error above. What's weird is that when I do a check names from the add user or group window it finds the account I want to use. I've tried adding a different account, but I get the same issue--so its not the account. I've also tried running the create login t-sql command but it gives the same error. I've also tried disabling, via the gpedit.msc tool, the digitally encrypt or sign secure channel keys. But that did not work either.

MDX Query runs endless if the User is not a member of the Domain Admin Group


Please, before you say "its not possible" read my post. Myself, i couldnt believe it, until i saw the behaviour with my own eyes.
Environment: SSAS 2005, tested with a MDX Query executed in the SQL Server Management Studio.

We deliver a CUBE (SSAS 2005) that we have build for our Billing System (SQL 2005). Nothing tricky on the cube definition. The cube is installed on several customer systems, runs without a problem. On our in-house test server it runs with no problem. I can execute the same MDX Query connected as a User who is a Member of the Domain Admins and with a User who is a "simple" Domain User. The same query performance, the same Resultset, experienced in-house and by many of our customer.

But on the system of one of our customer i have a really strange behaviour. If i connect on the SQL Management Studio with a User that is in the Domain Admin Role (let's call it user "A") the same MDX Query that we use in-house runs without a problem. But on the customer system i cant execute the MDX Query with a User that is not a Member of the Domain Admin Role (let's call this user "B").
The simple Domain User "B" starts the SQL Management Studio and connects to the Analysis Services Instance. No error. In the SQL Management Studio, on the left pane it has the same metadata, dimensions and members

Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend