Hai To All,
I m using Infragisctics 2008 volume 3. I want to create a grid (cross tab grid). How to create it. Is there any sample code to create it? Is it possible to generate it in run time? Thanks in advance.
What exactly do you mean by a "cross tab grid"? How does this differ from a regular grid?
Hai McDonald,
Cross Tab Grid is just like matrix report.
I my dataset i have value like following :
Branch Customer Amount
Branch A Customer A 1200
Branch A Cusomer B 1500
Branch B Customer A 2000
Branch B Customer B 2500
I want to display this values in the grid as below :
Customer A Customer B
Branch A 1200 1500
Branch B 2000 2500
Is it possible ?
Thanks in advance
You can get a similar result in WinGrid by using its Outlook Group-By functionality.
Given your sample data, you'd group the grid by the "Customer" column. This will give you a result like the following:
+ Customer: A (2) Branch Amount Branch A 1200 Branch B 2000+Customer: B (2) Branch Amount Branch A 1500 Branch B 2500
If you want a result that appears more like the one you've listed in your previous post, you should instead create a new DataTable, where you've already created separate columns for Customer A and Customer B. You can then bind this DataTable to WinGrid.
I planned to create a new datatable, with seperate columns as you mention in your reply. I planned to do this in runtime. Is this cause any perform issues (like time delay)?
There will likely be some delay, depending on the size of your DataTable (columns and/or rows) and how much processing you're doing. For most typical usage, I expect this delay to be minimal to the point where a user won't notice.
I completed the cross tab grid based on your instruction. It is working fine. I need one more information.
I am creating a grid like the image given below. Now the datas are coming as like the image. I need to work for the column header and Row selector like the given image. Can u guide to complete this?
mukeshwa,
You would typically be better off posting this in our WebGrid forum. I'm leaving your posts connected to this thread, rather than splitting them off, since it's easier to keep enough context to understand your posts by leaving the thread intact.
WebGrid does not have the row layouts functionality that WinGrid possesses. This type of UI with WebGrid would be difficult to implement, if it's even possible.
If you'd like to discuss this further with relation to WebGrid, please post to our WebGrid forum.
Hi,
I read your reply regarding corss tab query asked by suresh. it is created in Wingrid. Is it possible in Ultrawebgrid? I am unable to find RowLayoutStyle.GroupLayout in ultrawebgrid. Can you please help me to implement such type of grouping in Ultrawebgrid. I found the article for wingrid like
Grouping Columns in Row Layout using code
but I am unable to find the same stuff for web.
Please reply
Thanks & Regards
I'm not entirely certain about the scenario you've described, or what you're specifically asking.
I suspect that you either need to set the SpanX and SpanY properties of the RowLayoutInfo (in addition to the OriginX and OriginY), or you want to use grouping as part of row layouts.
If you're working with row layouts in code, I recommend that you first set up your row layouts through the designer, and then inspect the Windows Forms Designer Generated Code section. Row layouts involve a large number of properties, and this approach helps you to see what code is used to get a particular result.
The following articles from our online help documentation of NetAdvantage for .NET 2009 Volume 1 has more information about using grouping with row layouts (new functionality in the 2009 Volume 1 release):Grouping Columns in Row Layout Mode using the DesignerGrouping Columns in Row Layout using code
I believe that this thread is growing beyond the realm of where we can provide reasonable assistance via the forums. If you need further assistance with this issue, I strongly recommend that you submit a support request. Include a link to this forum thread so that it's easier to see what's been done so far. Include informaiton about where you're at and what you need specific assistance with. Include a sample project if you can, as this greatly speeds our ability to research, respond, and resolve. If you have multiple issues, submit separate requests for each one.
Thanks for your reply Vince. For the row style i also worked as you told ( hiding the row selector and make the regular columns as row selector column)
For Column layout, i tried the rowlayouts features (by setting userowlayout = true). I also added some unbound columns with "labelposition = labelposition.labelonly". I set OriginY as 0 for first level of columns and OriginY as 2 for second level of column headers. But i am unable to group the second level columns header for particulare first level header. I think i get confuse in setting the values of OriginX. Do u have any sample code to set the multilevel column header using rowlayouts?
For the "row selector," I recommend that you hide the row selectors and style a regular grid column to appear like this. Putting long text as part of a row selector is theoretically possible, yet is not something I'd recommend.
The column layout looks a bit trickier. You may be able to implement this by using a combination of row layouts and column groups.
You would have to implement the collapse/expand indicators in the column headers yourself.