Implement a Drop Down as a Column Selector in Column Header as an Ultra Grid

265

Bhushan Inamdar posted over 8 years ago

Hi,

I am in a need for a functionality to show the details of the selected row in a parent grid in a child grid whose columns remain the same as the parent grid; however details of only one column are displayed at a time depending upon the selection in the header drop down of the details ultra grid. Please let me know how may I implement this...

Thanks,

Bhushan.

Parents

12480

Verified Answer
Offline Mike Bowshewicz posted over 8 years ago
Hi Bhusan,

I'm unclear of the details of your requirement. As I understand it, you need the following:

Display two grids to the user.

User can select a row in the main grid.

When a row is selected in the main grid, details about the row are shown in the second grid.

The detail grid shows only one column, and can be configured by the user.

The columns available to be shown in the detail grid are the same columns as in the main grid.

The user can choose which column is displayed through a dropdown in the header of the column in the details grid.

If this is your requirement, then please say so and I will build a sample. In order to better understand this, may I ask why you need to display this? If I am understanding correctly, the user can already see all the relevant information in the main grid.
Cancel
Reply

Reject Answer

Cancel
265

Verified Answer
Bhushan Inamdar posted over 8 years ago in reply to Mike Bowshewicz
Hi,

Thanks for the response and sorry for the late revert...been tied up. So here it is...

Display two grids to the user.

Yes. The main grid and the details grid. Basically, the main grid has to do some conditional drill down and also expand and collapse of the rows. But the details grid has all the rows visible but only for a single column. The main grid has a LHS column of particulars and against it the corresponding data for each particular in the respective year i.e. 2010,2011,2012,2013,2014,2015,2016 and so forth. However, the details (or the child) grid, shows the data on Cell click in the main event for the year that was clicked. For instance, if the user seeks particular details for 2010, then the details grid should show all the details for 2010 (all rows expanded). However, it shall have a drop down in the header, that has other columns added as a value list. On changing the selected year in the drop down header, the particulars are replaced with the selected period i.e., an in place column swap is made.

User can select a row in the main grid.

No. The user can select a single cell in the grid at a time and then the drill down occurs...

When a row is selected in the main grid, details about the row are shown in the second grid.

Partially correct, except that you can change it to the statement as ...when the cell is clicked, all the particulars of the column are shown in the details grid.

The detail grid shows only one column, and can be configured by the user.

Yes. As explained above, I shall want to have a drop down header for this.

The columns available to be shown in the detail grid are the same columns as in the main grid.

Yes. The columns are same, but the rows are all expanded and there is some additional functionality in this grid...

The user can choose which column is displayed through a dropdown in the header of the column in the details grid.

Yes. That is what I want ...an in place drop down Column Chooser...

A sample for the above scenario is much appreciated.

Thanks again,

Bhushan.
Cancel
Reply

Reject Answer

Cancel
265

Bhushan Inamdar posted over 8 years ago in reply to Bhushan Inamdar

Hi Mike,

Just wanted to know if you could build a simple sample for the above mentioned scenario and share it? Also, if not able to provide me the sample, please provide me any pointers / hints to try it out myself. Please advice if this is possible and worth spending the time and effort, as I do not want to waste my time in something which is not going to work out. And in the end, please let us know alternative way to implement Column Chooser UI, that shall closely match our needs.

Thanks,

Bhushan.
Cancel
Reply

Cancel
12480

Verified Answer
Offline Mike Bowshewicz posted over 8 years ago in reply to Bhushan Inamdar

Hi Bhushan,

I've built a sample that fits these requirements. I used a creation filter to position an UltraCombo over the detail grid's header. Please let me know if this is what you were looking for.

GridHeaderDropdown.zip
Cancel
Reply

Reject Answer

Cancel

Reply

265

Bhushan Inamdar posted over 8 years ago in reply to Mike Bowshewicz

Hi Mike,

Thanks for the sample. That is exactly what I need. I shall try to tailor this to our requirements and get back to you in case I face any trouble doing so. I would want to know if I can just set the background of the drop down conditionally based on the item selected? Basically, the column headers in the parent grid are having green and red background based on certain conditions. So in this child grid when column with Green Header is selected, the combo back ground should be green else red. However, when it is dropped down, it should show up with white fore color and blue back color. I suppose, this can be done using appearance objects and assigning them the green and red color in the selection changed event? And then the blue color to be shown in the back ground when the drop down is expanded, which event should be handled for that?

Thanks,

Bhushan.
Cancel
Reply

Cancel

Children

12480

Offline Mike Bowshewicz posted over 8 years ago in reply to Bhushan Inamdar

Hi Bhushan,

Assigning the appearance based on a condition in the SelectionChanged event should work fine. In order to show the blue color when the dropdown is expanded, you can use the BeforeDropDown event.

Please let me know if you have any questions.
Cancel
Reply

Cancel