SSRS - 随笔分类 - chunshen

MDX 脚本语句 -- Scope

摘要：在多维表达式 (MDX) 中，下列语句用于管理 MDX 脚本中的上下文、作用域和流控制。主题说明calculate语句计算子多维数据集，还可以确定子多维数据集中所包含的求解次序case语句允许有条件地从多次比较中返回特定值existing关键字强制在当前上下文中计算所指定的集freeze语句将所指定... 阅读全文

posted @ 2016-01-25 18:39 chunshen 阅读(1646) 评论(2) 推荐(0)

闰年2月29天

摘要：=iif(Fields!Year.Value=2012 and Fields!month.Value=2,29,iif(Fields!Year.Value=2013 and Fields!month.Value=2,28,iif(Fields!month.Value<8 and Fields!month.Value mod 2=1,31,iif(Fields!month.Value<8 and Fields!month.Value mod 2=0,30,iif(Fields!month.Value>7 and Fields!month.Value mod 2=0,31,30) 阅读全文

posted @ 2012-08-23 23:58 chunshen 阅读(273) 评论(0) 推荐(0)

从参数中获得特定字符串

摘要：=left(right(right(Fields!ts.Value,4),len(right(Fields!ts.Value,4))-Instr(right(Fields!ts.Value,4),"[")),Instr(right(right(Fields!ts.Value,4),len(right(Fields!ts.Value,4))-Instr(right(Fields!ts.Value,4),"[")),"]")-1) 阅读全文

posted @ 2012-08-23 23:28 chunshen 阅读(187) 评论(0) 推荐(0)

栏目数据合并表达式

摘要：=iif(Fields!门店.Value="莘庄",nothing,Fields!门店.Value) & "" & iif(Fields!门店2.Value="无",nothing,Fields!门店2.Value) 阅读全文

posted @ 2012-08-23 20:29 chunshen 阅读(231) 评论(0) 推荐(0)

参数--在已选择的年度中选择月份

摘要：--=======================================================[维度表_日期].[年季月日].[年份].&[2012].&[2季度].&[06]--=======================================================SELECT NON EMPTY { [Measures].[T1], [Measures].[T2], [Measures].[T3] } ON COLUMNS, NON EMPTY { ([维度表_时间].[每小时].[每小时].ALLMEMBERS * [维度阅读全文

posted @ 2012-07-09 10:58 chunshen 阅读(524) 评论(0) 推荐(0)

实现百分比和百分比的累加以及A、B、C类别的标识

摘要：with member [Measures].[Total Sales] as 'Sum({[Product].[Brand].[Brand].members},[Measures].[Ending Inventory Cost])',format_string="#,#.00"member [Measures].[Rate] as [Measures].[Ending Inventory Cost]/[Measures].[Total Sales],format_string='0.00%'set [Brand] as 'AddCa 阅读全文

posted @ 2012-07-09 10:07 chunshen 阅读(356) 评论(0) 推荐(0)

MDX中union的使用

摘要：WITH MEMBER [D_Acct_II].[PID].&[50].[毛利润] AS [D_Acct_II].[PID].&[501]-[D_Acct_II].[PID].&[502]MEMBER [D_Acct_II].[PID].&[50].[净利润] AS [D_Acct_II].[PID].&[501]-[D_Acct_II].[PID].&[502]-[D_Acct_II].[PID].&[503]-[D_Acct_II].[PID].&[504]-[D_Acct_II].[PID].&[511]-[D_Ac 阅读全文

posted @ 2012-07-09 09:58 chunshen 阅读(633) 评论(0) 推荐(0)

sum函数按照类别的值进行取值

摘要：=sum(iif(Fields!zzz.Value="xxx",iif(Fields!yyy.Value=0,nothing,Fields!yyy.Value),0)) 阅读全文

posted @ 2012-07-07 10:16 chunshen 阅读(306) 评论(0) 推荐(0)

父子维度转化为组

摘要：with member [T1] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 02]).namemember [T2] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 03]).namemember [T3] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 04]).namemember [T4] a 阅读全文

posted @ 2012-06-29 02:31 chunshen 阅读(292) 评论(0) 推荐(0)

表颜色隔行变换

摘要：=iif(RowNumber(Nothing) Mod2,"Green","White"). 阅读全文

posted @ 2012-06-25 12:35 chunshen 阅读(164) 评论(0) 推荐(0)

参数范围的选择

摘要：WITH MEMBER [Measures].[ParameterCaption] AS [DAccount].[Parent].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [DAccount].[Parent].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [DAccount].[Parent].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption. 阅读全文

posted @ 2012-06-25 12:31 chunshen 阅读(240) 评论(0) 推荐(0)

参数格式

摘要：WITH MEMBER [DAccount].[Parent].&[5].[营业利润] AS ([DAccount].[Parent].&[501],[Measures].[DAmount])-([DAccount].[Parent].&[502],[Measures].[DAmount])-([DAccount].[Parent].&[503],[Measures].[DAmount]) member [T1] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 02 阅读全文

posted @ 2012-06-25 11:13 chunshen 阅读(290) 评论(0) 推荐(0)

多参与多轴

摘要：WITH MEMBER [D_Acct_II].[PID].&[50].[毛利润] AS [D_Acct_II].[PID].&[501]-[D_Acct_II].[PID].&[502]MEMBER [D_Acct_II].[PID].&[50].[净利润] AS [D_Acct_II].[PID].&[501]-[D_Acct_II].[PID].&[502]-[D_Acct_II].[PID].&[503]-[D_Acct_II].[PID].&[504]-[D_Acct_II].[PID].&[511]-[D_Ac 阅读全文

posted @ 2012-06-20 21:54 chunshen 阅读(236) 评论(0) 推荐(0)

参数_门店

摘要：WITH MEMBER [Measures].[ParameterCaption] AS [D_Store].[门店].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [D_Store].[门店].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [D_Store].[门店].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[P 阅读全文

posted @ 2012-06-20 21:34 chunshen 阅读(166) 评论(0) 推荐(0)

参数_时间

摘要：WITH MEMBER [Measures].[ParameterCaption] AS [Time].[YM].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Time].[YM].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Time].[YM].CURRENTMEMBER.LEVEL.ORDINAL MEMBER [Measures].[T] AS strtovalue([Time].[YM].CURRENTMEMBER 阅读全文

posted @ 2012-06-20 21:31 chunshen 阅读(161) 评论(0) 推荐(0)

SSRS表达式

摘要：实现：值的结构百分比的表达式： Value=iif(Sum(Fields!ED.Value, "projectname")=0,0,Sum(Fields!ED.Value)/Sum(Fields!ED.Value, "projectname")) 实现：当值为0时不显示（白色），当小于0时为红色，否则为黑色。 Color=iif(Sum(Fields!ED.Value)=0,"white",iif(Sum(Fields!ED.Value)0,"red","black")) 阅读全文

posted @ 2009-08-25 14:23 chunshen 阅读(916) 评论(0) 推荐(0)

【msdn】配置 ReportViewer 以进行远程处理

摘要：一、参考msdn资料库：二、打开报表，报“为用户“NT AUTHORITY\NETWORK SERVICE”授予的权限不足,无法执行此操作。” 三、报“为用户 servername\IUSR_servername 授予的权限不足,无法执行此操作。” 阅读全文

posted @ 2009-08-24 00:02 chunshen 阅读(1937) 评论(2) 推荐(0)

【未解决】Reporting Services报表在浏览器中的显示

摘要：今天把微软的报表重新部署一遍，发现在不同的浏览器中，显示的尺寸大小不一样...... 阅读全文

posted @ 2009-08-23 10:04 chunshen 阅读(526) 评论(1) 推荐(0)

随笔分类 - SSRS