I've got a graph that I want graphviz to layout and visualize for me. The graph has 122 edges and 123 nodes. The edges are of 4 different kinds and I want them to be visually distinguishable. However I've not yet decided what would be the best way of doing that, I'd like to play around with the dials a bit. Unfortunately I do not see any...
I have some data that shows the number of visits a person has done to all companies in our database. What I would like to do is show a report of all the visits and all the ones they haven't visited, grouped by month. For example, assuming the entire database of companies is CompanyA, CompanyB, CompanyC and CompanyD and the visit data i...
So I have this messages database between members in my CMS. I wanted to change the listing to show people instead of specific messages. Call it "threads" but each thread in the "my messages" page is a member that you've had a conversation with, right? So, I obviously do this with something like this: select id, msgfrom, headline from m...
I have a simple report in SSRS 2008 that lists employee name and their department. table emps ( PersonFullName VARCHAR2(64 Byte) Dept INT(4 Byte) ShiftStartDTM DATE ) I made very simple report to display this data ordered by shift start time. However now I need to make a another version of the report for departmental man...
I'm trying to extract and make variables out of the "thinking skills" (like analyzing, evaluating, etc.) from a test and set their value to the number of test items within each. I'm stuck, so any help would be appreciated. (The SQL statement seems to work fine.) Example of what I want: $analyzing = 7, $applying = 13, etc.... Thanks! ...
I've just begun using StringTemplate (from stringTemplate.org) and I'd like to know how to achieve grouping in the results. e.g. Month , ID __________________ Jan ,1 Jan ,2 Feb ,3 Feb ,4 Feb ,5 Mar ,6 Mar ,7 Mar ,8 Mar ,9 so that the results when grouped by mon...
i have a list of entries from the logs: 15:38:52.363 1031 15:41:06.347 1259 15:41:06.597 1171 15:48:44.115 1588 15:48:44.125 1366 15:48:44.125 1132 15:53:14.525 1348 15:53:15.121 1553 15:53:15.181 1286 15:53:15.187 1293 the first one is the timestamp, the second one is the value. now i'm trying to group them up by an interval of, sa...
Hi, I'm using Jasper iReport (output to PDF), and I have a problem with a certain report: Inside the report I have defined a group. On average, each "instance" of that group only contains a small number of detail rows, so I don't want each of them to start on a new page, since it would be a waste of paper (the output is printed on pape...
hi, I am a beginner of R. I want to create a 3 dimensional array but I can not define the length of each dimension. I am analysing students' marks of a class. there are 10 classes but it has different number of students. And "Grade" will be 100-90, 89-80, 79-70... until there will be any student who got the relevant marks. I was going t...
I have an iterator of lines from a very large file that need to be put in groups as I move along. I know where each group ends because there is a sentinel value on the last line of each group. So basically I want to write a function that takes an iterator and a sentinel value, and returns an iterator of groups each terminated by the sent...
I would like a third column "items" with the values that are grouped. Dictionary<string, int> dic = new Dictionary<string, int>(); dic.Add("a", 1); dic.Add("b", 1); dic.Add("c", 2); dic.Add("d", 3); var dCounts = (from i in dic group i by i.Value into g select new { g.Key, count = g.Count()}); var a = dCounts.Where(c =...
With the jqGrid is it possible to insert a section bar every 'n' records where clicking on the section-bar would toggle section expand/collapse? I am looking for a way to control the displayed height of the grid when I have set its height=100%. Here is pseudo-html showing such a section-bar inserted every 5 rows. The last section has o...
I'm building a website. It has groups that users can join. The difference between this and "normal" groups is that membership is temporary - when a user joins a group, he decides the length of membership: 5 days, a week, 2 weeks, etc (choices are pre-defined). Or potentially all memberships could be set to be of the same length - say a...
Hi all, I have a parent category that holds all Cars names, denoted by parent_name in table "parent". For each of these parents, there could be any number of car models & they all go in table called "model". Each of these models can have any number of images & refereced via the model_id as the Foreign Key. My task is to show all the Par...
I have a table that records market interactions by employees with customers. Relevant fields would be customerid, date and customer type. I want to be able to get a count of interactions by 5 week blocks going back as far as the between dates that would be submitted by the user and discriminate by customer type a,b,c. I want to be able...
I have changed DataGrid's DataGridRowGroupHeader's controltemplated and have placed 1 checkbox and 1 textblock instead of content presenter. now when i do grouping... in some cases if i click on checkbox of one group... it automatically selects another group also. can anybody please give some advice for this? ...
Hello, I am using Oracle SQL and I want to group some different rows that 'like' function results. To elaborate with an example: Let's assume I have a table MESA with one of the columns is a huge string. And I am counting the number of rows matching particular patterns: SELECT m.str, count(*) FROM MESA m WHERE m.str LIKE '%FRUIT%' A...
Hi I've a collection with itemname and header, and I've to group based on header, and if the header is empty the group style must be a button, or else it should give expander and the itemnames as its content. {itemname="cadbury" header="choclates"} {itemname="5 star" header="choclates"} {itemname="Flapjack" header=""} {itemanem="ford" h...
Hi! I would like to categorize results from an XPath under headings by element name (and then by same attribute names). Note: XML data could be inconsistent and some elements with the same name could have different attributes, therefore they need different headings. I can't seem to write out my problem in words, so it might be best to...
Hi everyone ! I work for a webagency, and I have to develop an intranet/extranet app to be used as sort of a DMS (Document Management System) for a high school. Some of the requirements of the projects are using Drupal CMS and having advanced user rights. Let me explain : The professors can post only for their students, and the students ...