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

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

access row group total from row details?

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server
I need to access the total value for a row group from the row detail cells, how can I do this? 

Javier Guillen

View Complete Post

More Related Resource Links

Problem with access to a user in AD group

Hi all, We are managing our security in Sharepoint (WSS 3.0) with AD groups instead of Sharepoint groups. This worked fine until now. For an unknown reason, one single user from an AD group cannot access a page (while other users from the same group can). The group is also a distribution list in AD (so it's a security group and distribution list for emails). It includes several other distribution lists such as: L-All-Corporate-Employees    L-Administration          User 1          User 2           ...     L-Accounting         User 1         ... ...   So far I never had any issue with that kind of approach,  but yesterday we published a new web part page and wanted only the corporate employees to get access to it, so I broke rights inheritance on the page and added the L-All-Corporate-Employees group with View rights. As I already said, I tested with one user from the group (let's say from the L-Administration sub-group) and it works, now I receive an email from another user (let's say from the L-Accounting sub-group) which tells me he doesn't have access... But they're all part of the L-All-Corporate-Employees group, so they should all

SharePoint 2007 to Access 2007 - Issues grouping by "Person or Group" field type/column

We are on SharePoint 2007 and using Access 2007.  The SharePoint list contains a column called Assigned Person, column type: Person or Group, single selection, displaying only the name 1) When we Open with Access and Export a copy of the data, then create a report from that table, we do not have the option to group on Assigned Person.  2) When we Open with Access and Link to data on the SharePoint site, then create a report from that list, when we group by Assigned Person... The same person has 2 groups - there are is no other grouping or sorts on the list, and i can't locate a correlation to another field to show why they would have to collections for the same person The Person or Group column sorts "from smallest to largest" as though it is a number field. The list is a task/activity tracking system we created custom for our needs.  We want to pull a weekly report, grouped by Assigned Person, but cannot get access to work.  We do not want to resort to anything more complex, as it takes a much longer process to have reports pulled by Chrystal or one of those types of applications.  And we cannot change out the field for something like a Choice column as the list already has a very large amount of content.  Can anyone assist? Is there a setting hiding somewhere that is causing the problem? 

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  

How to access and cutomize group row in a grouped SPgridView

hi all! Is there any way to access and cutommize the grouped row of an SPGridView  --This is the row that display grouped value ! I can access all other row types such as : header row, datarow, footer row.. but i do not know to to access and custommize the grouped row... here the example code:This code set all value of all cell in SPgridView to "ABC"  when binding to datasource except grouped row     public void Rowdatabound(object sender, GridViewRowEventArgs e) {   foreach (TableCell cell in e.Row.Cells) {    cell.Text = "ABC"; }     }      

restrict access for a single group to a single folder in a list


Hello and Goodmorning,

I have one list, organized with 3 folders.

I can create a group(s), add user(s) to this group(s). 

Now i need to assign access like this:  group1 can only see and 'readonly' folder1, group2 can only see and 'readonly' folder2, group3 can only see and 'readonly'...folder3!

Im sure this is possible, from similar non-programming posts on the forum.

I have been looking into SPRoleAssignment and SPRoleDefinition to define Group permissions but its the mapping them to specific folders that I am missing...

Enjoy your tea.







Grant access to the NT 'Everyone' group


Hi all

Dumb question (and an obvious one on top of that) - How do I add the 'Everyone' NT group to site visitors in SharePoint 2010 ?



Get the user details based on the group


I am getting the details from groups but some groups have data but did not return any data is there any problem with this code. some groups have returned data .

CN=Tets App_Reviewer,OU=Tets Appl Groups,OU=District Wide Groups,DC=tets,DC=com;

Tets App_Reviewer is  the group name

public List<ADUserDetail> GetUserFromGroup(String groupName)
            List<ADUserDetail> userlist = new List<ADUserDetail>();


                _directoryEntry = null;

                DirectorySearcher directorySearch = new DirectorySearcher(SearchRoot);

                directorySearch.Filter = "(&(objectClass=group)(SAMAccountName=" + groupName + "))";

                SearchResult results = directorySearch.FindOne();

How to get group count and total count using one select statement?


How to obtain the resultset using one select statement?


Table 1







How to get the permissions of a user or group that has "Limited Access" to a site



For a user or group that has "Limited Access" to a site, I'd like to be able to find all of the libraries, documents, etc that that user or group has been given permissions to.  I believe that I could accomplish this by iterating over all of the lists of the site, and then over all of the list items of each list, and checking if, for that list or list item, inheritance is broken and that user or group has been granted access.  However, I am hoping there is a cleaner, quicker alternative in which I don't have to iterate over all of the site content.

If that's not possible, I may be able to accomplish mostly what I need if I could find all of the site content which has unique permissions (and then simply iterate over that content to see if the user or group has been given permissions).

Any advice is greatly appreciated.




Add total in group footer for calculation with multiplication and sum

Not sure if the topic title clarifies my problem correctly but this is what I'm trying to achieve:
I have a simple report, an overview of different projects grouped by accounts. Every project shows the revenue, the costs and the profit.
I want to have a total of all 3 colums, both in group footer as in the table footer. I know how to do a simple Sum(Fields!revenue.Value) but my calculation is a bit more complicated:


Basicly this adds up: Transportation cost (km*cost/km) + Preperation cost + Project Cost + Multiple other costs
The formula itself works perfectly.

Now when I have 3 projects with an account, I want to know the total. I've tried the following:
- =Sum(Formula)
- =Sum(km*cost/km) + Sum(Preperation cost + Sum(Project Cost) + Sum(MultipleOtherCosts)
- =Sum(ReportItems!textbox2.Value)

But either I get errors, or the total is incorrect because of the multiplication. The problem is I need to mulitplie km*cost/km first and not Sum(km)*Sum(Cost/km) because than the total is incorrect.

Is there someone who sees a solution for my problem?


Restict access to page fields. How to show field value to members of certain group?


I have the fields that should be shown for members of one group. How to implement this behavior?

Also i need to restrict access to editing other field for all except of limited amount of persons. How to do this?


All these questions are related to Site Content Types and Page Layouts.

Need a group total for an expression result NOT from the elements value


Simple question and still new to SSRS 2005.  Did a bit of Crystal reports before.


I have created a bit of code that returns a 0 or a 1 in a column based on a text evaluation as I could not get IIF to behave for me.  But either way the textbox displays the 0 or the 1 if the result is true.


I want to sum up the results, but I cannot seem to find the proper name for the text box to use in a =sum(textbox38) sort of statement.


So I have a couple columns like this


talked to customer estimate given      1   0

talked to customer estimate accepted   0   1


I need to count up those 0 and 1s in the footer so I know how many estimates went out and how many were accepted




How can I create link table in an Access DB for a group permission in SharePoint?



I move all the tables to SharePoint site using "Move To SharePoint" button.  When it finished, access create additional link table called "User Information List"  However, I need a site owner permission list in my access table link(Not User Information List-it has too many list).

Can anyone help me, please?


User has access but is not a member of any group


Help!  I have a user that access to all of the content in my site even though he has been restricted for certain lists and for certain items within the list.  

To troubleshoot the issue, I have removed him from all security groups in the site.  He should have no access to anything in the site or any lists.  He can still see the items.  And when I click on a list item and check his permissions, here's what I see.  What do I need to do now?  Where is he getting all these extra permissions?


p.p1 {margin: 5.0px 0.0px 5.0px 0.0px; font: 14.0px 'Times New Roman'} p.p2 {margin: 5.0px 0.0px 5.0px 0.0px; font: 12.0px 'Times New Roman'; min-height: 15.0px} p.p3 {margin: 5.0px 0.0px 5.0px 0.0px; font: 12.0px 'Times New Roman'} table.t1 {border-collapse: collapse} td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb; padding: 0.0px 5.0px 0.0px 5.0px}

Permission levels given to Matthew (domain\matt) 




The followi

Create Sites of different Departments and give the access rights on the sites according to the Group



I have to create sites for the departments like( IT, Admin, Payroll, HR and so on...) and these sites should be in the top link bar and according to the user's group or profile the above departments should be visible on the top link bar.

I want to use same URL but for different groups top link bar of the departments should be visible.

Example:in the top link bar HR department should be visible only for the HR. and If i create a group that can see the two departments then two department should be visible in the top link bar.

Thanks and Regards




Group Total in Footer (SSRS)



I am using SSRS and have a group named "G_Invoice" . In the footer I need to total the group's total. I used the following lines

=Sum( Fields!InvoiceAmount.Value ,"G_Invoice") in the textbox .

I also tried

=RunningValue(Fields!InvoiceAmount.Value ,sum,"G_Invoice")

In both the cases, it shows an error


The Value expression for the textbox ‘textbox27’ has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.


How to achieve it?





Cannot access Site usage details in mysite


Hi All,

I am facing a strange issue. I am not able to access site usage details under site adminstration or under site collection administration in my mysite. I am having the site collection administartor rights. When I am looking at the logs I am finding this :

Access Denied for /MyID/_layouts/usageDetails.aspx. StackTrace: Microsoft.SharePoint.Utilities.SPUtility:Void HandleAccessDenied(System.Exception), Microsoft.SharePoint.SPGlobal:Void HandleUnauthorizedAccessException(System.UnauthorizedAccessException), Microsoft.SharePoint.Library.SPRequest:System.Object GetWebUsageData(System.String, System.String, System.String, System.Guid, Int32, Int32, Int32, System.DateTime), Microsoft.SharePoint.Administration.SPUsage+UsageDetailsInfo:Void .ctor(Microsoft.SharePoint.SPWeb, Microsoft.SharePoint.Administration.SPUsageReportType, Microsoft.SharePoint.Administration.SPUsagePeriodType, Int32, System.DateTime), Microsoft.SharePoint.SPWeb:System.Data.DataTable GetUsageData(Microsoft.SharePoint.Administration.SPUsageReportType, Microsoft.Shar...

Any Help in this regard is highly appreciated.

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