grouping

Silverlight 3 Datagrid: Is it possible to apply different styles to each GroupRow level?

I can style GroupRows by creating a DataGrid.RowGroupHeaderStyles style, but this applies to all GroupRows. eg If I am grouping by 2 columns. I would like a different background color for column 1 GroupRows and column 2 GroupRows. Is this possible? Update Here's how I've accomplished this, but its a bit of a hack. Hopefully someone w...

Preserve multi-column sort in AdvancedDataGrid with dataProvider as GroupingCollection

I have three attributes in my XML object: last name, first name, and age. My sample XML looks like: <dataXML> <info last="Abc" first="Def" age="20"/> <info last="Abc" first="Hij" age="10"/> <info last="Xyz" first="Klm" age="25"/> <info last="Xyz" first="Opq" age="64"/> <info last="Xyz" first="Rst" age="08"/> </dataXML> I am using...

GroupDescriptor in SL4B2

Using Silverlight4, how can I make datagrid grouping look up a display name from another table when the grouping value is a foreign key? I could denormalise the entity so that it resolves the join itself but this introduces update issues. The approach that leaps to mind is a value converter and I shall look into it, but if you have a de...

Java : replacing text URL with clickable HTML link

Hello, I am trying to do some stuff with replacing String containing some URL to a browser compatible linked URL. My initial String looks like this : "hello, i'm some text with an url like http://www.the-url.com/ and I need to have an hypertext link !" What I want to get is a String looking like : "hello, i'm some text with an url ...

Should XML elements have grouping parents?

Which convention would be preferred and why (include some pros and cons of one over the other)? This: <company> <employees> <employee /> <employee /> <employee /> </employees> <buildings> <building /> <building /> </building> </company> or this: <company> <employee /> <...

MySQL/PHP: How to list results in groups but limit the DB queries required

I have a database as follows: --------------------------------------------------------------- | module_name | category | content | --------------------------------------------------------------- | module1 | category1 | content | | module2 | category1 | c...

Unable to group after left join

Here is my query (from a trigger): UPDATE QuoteItemsGroupFeature SET Cost = (QuoteItemsGroup.BaseCost + QuoteItemsGroup.AccumulatedCost + ISNULL(SUM(ParentQuoteItemsGroupFeature.Cost), 0)) * INSERTED.Amount FROM QuoteItemsGroupFeature INNER JOIN INSERTED ON QuoteItemsGroupFeature.QuoteItemsGroupFeatureId = INSERTED.QuoteIt...

GroupBy CAMl query is giving Render Failed error

Hello, I have custom list definition.I want to display rows as GroupBy with some column names. I added a query in Schema.xml like below. <Query> <GroupBy> <FieldRef Name="Title" visible="false" /> <FieldRef Name="Followed By" /> </GroupBy> </Query> If i use two filter group its working fine.No iss...

Grouping Controls

I'm using C++ Builder 5. Is there a way to group a disparate set of controls so that by simply calling, for instance, myGroup.Enabled = false; will set all group of controls enabled property to false? I can't use a GroupBox since the controls (labels, checkboxes, etc) are on different TabPages. The reason I ask is so I don't have to cal...

Coldfusion, outputting SQL results grouped by Date Grouping, Today, Yesterday, This Week, etc...

Hello! I'm hitting the DB for a 100 records from a MySQL DB that have a DateAdded (timestamp) column. I'd like to find a SMART way to display the records as follows in Coldfusion, w/o hitting the database multiple times. Today: - records..... Yesterday: - records..... Earlier This Week: - records..... Earlier This Month: - records.......

RadGrids, DetailTables, and Grouping

Hey Everyone, Say I have a RadGrid that shows info on what a customer has ordered. The master table view is all customer-related info. When expanded, the detail table contains info about the item the customer ordered. Now, here's the tricky part: We sell items that we call a "Kit"; essentially they're multiple skus ordered under one...

how do i create sub groups within table using jquery?

i am creating a stock portfolio. each row is a stock and it's data including profit/loss. each row has a groupid that the user can specify. the idea is i want to: 1) physically group the rows based on the groupid 2) after step #1 i want to dynamically add a row below that group with the subtotal of the profit/losses for that group on...

Silverlight 3: Datagrid like grouping in ItemsControl

Is it possible to group items in a ItemsControl or Listbox in Silverlight? These controls are bound to a DomainDataSource. Or are there any 3rd party controls that do this? UPDATE: This is the sort of UI I am trying to create. ...

Create barchart using jfreechart with bars of same category together

I want to make bar chart using jfreechart such that the bars which belong to the same category should be displayed adjacent without any gaps. The categories should be displayed with gaps. Also each category may have different number of bars. How it can be achived using Jfreechart library? Following image is the sample of what I require....

Algorithm in the tag clouds (Calculating)

I have a tag list which contains a list of duplicated tags, such as "tag1", "tag1", "tag2", "tag3", "tag3" and "tag2". I want to calculate and how many tag1, tag2 and tag3 are in the list, and then add them into a new tag list such as var tagList = new List<Tag>(), it will have thousands of the tags in the list. Can anyone one help me ...

Mysql GROUP BY and unique values

I have a table in MySQL: SID DID MessageType DateOf Message 1 255 LOG 2010-01-17 15:02:05 Log msg 1 2 255 USER 2010-01-17 19:02:05 User msg 1 3 211 LOG 2010-01-17 15:06:55 Log msg 2 4 211 ADMIN 2010-01-17 22:06:55 Admin msg 1 I need to get last (by DateOf) Message and MessageType, groupped by DID, ord...

How to access ItemsCount on a Group Item within WPF ListView in code?

I have XAML code with a grouped ListView that looks like the following: <ListView ItemsSource="{Binding}" Name="ContactList"> <ListView.ItemTemplate> <DataTemplate> <controls:ContactItemControl /> </DataTemplate> </ListView.ItemTemplate> <ListView.Gr...

AdvancedDataGrid hell: data on grouping rows

I need a hierarchical grid that shows data in columns for the parent rows as well as the child rows. - a parent | 1234 | data | data | a child | 2222 | data | data | a child | 212 | data | data | I've tried to make ADG work, but by default it has all columns except the grouping column blank for parent rows. I think I could use ...

Querying for a unique value based on the aggregate of another value while grouping on a third value entirely

So I know this problem isn't a new one, but I'm trying to wrap my head around it and understand the best way to deal with scenarios like this. Say I have a hypothetical table 'X' that looks like this: GroupID ID (identity) SomeDateTime -------------------------------------------- 1 1000 1/1/01 1 1001 2/2/02 ...

Xsl: Grouping and removing duplicate items

Given the following XML: <interface name="Serial1/0"/> <interface name="Serial2/0.0"/> <interface name="Serial2/0.1"/> <interface name="Serial3/0:0"/> <interface name="Serial3/0:1"/> I am trying to produce the following output: <interface name="Serial1/0"> <unit name="Serial1/0"/> </interface> <interface name="Serial2/0"> <unit n...