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
If your datasource is from SQL Server then it would be better to create a stored procedure to pivot the data for you.
Nick
Hai Nick,
If i pivot my datasource, the result will be as follow :
Branch A Branch A Branch B Branch B
Customer A Customer B Customer A Customer B
1200 1500 2000 1000
This will not give the result what i need (as shown in previous post). Any idea?
Hi,
While I am looking for cross tab report/grid, I found that you have sucessfully created the report/grid..
I need your help to create the grid(see pic). Can you send me the code how to create the cross tab grid. I have a table having the following Columns
State,City,PROD_TYPE,VALIDATION_TYPE,PRIORITY,CALC1,CALC2
I apreciate and very thankful for your kind help.
Thanks & Regards,
Tanish
Here is a good reference for you if you are using SQL Server 2005 or newer.
http://www.tsqltutorials.com/pivot.php