sql动态行列导致问题，请各位大侠帮忙解决下
因为要完成一张报表，报表样式为：水果类 干果类 灌木类 毛竹
序号 县 农户 苹果 李子 板栗 核桃 月季 牡丹 毛竹
1 湘潭县 QQ 12
2 湘潭县 CV 12
3 慈利县 CG
4 湘潭县 BB 12
5 湘潭县 HF 15
大类（如水果类）当前如果有10个大类，也只在这显示前面3个加上毛竹这个类
一个大类下的小类（如苹果和李子），如果当前有10个小类也之显示两个小类
注，在报表中的格式的固定的，数据是动态的绑定上去的 样式为三个类加上一个小毛竹类
SQL语句在下面
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LYXiangxi]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LYXiangxi]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LyInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LyInfo]
GO
CREATE TABLE [dbo].[LYXiangxi] (
[LYXId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[LYId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[nhName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[shuzhonglei] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[shuzhong] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[shuliang] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[LyInfo] (
[Lyid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[xian] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[nianfen] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
insert into lyInfo values ('201010004','湘潭县','2010')
insert into lyInfo values ('201010002','湘潭县','2010')
insert into lyInfo values ('201010001','湘潭县','2010')
insert into lyInfo values ('201010006','湘潭县','2010')
insert into lyInfo values ('201010007','湘潭县','2010')
insert into lyInfo values ('201010008','慈利县','2010')
insert into lyInfo values ('201010009','万丈县','2010')
insert into lyInfo values ('201010010','万丈县','2010')
insert into lyInfo values ('201010011','湘潭县','2010')
insert into lyInfo values ('201010026','万丈县','2010')
insert into lyInfo values ('201010016','湘潭县','2010')
insert into lyInfo values ('201010036','万丈县','2010')
insert into lyInfo values ('201010021','慈利县','2010')
insert into lyInfo values ('201010015','湘潭县','2010')
insert into lyInfo values ('201010014','慈利县','2010')
insert into lyInfo values ('201010023','慈利县','2010')
insert into Lyxiangxi values('22','201010001','BB','灌木类','牡丹',12)
insert into Lyxiangxi values('2','201010001','QQ','水果类','苹果树',12)
insert into Lyxiangxi values('3','201010002','WW','水果类','橘子树',12)
insert into Lyxiangxi values('4','201010004','BE','灌木类','月季',12)
insert into Lyxiangxi values('5','201010006','RR','干果类','桃子树',12)
insert into Lyxiangxi values('6','201010006','VV','芦柑类','芦柑树',12)
insert into Lyxiangxi values('7','201010007','CS','灌木类','牡丹',12)
insert into Lyxiangxi values('8','201010008','AS','水果类','李子树',12)
insert into Lyxiangxi values('9','201010009','GX','水果类','梨子',12)
insert into Lyxiangxi values('10','201010002','GB','灌木类','牡娟',12)
insert into Lyxiangxi values('11','201010011','BS','干果类','板栗',12)
insert into Lyxiangxi values('12','201010014','BY','芦柑类','芦桔',12)
insert into Lyxiangxi values('13','201010015','TT','灌木类','月季',12)
insert into Lyxiangxi values('14','201010016','TR','干果类','核桃',12)
insert into Lyxiangxi values('15','201010021','CG','灌木类','茉莉',12)
insert into Lyxiangxi values('16','201010026','GC','干果类','板栗',12)
insert into Lyxiangxi values('17','201010036','HH','干果类','板栗',12)
insert into Lyxiangxi values('18','201010002','HT','灌木类','牡丹',12)
insert into Lyxiangxi values('19','201010002','GT','药材类','牡丹',12)
insert into Lyxiangxi values('20','201010002','CV','灌木类','月季',12)
insert into Lyxiangxi values('21','201010002','BGB','药材类','华药',12)
insert into lyxiangxi values ('25','201010001','HF','毛竹','毛竹',15)
--------------------编程问答-------------------- 没看明白啊,那个表头啊???大类还是小类? --------------------编程问答-------------------- 遇到什么问题呢？ --------------------编程问答-------------------- 不明白
建议你用excel做一个效果
当前数据表中为什么样子的
你期望生成什么样子 然后发图片上来 --------------------编程问答-------------------- 请问一下可以上传本地图片吗？
--------------------编程问答--------------------
--------------------编程问答--------------------
--------------------编程问答--------------------
--------------------编程问答--------------------
要实现这样的一个报表，需求如最上面，
补充：.NET技术 , C#
