RDLC报表格式设置.docx
- 文档编号:4227094
- 上传时间:2022-11-28
- 格式:DOCX
- 页数:9
- 大小:17.44KB
RDLC报表格式设置.docx
《RDLC报表格式设置.docx》由会员分享,可在线阅读,更多相关《RDLC报表格式设置.docx(9页珍藏版)》请在冰豆网上搜索。
RDLC报表格式设置
RDLC报表格式设置
设置数字格式
下表列出了常用的.NET数字格式设置字符串。
格式字符串 名称
C或c 货币
D或d 小数
E或e 科学记数法
F或f 固定点
G或g 常规
N或n 数量
P或p 百分比
R或r 往返
X或x 十六进制
您可以将许多格式字符串修改为包含精度说明符,该说明符用于定义小数点后的位数。
例如,格式设置字符串D0将数字格式设置为小数点后没有数字。
您还可以使用自定义的格式设置字符串,例如#,###。
设置日期格式
下表列出了常用的.NETFramework日期格式设置字符串。
格式字符串 名称
d 短日期[2008.08.08]
D 长日期[2008年08月08日]
t 短时间
T 长时间
f 完整日期/时间(短时间)
F 完整日期/时间(长时间)
g 常规日期/时间(短时间)[2008.08.088:
8]
G 常规日期/时间(长时间)
M或m 月日
R或r RFC1123模式
Y或y 年月
您还可以使用自定义的格式设置字符串,例如dd/MM/yy。
有关.NETFramework格式设置字符串的详细信息,请参阅FormattingTypes。
例:
说明:
如果参考进价>=100000,则保留1位小数,否则保留2位小数.
=IIF(Fields!
参考进价.Value>=100000,"F1","F2")
PublicSubMain()
'Displaystringrepresentationsofnumbersforen-usculture
DimciAsNewCultureInfo("en-us")
'Outputfloatingpointvalues
DimfloatingAsDouble=10761.937554
Console.WriteLine("C:
{0}",_
floating.ToString("C",ci)) 'Displays"C:
$10,761.94"
Console.WriteLine("E:
{0}",_
floating.ToString("E03",ci)) 'Displays"E:
1.076E+004"
Console.WriteLine("F:
{0}",_
floating.ToString("F04",ci)) 'Displays"F:
10761.9376"
Console.WriteLine("G:
{0}",_
floating.ToString("G",ci)) 'Displays"G:
10761.937554"
Console.WriteLine("N:
{0}",_
floating.ToString("N03",ci)) 'Displays"N:
10,761.938"
Console.WriteLine("P:
{0}",_
(floating/10000).ToString("P02",ci))'Displays"P:
107.62%"
Console.WriteLine("R:
{0}",_
floating.ToString("R",ci)) 'Displays"R:
10761.937554"
Console.WriteLine()
'Outputintegralvalues
DimintegralAsInteger=8395
Console.WriteLine("C:
{0}",_
integral.ToString("C",ci)) 'Displays"C:
$8,395.00"
Console.WriteLine("D:
{0}",_
integral.ToString("D6")) 'DisplaysD:
008395""
Console.WriteLine("E:
{0}",_
integral.ToString("E03",ci)) 'Displays"E:
8.395E+003"
Console.WriteLine("F:
{0}",_
integral.ToString("F01",ci)) 'Displays"F:
8395.0"
Console.WriteLine("G:
{0}",_
integral.ToString("G",ci)) 'Displays"G:
8395"
Console.WriteLine("N:
{0}",_
integral.ToString("N01",ci)) 'Displays"N:
8,395.0"
Console.WriteLine("P:
{0}",_
(integral/10000).ToString("P02",ci))'Displays"P:
83.95%"
Console.WriteLine("X:
0x{0}",_
integral.ToString("X",ci)) 'Displays"X:
0x20CB"
Console.WriteLine()
EndSub
PublicSharedSubMain()
DimmsgShortDateAsString="(d)Shortdate:
......."
DimmsgLongDateAsString ="(D)Longdate:
........"
DimmsgShortTimeAsString="(t)Shorttime:
......."
DimmsgLongTimeAsString ="(T)Longtime:
........"
DimmsgFullDateShortTimeAsString=_
"(f)Fulldate/shorttime:
.."
DimmsgFullDateLongTimeAsString=_
"(F)Fulldate/longtime:
..."
DimmsgGeneralDateShortTimeAsString=_
"(g)Generaldate/shorttime:
."
DimmsgGeneralDateLongTimeAsString=_
"(G)Generaldate/longtime(default):
"&vbCrLf&_
" ............."
DimmsgMonthAsString ="(M)Month:
.........."
DimmsgRFC1123AsString ="(R)RFC1123:
........."
DimmsgSortableAsString ="(s)Sortable:
........"
DimmsgUniSortInvariantAsString=_
"(u)Universalsortable(invariant):
"&vbCrLf&_
" ............."
DimmsgUniFullAsString ="(U)Universalfulldate/time:
"
DimmsgYearAsString ="(Y)Year:
.........."
DimmsgRoundtripLocalAsString ="(o)Roundtrip(local):
...."
DimmsgRoundtripUTCAsString ="(o)Roundtrip(UTC):
....."
DimmsgRoundtripUnspecifiedAsString ="(o)Roundtrip(Unspecified):
."
Dimmsg1AsString="UseToString(String)andthecurrentthreadculture."&vbCrLf
Dimmsg2AsString="UseToString(String,IFormatProvider)andaspecifiedculture."&vbCrLf
DimmsgCultureAsString ="Culture:
"
DimmsgThisDateAsString ="Thisdateandtime:
{0}"&vbCrLf
DimthisDateAsDateTime=DateTime.Now
Dim utcDateAsDateTime=thisDate.ToUniversalTime()
DimunspecifiedDateAsDateTime=newDateTime(2000,3,20,13,2,3,0,DateTimeKind.Unspecified)
DimciAsCultureInfo
'Formatthecurrentdateandtimeinvariousways.
Console.Clear()
Console.WriteLine("StandardDateTimeFormatSpecifiers:
"&vbCrLf)
Console.WriteLine(msgThisDate,thisDate)
Console.WriteLine(msg1)
'Displaythethreadcurrentculture,whichisusedtoformatthevalues.
ci=Thread.CurrentThread.CurrentCulture
Console.WriteLine("{0,-30}{1}"&vbCrLf,msgCulture,ci.DisplayName)
Console.WriteLine(msgShortDate & thisDate.ToString("d"))
Console.WriteLine(msgLongDate & thisDate.ToString("D"))
Console.WriteLine(msgShortTime & thisDate.ToString("t"))
Console.WriteLine(msgLongTime & thisDate.ToString("T"))
Console.WriteLine(msgFullDateShortTime & thisDate.ToString("f"))
Console.WriteLine(msgFullDateLongTime & thisDate.ToString("F"))
Console.WriteLine(msgGeneralDateShortTime& thisDate.ToString("g"))
Console.WriteLine(msgGeneralDateLongTime & thisDate.ToString("G"))
Console.WriteLine(msgMonth & thisDate.ToString("M"))
Console.WriteLine(msgRFC1123 & utcDate.ToString("R"))
Console.WriteLine(msgSortable & thisDate.ToString("s"))
Console.WriteLine(msgUniSortInvariant & utcDate.ToString("u"))
Console.WriteLine(msgUniFull & thisDate.ToString("U"))
Console.WriteLine(msgYear & thisDate.ToString("Y"))
Console.WriteLine(msgRoundtripLocal & thisDate.ToString("o"))
Console.WriteLine(msgRoundtripUTC & utcDate.ToString("o"))
Console.WriteLine(msgRoundtripUnspecified&unspecifiedDate.ToString("o"))
Console.WriteLine()
'DisplaythesamevaluesusingaCultureInfoobject.TheCultureInfoclass
'implementsIFormatProvider.
Console.WriteLine(msg2)
'Displaythecultureusedtoformatthevalues.
ci=NewCultureInfo("de-DE")
Console.WriteLine("{0,-30}{1}"&vbCrLf,msgCulture,ci.DisplayName)
Console.WriteLine(msgShortDate & thisDate.ToString("d",ci))
Console.WriteLine(msgLongDate & thisDate.ToString("D",ci))
Console.WriteLine(msgShortTime & thisDate.ToString("t",ci))
Console.WriteLine(msgLongTime & thisDate.ToString("T",ci))
Console.WriteLine(msgFullDateShortTime & thisDate.ToString("f",ci))
Console.WriteLine(msgFullDateLongTime & thisDate.ToString("F",ci))
Console.WriteLine(msgGeneralDateShortTime& thisDate.ToString("g",ci))
Console.WriteLine(msgGeneralDateLongTime & thisDate.ToString("G",ci))
Console.WriteLine(msgMonth & thisDate.ToString("M",ci))
Console.WriteLine(msgRFC1123 & utcDate.ToString("R",ci))
Console.WriteLine(msgSortable & thisDate.ToString("s",ci))
Console.WriteLine(msgUniSortInvariant & utcDate.ToString("u",ci))
Console.WriteLine(msgUniFull & thisDate.ToString("U",ci))
Console.WriteLine(msgYear & thisDate.ToString("Y",ci))
Console.WriteLine(msgRoundtripLocal & thisDate.ToString("o"),ci)
Console.WriteLine(msgRoundtripUTC & utcDate.ToString("o"),ci)
Console.WriteLine(msgRoundtripUnspecified&unspecifiedDate.ToString("o"),ci)
Console.WriteLine()
EndSub'Main
EndClass'Sample
'
'Thiscodeexampleproducesthefollowingresults:
'
'StandardDateTimeFormatSpecifiers:
'
'Thisdateandtime:
4/17/20062:
29:
09PM
'
'UseToString(String)andthecurrentthreadculture.
'
'Culture:
English(UnitedStates)
'
'(d)Shortdate:
.......4/17/2006
'(D)Longdate:
........Monday,April17,2006
'(t)Shorttime:
.......2:
29PM
'(T)Longtime:
........2:
29:
09PM
'(f)Fulldate/shorttime:
..Monday,April17,20062:
29PM
'(F)Fulldate/longtime:
...Monday,April17,20062:
29:
09PM
'(g)Generaldate/shorttime:
.4/17/20062:
29PM
'(G)Generaldate/longtime(default):
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- RDLC 报表 格式 设置