SQL Reporting :: Group Two Detail Tables In A Report With Groups?
Jul 3, 2010
I have a table with a field "item id" that I am joining to two other tables that have multiple records for each item id. In other words, I have 1 item id, 5 records in another table tied to this item and 5 records in another table tied to this item. I am trying to build a report that shows the item and then follow the item with two groupings. Each group would of course have the 5 records per the other two tables. Here is my problem. I can get the report to show an item and one of the detail group of 5 records but for the life of me I cannot get the second group of 5 to group and print. Both groups of 5 get either lumped together or it will print them 1 record at a time switching back and forth. How do you do this? Do I have to do something special in the Sql query or something.
I have three tables in my RDLC report.Each table is having table header.Problem is when I run RDLC report,the first tabl's header is scrolling but not scrolling other two tables headers when I am trying to scorll.
I have a select query which is executing well. Now, I want to add one more field to that query. That field is not in the current query table, It is in the another table.
How do I join those two tables and get that field value in the existing select query.?
I have an ASP.NET 3.5 application using Windows Authentication and implementing our own RoleProvider.
Problem is we want to restrict access to a set of pages to a few thousand users and rathern than inputing all of those one by one we found out they belong to an AD group.
The answer is simple if the common group we are checking membership against the particular user is a direct member of it but the problem I'm having is that if the group is a member of another group and then subsequently member of another group then my code always returns false.
For example: Say we want to check whether User is a member of group E, but User is not a direct member of *E", she is a member of "A" which a member of "B" which indeed is a member of E, therefore User is a member of *E"
One of the solutions we have is very slow, although it gives the correct answer
using (var context = new PrincipalContext(ContextType.Domain)) { using (var group = GroupPrincipal.FindByIdentity(context, IdentityType.Name, "DL-COOL-USERS")) { var users = group.GetMembers(true); // recursively enumerate return users.Any(a => a.Name == "userName"); } }
The original solution and what I was trying to get to work, using .NET 3.5 System.DirectoryServices.AccountManagement and it does work when users are direct members of the group in question is as follows:
public bool IsUserInGroup(string userName, string groupName) { var cxt = new PrincipalContext(ContextType.Domain, "DOMAIN"); var user = UserPrincipal.FindByIdentity(cxt, IdentityType.SamAccountName, userName); if (user == null) { return false; } var group = GroupPrincipal.FindByIdentity(cxt, groupName); if (group == null) { return false; } return user.IsMemberOf(group); }
The bottom line is, we need to check for membership even though the groups are nested in many levels down.
I am trying to call a reporting services report in Report view if I click ID For example, if I click ID 1001 ..it will pass the parameter 1001 And run a reporting services report in Report viewer on new web page..
How can I do this? Is there a example I can take a look?
i wanna wrtite a model for master - detail tables. using mvc and entity framework.
for example maste table is ORders, detail table is ORderDetails.
ORders colunms (OrderID, Date, Employe..)
ORders OrderID Date .... 1 1/1/10 2 1/2/10
OrderDetail columns (OrderID, porductID, Amount)
ORderID ProductID Amount 1 1 10 1 2 8 1 3 7
i am creating a model for this structure
Puclis class Model{ public OrderID, Date, Employe; List<OrderDetail> list ; // this is another class OrderDetails... }
while saving this model to database orderID,Data,Employe... items are saving Orders table in database. and List<OrderDetail> is saving with for loop to ORderDetail table.
but editing the order and details model is difficult.
I have a piece of code which gets clients list from a database and write to XML as follows:
[Code]....
Which Creates XML file as follows:
[Code]....
I need to group the client list in my online site to show(group) each 4 clients within separate div and ul
[Code]....
My target is to use one of the following two directions:
1 - Find a solution to group data while generating the XML file to groups of 4 items
[Code]....
2 - Try to group the xml in my repeater by finding a solution for nasted-like repeater or custom item template and separator template to make the output like the above div/ul structure
I also have no problem if we can do this through the SQL stored procedure
In my organization we use nested groups. For a particular usage, we have a group (let's assume that the group name "kuku"), and the names of all the nested groups under it contains "kuku" as well.
We may assume that no other group in the LDAP has "kuku" in the name.
I need to create a filter which will return all the users which belong to one of the "kuku"s group.
Obviously, using this filter will bring only the head kukus
(&(&(objectclass=user)(objectclass=person))(memberOf=CN=kuku,cn=...rest of the group DN...))
How can I use wild card to fetch all users which belong to any kuku?
For example: (&(&(objectclass=user)(objectclass=person))(memberOf=CN=.*kuku.*))
Report viewer from SQL reporting services in VS 2008 report control If I create a new report in VS 2008 they have a .rdlc extension and work correctly.
I have some reports that I was using in SQL reporting services. Extensions are .rdl and want to get them to work with VS 2008.
I copied the rdl files and the .rdl.data files over to VS 2008 (SP1) project but when I go to select the report in the control it does not see the file (I assume it is looking for a .rdlc file)
I tried rename the file to .rdlc and loaded the file up and got
The report definition has an invalid target namespace [URL] which cannot be upgraded.
I see this
[URL]
[URL]
It says
"RDL files are fully compatible with the ReportViewer control runtime. However, RDL files do not contain some information that the design-time of the ReportViewer control depends on for automatically generating data-binding code. By manually binding data, RDL files can be used in the ReportViewer control."
But the link for how to manual bind the data is broken.
Can you please point me to an example of how to implement drill down in RDLC? I am in a situation where the first report appears perfectly, but when I click on a drill down link , i get an error A data source instance has not been supplied for the data source 'RecuirtmentDataSet_ProfileTracker'.
I am working with SSRS reports .I have one report called AllOrderDails with Order_No, Order_Date, Project_Name, Boiler_Name, RefNo, Total_NoItems, Total_GrossWeight, Expected_Date .It shows all order Details ,when i click Order_No it shows another report called OrderDetails.It shows only single Order_No details....In OrderDetails page i am using one textbox for back .It is for going back to AllOrderdetails.
My problem is when i click Order_No in AllOrderDetails page it's show OrderDetails page withrelated Order_No,when i click back it goes to AllOrderDetails Page but It's not displaying any data...
I can access the website I've created on my local machine in debug mode; and with my domain account as a local administrator, if I do this:
[Code]....
I can still access the website; and with my domain account in a Domain Group named "DomainDomainLocalSecurityGroup", if I do this:
[Code]....
I can still access the website; HOWEVER, if I create a Local Group on my machine named "LocalMachineGroup" and I add "DomainMyDomainUserName" to this group and I do this:
[Code]....
I get an Access Denied error trying to access the website. What I want to do is, have a group on my local machine (for testing), on a test web server, and on a production web server named "MyWebsiteUserAccess" with the same Domain Group (filled with Domain Users allowed access to the site) in all of these local groups; so that when I test the web application on my local machine, on my test web server and on my production web server, I don't have to change the Web.config file to have it work on each AND if the Domain Group name ever has to change, it won't affect access to the website.
What am I overlooking or is this even possible to do this way? I understand that there is a way to do Role Management through ASP.NET but I don't understand that well enough yet to implement that (and will probably go that route once I've done the research on how to best implement it for purpose of access control of this intranet site).
I have a user that when I attempt to enumerate her groups using either System.Security.Principal.WindowsIdentity.GetCurrent().Groups on user's computer or System.Web.HttpContext.Current.Request.LogonUserIdentity.Groups on the IIS server, I get a list of their old groups, not their new. I have checked the DC that they authenticate to and the ASP.NET page is running inside a SharePoint instance so the LogonUserIdentity most like is being provided from there Kerberos ticket. Should I be looking up the groups directly from the AD instead of relying on the WindowsIdentity or LogonUserIdentity?