RDLC报表格式设置Word文档格式.docx
《RDLC报表格式设置Word文档格式.docx》由会员分享,可在线阅读,更多相关《RDLC报表格式设置Word文档格式.docx(9页珍藏版)》请在冰豆网上搜索。
例如,格式设置字符串D0将数字格式设置为小数点后没有数字。
您还可以使用自定义的格式设置字符串,例如#,###。
设置日期格式
下表列出了常用的.NETFramework日期格式设置字符串。
格式字符串
d
短日期[2008.08.08]
D
长日期[2008年08月08日]
t
短时间
T
长时间
f
完整日期/时间(短时间)
F
完整日期/时间(长时间)
g
常规日期/时间(短时间)[2008.08.088:
8]
G
常规日期/时间(长时间)
M或m
月日
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"
$10,761.94"
E:
floating.ToString("
E03"
1.076E+004"
F:
F04"
10761.9376"
G:
_
G"
10761.937554"
N:
N03"
'
10,761.938"
P:
(floating/10000).ToString("
P02"
ci))'
107.62%"
R:
R"
Console.WriteLine()
Outputintegralvalues
DimintegralAsInteger=8395
integral.ToString("
$8,395.00"
D:
D6"
))
DisplaysD:
008395"
"
8.395E+003"
F01"
8395.0"
8395"
N01"
8,395.0"
(integral/10000).ToString("
83.95%"
X:
0x{0}"
X"
0x20CB"
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):
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."
DimmsgCultureAsString
Culture:
DimmsgThisDateAsString
Thisdateandtime:
DimthisDateAsDateTime=DateTime.Now
Dim
utcDateAsDateTime=thisDate.ToUniversalTime()
DimunspecifiedDateAsDateTime=newDateTime(2000,3,20,13,2,3,0,DateTimeKind.Unspecified)
DimciAsCultureInfo
Formatthecurrentdateandtimeinvariousways.
Console.Clear()
StandardDateTimeFormatSpecifiers:
vbCrLf)
Console.WriteLine(msgThisDate,thisDate)
Console.WriteLine(msg1)
Displaythethreadcurrentculture,whichisusedtoformatthevalues.
ci=Thread.CurrentThread.CurrentCulture
{0,-30}{1}"
vbCrLf,msgCulture,ci.DisplayName)
Console.WriteLine(msgShortDate
thisDate.ToString("
d"
))
Console.WriteLine(msgLongDate
D"
Console.WriteLine(msgShortTime
t"
Console.WriteLine(msgLongTime
T"
Console.WriteLine(msgFullDateShortTime
f"
Console.WriteLine(msgFullDateLongTime
F"
Console.WriteLine(msgGeneralDateShortTime&
g"
Console.WriteLine(msgGeneralDateLongTime
Console.WriteLine(msgMonth
M"
Console.WriteLine(msgRFC1123
utcDate.ToString("
Console.WriteLine(msgSortable
s"
Console.WriteLine(msgUniSortInvariant
u"
Console.WriteLine(msgUniFull
U"
Console.WriteLine(msgYear
Y"
Console.WriteLine(msgRoundtripLocal
o"
Console.WriteLine(msgRoundtripUTC
Console.WriteLine(msgRoundtripUnspecified&
unspecifiedDate.ToString("
DisplaythesamevaluesusingaCultureInfoobject.TheCultureInfoclass
implementsIFormatProvider.
Console.WriteLine(msg2)
Displaythecultureusedtoformatthevalues.
ci=NewCultureInfo("
de-DE"
ci))
Console.WriteLine(msgLongDate
Console.WriteLine(msgFullDateShortTime
Console.WriteLine(msgGeneralDateLongTime
),ci)
EndSub'
Main
EndClass'
Sample
Thiscodeexampleproducesthefollowingresults:
4/17/20062:
29:
09PM
UseToString(String)andthecurrentthreadculture.
English(UnitedStates)
.......4/17/2006
........Monday,April17,2006
.......2:
29PM
........2:
..Monday,April17,20062:
...Monday,April17,20062:
.4/17/20062: