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.
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.
Hai McDonald,
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?
Here is a good reference for you if you are using SQL Server 2005 or newer.
http://www.tsqltutorials.com/pivot.php
Nick