-
-
洋洋 小试身手Lv3
发表于2018-6-1 10:33
悬赏1
已解决
楼主
sql数据源分页问题
最近看过此主题的会员
最佳答案
添加一新的sql数据源，命名必须为"totalcount"，该sql数据源内容为：
Select count(*) from (原sql)
例如：
sql数据源1：命名为rs1（此处命名可随意定义）, sql内容为：
select sum(a.ZSR) as B1,sum(a.ZZC) as C1,a.XZQH as A1,max(b.NAME) as mc_A10
from FACT_SRZC_NEW a
,DIM_WSXZQH b
where (A.XZQH=B.ID(+))
group by a.XZQH
sql数据源2：命名为totalcount（必须为此名）,sql内容为：
select count(* ) from (select sum(a.ZSR) as B1,sum(a.ZZC) as C1,a.XZQH as A1,max(b.NAME) as mc_A10
from FACT_SRZC_NEW a
,DIM_WSXZQH b
where (A.XZQH=B.ID(+))
group by a.XZQH)
Select count(*) from (原sql)
例如：
sql数据源1：命名为rs1（此处命名可随意定义）, sql内容为：
select sum(a.ZSR) as B1,sum(a.ZZC) as C1,a.XZQH as A1,max(b.NAME) as mc_A10
from FACT_SRZC_NEW a
,DIM_WSXZQH b
where (A.XZQH=B.ID(+))
group by a.XZQH
sql数据源2：命名为totalcount（必须为此名）,sql内容为：
select count(* ) from (select sum(a.ZSR) as B1,sum(a.ZZC) as C1,a.XZQH as A1,max(b.NAME) as mc_A10
from FACT_SRZC_NEW a
,DIM_WSXZQH b
where (A.XZQH=B.ID(+))
group by a.XZQH)
2个回答
添加一新的sql数据源，命名必须为"totalcount"，该sql数据源内容为：
Select count(*) from (原sql)
例如：
sql数据源1：命名为rs1（此处命名可随意定义）, sql内容为：
select sum(a.ZSR) as B1,sum(a.ZZC) as C1,a.XZQH as A1,max(b.NAME) as mc_A10
from FACT_SRZC_NEW a
,DIM_WSXZQH b
where (A.XZQH=B.ID(+))
group by a.XZQH
sql数据源2：命名为totalcount（必须为此名）,sql内容为：
select count(* ) from (select sum(a.ZSR) as B1,sum(a.ZZC) as C1,a.XZQH as A1,max(b.NAME) as mc_A10
from FACT_SRZC_NEW a
,DIM_WSXZQH b
where (A.XZQH=B.ID(+))
group by a.XZQH)
