??? ???????? ?????????? ??????? ? ???????? ???????? ?????? ???.17 ??????????? ????? ? ????????, ??????????? ????????? ?????? ????????. ? Reporting Services 2005 ??????? ?????? ???????????? ??? ????? ?? ???????. ??????????? ? ????? ????????? ???????????, ????????, ?????? ?????? ?????????????, ????????? ?? ? ????? ??????? ? ? ??????????? ?? ???????? ???????, ????????, ?????? ???????? ?? ??? ???? ??????. ???-?????? ???-?? ???:
=Switch(ReportItems!textbox15.Value = -1, "images/Stoplight_Single0.gif", ReportItems!textbox15.Value = 0, "images/Stoplight_Single1.gif", ReportItems!textbox15.Value = 1, "images/Stoplight_Single2.gif")
?????? 1
??? ???? ?? ????? ??????. (???? ????? ????????? ???????? ??????? Aggregate()). ? ??? ??? ????? ??????? ?????? ??????. ? Reporting Services 2008 ? ????? ???????????? , ?????? ???????? ? ?????? ?????????, ???????? ??????? ?????????? ?????? (Gauge) ?? Dundas, ? ? 2008 R2, ?????? ??????????? ? ?????????? ??????????????????? ????? SQL Server, - ?????????? (Sparklines), ?????????? (Data bars) ? ?????????? (Indicators) - ???.1
???.1
??????? ??????? ?????????? ????????? ? ???????? ??? ? ?????? Product_Gross_Profit_Margin_Status (??????? ??????). ?? ???????????? ??????? ????? ??????? ?? ??????? ??????????????? ????????? (?.?. ??????? KPIStatus ?????????? ??? ??????? KPI ???????? ?? ?????? -1, 0, 1).
???.2
?????????? ???????? ? ?????? ???????? ???? ??????????. ??? ????? ???? ???????? ?? ?????? ? ??????????? ?????? ??????? ? ?? ???????????? ???? ??????? Indicator Properties, ???? ???????? ? ?????? ? ??????????? ??????? Gauge Data ? ??????? Indicator Properties:
???.3
???? ??????? ? ?????? ??????? ??????, ??????? ???????? Indicators ? ? ???????????? Indicator Collection Editor - ???????? IconSet:
???.4
????????? ????????, ??????????????? ???? ??? ????? ???????? ???? ?????????? ?? ???????? Value and States:
???.5
???????? ????????, ??? ?????????????????? ??????? ?? ???????? ?????????????. ??? ?????, ??? ? ???? ?????? ?????? ?????????? ????? ??? ??????? ??????????????. ?????? Add ? Delete ????????? ???????? ????? ??????????. ? ???? Value ????????? ???????? ? ???????????????? ?????????? ????????:
???.6
? ?????????? States Measurement Unit ???????? Percentage ?? Numeric, ?.?. ???????, ???????? ? ???????? Start ? End - ??? ?? ????????, ? ?????????? ????????:
???.7
??????????? ????????????? ????? ??????????, ???? ???????? ? ?????? ? ??????????? ??????? Gauge Data ? ? ?????? ??????? ??????? ???????? IndicatorStates.
???.8
????? ????? ????? ???????? ????????? ????????, ???? ? ????? ??????.
???.9
?????????? (Copy/Paste ? ??????????? ???? ??????) ?????? ?????? ??????, ? ??????????.
???.10
???????? ???????? ?????????? ??????, ???????? ?? ?????? ??????? ?????? ?? ?????????? ???? Value ? ???????? ????????, ??????? ????? ???????????? ???????????, ?? =Aggregate(Fields!Product_Gross_Profit_Margin_Status.Value):
???.11
??????????? ??????? ???????? ?????????? 3-??????????? ????????? ? ??????? ?????.
???????? ??????? ?????????? ?????? ? ??????? ??????????????. ???????? ??? ???????, ????? ?? ?????????? ? ?????? ???????:
???.12
? ????????? ????? ??????? ??????????? ? ???????????? ????????, ???????????? ????????. ???????? ??????? [Gross_Profit_Margin] ?????????? ? ????????? ?? 0 ?? 1.
???.13
???????? ?????? ??????? ?? ?????????? ??????? ??????? ? ???????? ?? ???????????? ???? Gauge Properties.
???.14
?? ???????? Back Fill ???????? Fill style ?? Solid, ? Color - ?? No Color, ????? ???? ???? ??????? ?? ???????? ???? ???? ??????:
???.15
????????? ?? ???????? Frame Fill ? ?????????? ?? ?? ?????:
???.16
???????? ?????? ???????, ??????? ?? ?? ???????, ???????? ?????? ??????? ? ???????? Gauge Panel Properties:
???.17
???????? ???????? Border, ???????? ???? ??????? ?????? ?? ??????-????? ? ???????? ?????? ??????? ???????:
???.18
???????? ???????? ????????? ???????.
???.19
?? ???????? Pointer Options ???????? ???????????? ?????????? ???????? (Value), ?????, ??????? ? ?????? ???????? ?????????. ????????? ??????? ???????, ????? ??? ???? ????????.
???.20
????????? ?? ???????? Pointer Fill ? ???????? ???? ??????? ??????.
???.21
?????????? ?????? ? ???????? ??????? ????. ??????? ?? ???.20 ? ???????? Value ?? ?????????? ???????? Gross_Profit_Margin ?????????? ???.11.
???????? Data Bar ? ?????????? ??? ? ????????? ?????? ??????? ????.
???.22
???????? ?? ???????????? ???? ???????? ?????????????? ??? ???????:
???.23
??????? ??????????? ? ???????????? ???????? ?? ???. ???? ???????? ????? ?????????? ? ????????? ?? 0 ?? 1.
???.24
???????? ?????????? ??????? ?????? ? ???????? ? ??????????? ???? Show Data Labels, ????? ????????, ??????? ????????????? ????? ???????, ???????????? ?????? ? ???:
???.25
??????? ? ???????? ????? (Series Data Labels)
???.26
? ??????????????? ????? (????????, ?????? ??????? 8) ? ?????? ????????????? ?????:
???.27
??? ????? ??????? ??????? ???????????? ???????? ??????? ? ??????????? ?? ???????? ??????. ? ????????? Chart Data ???????? Color, ???????? Expression
???.28
? ??????? ???????, ????????,
=iif (Fields!ProductShare.Value < 0.1, "Red", iif (Fields!ProductShare.Value < 0.33, "Yellow", "Green")):
???.29
?????????? ?????????? ???????? ?????????? ?????? ???????? ???? ? ?????????? ?????? ??? ?????? Category. ?? ???????? ???????? Fields!ProductShare.Value ?? Aggregate(Fields!ProductShare.Value) ? Value
???.30
? ????????? ????????? ??????? (???.29).
???????? ??????????? ???????? ???????:
???.31
????????? ?????:
???.32
?? ??????? ?? ???????????! ????? ???? ?? ??? ????? ? ?????????????? ??????? ??????? ? ??????? ???? ??????? ???????????. ?????? ????? ???? ????????? ?????-?????? ?????????? ??????? ? ???????? ???? ????? ? ??????, ?????????? ?? ???????? ? ?.?. ????? ???? ??????????? ??????????? ????????? ?? ???????????? ??? ?? ????? ? ??????? ??? ??????? ?? ????????????, ????? ??????? ?????????? ??????? ? ???????? ? ??. http://blogs.technet.com/b/isv_team/archive/2010/04/04/3322989.aspx. ???????????????? ????? ?? ?????????????. ????????? ????????? ??????? ??????????????? ????????? ? ???????? ???????????????? ??????????.
Amanda Marcum Leila Arcieri Kate Mara Izabella Scorupco Carla Campbell
No comments:
Post a Comment