注册 登录  
 加关注
查看详情
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

微软MVP罗勇的博客

微软MVP罗勇,www.luoyong.me

 
 
 

日志

 
 

Dynamics CRM报表开发教程之使用CRM预置参数  

2013-12-04 08:53:57|  分类: CRM报表 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

关注本人微信公众订阅号: 微软动态CRM专家罗勇 ,回复73或者20131204可方便获取本文,同时可以在第一时间得到我发布的最新的博文信息,follow me!

具体参考sdk中的 Use Parameters in Reports 章节,参数列表见下面:

参数名称

描述

CRM_FilterText

Contains the value of the filter text that a report user interactively creates in the Report Viewer when the user runs a report. The parameter is in a filter summary text box that is located in the report header. The initial value is set to the default filter.

CRM_URL

Set to the URL of the Microsoft Dynamics CRM Web application. Use this parameter when drilling through to Microsoft Dynamics CRM.

CRM_FilteredEntity

Use in a query expression to enable data pre-filtering (through Advanced Find).

CRM_FullName

The full name of the user on whose behalf the report is running.

CRM_UserTimeZone

User’s time zone name, for example, Pacific Standard Time.

CRM_UILanguageId

Current locale (LCID) of the user.

CRM_YearStartWeekCode

The first week of the year that is used in Microsoft Dynamics CRM 2011.

CRM_WeekStartDayCode

The first day of the week that is used in Microsoft Dynamics CRM 2011.

CRM_FiscalCalendarStart

The start date for the fiscal year that is used in Microsoft Dynamics CRM 2011.

CRM_FiscalPeriodType

Specifies how the fiscal year is divided, Quarterly, Monthly, Annually and so on.

CRM_FiscalYearDisplayCode

Specifies whether the fiscal year name is displayed based on when the fiscal year starts or when it ends.

CRM_FiscalYearPeriodConnect

Specifies how the fiscal year and fiscal period are connected when displayed together.

CRM_FiscalYearFormat

Specifies how the name of the fiscal year will be displayed.

CRM_FiscalPeriodFormat

Specifies how the fiscal period will be displayed.

CRM_FiscalYearPrefixFormat

Specifies whether a prefix is attached to the fiscal year when it is displayed.

CRM_FiscalYearSuffixFormat

Specifies whether a suffix is attached to the fiscal year when it is displayed.

CRM_CurrencyDecimalPrecision

The currency decimal precision.

CRM_CurrencySymbol

The organization’s currency symbol.

CRM_CurrencyPositivePattern

The format pattern for positive currency values.

CRM_CurrencyNegativePattern

The format pattern for negative currency values.

CRM_NumberDecimalDigits

The number of decimal places to use in numeric values.

CRM_NumberDecimalSeperator

The string that is used as a decimal separator in numeric values.

CRM_NumberNegativePattern

The format pattern for negative numeric values.

CRM_NumberGroupSizes

The number of digits in each group to the left of the decimal in numeric values.

CRM_NumberGroupSeperator

The string that separates groups of digits to the left of the decimal in numeric values.

CRM_DateSeperator

The string that separates the components of a date, such as year, month, and day.

CRM_TimeSeperator

The string that separates the components of time, such as hour, minutes, and seconds.

CRM_AMDesignator

The string that separates the components of time, such as hour, minutes, and seconds

CRM_PMDesignator

The designator for hours that are "post meridiem" (PM).

CRM_ShortDatePattern

The format pattern for a short date value that is associated with the "d" format pattern.

CRM_LongDatePattern

The format pattern for a long date value that is associated with the "D" format pattern.

CRM_ShortTimePattern

The format pattern for a short time value that is associated with the "t" format pattern.

CRM_MonthDayPattern

The format pattern for month and day values that are associated with the "m" and "M" format patterns.

 

要使用这些参数很简单,在报表的报表数据中的参数文件夹右击,选择 增加参数, 名称输入上面的名称,记得将 选择参数可见性 的值设置为 隐藏。

Dynamics CRM报表开发教程之使用CRM预置参数 - 罗勇 - 罗勇的博客
 
然后在CRM的报表中就可以使用了,比如我这里是将报表的一个文本框的 表达式 设置为刚才这个参数的值。
Dynamics CRM报表开发教程之使用CRM预置参数 - 罗勇 - 罗勇的博客
 
Dynamics CRM报表开发教程之使用CRM预置参数 - 罗勇 - 罗勇的博客
 
这样在CRM报表中就可以看到这个参数的值了,这些参数有个好处就是CRM自动赋值,不需要我们来处理,使用即可。我们去测试看看,不同的人运行报表会有不同的结果。
Dynamics CRM报表开发教程之使用CRM预置参数 - 罗勇 - 罗勇的博客
 
 
Dynamics CRM报表开发教程之使用CRM预置参数 - 罗勇 - 罗勇的博客
 
素格格新疆特产店--做最好新疆特产的搬运工。
本店由博主的新疆老婆开设,搬运各种最好的新疆特产,是自用,送礼,年货,孝敬长辈特别是(岳)父母的首选!
Dynamics CRM报表开发教程之使用CRM预置参数 - 罗勇 - 罗勇的博客
 
  评论这张
 
阅读(760)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018