|
I'm on a project to create a skills matrix for about 200 people and am hoping to not have to reinvent the wheel. Users will fill out and maintain their skill proficiencies using yes/no and radio or combo inputs. Skills are grouped by category (Technical...
Started by Nicholai on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The hard part with Drupal is the....
As @sprugman pointed out, use the Content Profile , together with CCK you can customize the profile page at will .
You can manage the skill using the Taxonomy.
This will do your trick.
Drupal with Views, CCK, VotingAPI.
|
|
How do I exclude one value from a grouping sum, based on a value of another field?
ie I open Report=> Report Properties=>Code and insert my Custom Code, but how would I change the below code to exclude a numeric value of another field for the below...
Started by Greg on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
On the same row includes "Others", and that the function you've supplied is used as the grouping criteria.
|
|
I have a report in Reporting Services and there is a group that is based around a field value. I want the group to repeat itself on the report as many times as there are rows with that field. The problem is that using Field!field.Value seems to only pull...
Started by kd7iwp on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Can you add a calculated fieldIs there a second field that you can use a "dummy" (aka tie breaker, key etc), to include to the dataset, such as Rownumber to ....
Edit: after comment.
In the grouping to make it unique?
This is how I'd do it.
|
Ask your Facebook Friends
|
I have the below query, which basically it retrieves the 5 top most books sold:
select top 5 count(id_book_orddetails) 'books_sold', bk.* from orderdetails_orddetails ord inner join books_book bk on ord.id_book_orddetails = bk.id_book group by id_book...
Started by Andreas Grech on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Another option is to keep the column stored as NTEXT, but GROUP BY only book_id by putting the count_book_orddetails) GROUP BY bk....
Answer question 1, but here's an answer to question 2: instead of select and grouping on desc_book.
|
|
I'm trying to return duplicate records in a user table where the fields only partially match, and the matching field contents are arbitrary. I'm not sure if I'm explaining it well, so here is the query I might run to get the duplicate members by some ...
Started by Mitch Weaver on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For me; may not do what you want:
SELECT MAX(ID) FROM members WHERE Email like "%someuser%" GROUP.
|
|
I am using LINQ to EF and have the following LINQ query:
var results = (from x in ctx.Items group x by x.Year into decades orderby decades.Count() descending select new { Decade = decades.Key, DecadeCount = decades.Count() });
So this kind of gets me ...
Started by ChrisHDog on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
How about grouping by x.Year/10? (haven't tested this!)
var results = (from x in ctx.Items group x by (x.Year / 10 * 10) into decades orderby decades.Count() descending select / 10 * 10) to get, for example....
An IEnumerable of IEnumerables.
|
|
I have next xml:
<page> <document> <id>1001</id> <cur>USD</cur> <date>01.01.2009</date> <amount>10</amount> </document> <document> <id>1001</id> <cur>USD</cur...
Started by Roman on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Within the template i then loop through the individual documents and finally i summarize the documents amount field.
I later apply the templates to the first document in each group.
fields, id and cur.
|
|
I am new to ASP.NET. I am trying to display my sql results using a list view. I am using the example for grouping my results by a data field from the 4GuysFromRolla.com website . However, I find the way of grouping the items by a data field to be a bit...
Started by daub815 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You can try porting this over.
Nested ListView - http://mattberseth.com/blog/2008/01/building_a_grouping_grid_with.html
I have never used a ListView, but I did do grouping in a GridView.
|
|
I'm using linq on a DataTable (in c#), and was wondering how to group by multiple fields. I discovered that it can be done with an anonymous class, e.g.
var a = dt.AsEnumerable().GroupBy(e => new { name = e["Name"] })
problem is, my grouping key is...
Started by toasteroven on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It into one string to group on:
var keyDictionary = new Dictionary<string, IEnumerable<string>>(); keyDictionary.Add("Table1", new List<string> {"Group", "Position"}); var dt = new("Group", typeof(string)), new ....
|
|
I am trying to create a table, with some grouping headers. All is well when i have 1 group, but how do i create dynamic groups?
This is what i have so far (for 1 group):
var groupby = ''; arrdata.each(function(element){ if (groupby != element.groupby)...
Answer Snippets (Read the full thread at stackoverflow):
JQuery.each(element.data , function(elementData){ tbody.push(elementData); }) })
You could group them.
|
