sql动态行列导致问题，请各位大侠帮忙解决下，先谢谢了！

[m_struggle]

报表格式如下


大类（如水果类）当前如果有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)

[m_struggle]

上面那个报表图有点问题

帮我提供设计思路也行