ms bi reporting guide
TRANSCRIPT
-
8/8/2019 MS BI Reporting Guide
1/63
!
-
8/8/2019 MS BI Reporting Guide
2/63
"
# $ %%%%%%%%%%%%%%%%%%%%% %%%%%%&
"# $ %%%%%%%%%%%% %%%%%%%
$ ( %%%%%%%%%%%%%%%%%%% %%%%%% '
'# $ ( ) %%%%%%%%%%%%%%%%% %%%% *
+# , -. / $ %%%%%%%%%%%%%%% %%%%%%%% &.
0# , -." ( 1 $ %%%%%%%%%%%%%%% %%%%%%%%%'
2# , -.& $ %%%%%%%%%%%%%%%%%%%%%%%%%'0
3# $ %%%%%%%%%%%%%%%%%% % %%%%%%%+.
$ .%%%%%%%%%%%%%%%%%%%%% +.
$ " .%%%%%%%%%%%%%%%%%%%%% +.
$ & .%%%%%%%%%%%%%%%%%% %%%+&
*# 4 5 $ %%%%%%%%%%%%%%%%%%%%% +
.# ) %%%%%%%%%%%%%%%%%%%%%%%%%% % 0.
-
8/8/2019 MS BI Reporting Guide
3/63
&
!"
! #
$
#
!
" #$
!
%
%
-
8/8/2019 MS BI Reporting Guide
4/63
'
& '( ( ") '( )
+ ! '( ,--. / 0/ !
1 (/
-
8/8/2019 MS BI Reporting Guide
5/63
+
*/
2 (, 3 "4 (
0
-
8/8/2019 MS BI Reporting Guide
6/63
0
5 " 6 "7 8
-
8/8/2019 MS BI Reporting Guide
7/63
2
6 '( &9
79
-
8/8/2019 MS BI Reporting Guide
8/63
3
1 ( 1 (: %
6 &1 ( 6 6
6 & ; 0/ )+ (
&
-
8/8/2019 MS BI Reporting Guide
9/63
*
1 (.-.-
3
-
8/8/2019 MS BI Reporting Guide
10/63
.
%
(
-
8/8/2019 MS BI Reporting Guide
11/63
&3 !
/
-
8/8/2019 MS BI Reporting Guide
12/63
"
0
0
-
8/8/2019 MS BI Reporting Guide
13/63
&
0 / /
)5
-
8/8/2019 MS BI Reporting Guide
14/63
'
1 ( 51 (
!
500 !
!
2 !, 0 / "
94
> / !& '(
? "
@ / "
A / $. / "
B (
!C
2- ! ) ! 6 7 @ -22 !
-
8/8/2019 MS BI Reporting Guide
15/63
+
-
8/8/2019 MS BI Reporting Guide
16/63
0
7$! !0 $ $!0
3 &D E F &
&
-
8/8/2019 MS BI Reporting Guide
17/63
2
* " " "" "
-
8/8/2019 MS BI Reporting Guide
18/63
3
& 1 ( " ! 1 (
0 *
6
0 ! G 5
2 /
, /
4 1
> 2 -
6 7$,
$
-
8/8/2019 MS BI Reporting Guide
19/63
*
0 /!
/ !
* '(" "
$ $
! 6 9" !
& ! "0 !
! "
-
8/8/2019 MS BI Reporting Guide
20/63
".
0 ! H
% *
%
!
! " #
* 9 "
3
0
-
8/8/2019 MS BI Reporting Guide
21/63
"
+ 90
6
& 9
-
8/8/2019 MS BI Reporting Guide
22/63
""
0
-
8/8/2019 MS BI Reporting Guide
23/63
"&
5C
&
3 % ! & 9
-
8/8/2019 MS BI Reporting Guide
24/63
"'
! %
-
8/8/2019 MS BI Reporting Guide
25/63
"+
6
0 9 I
-
8/8/2019 MS BI Reporting Guide
26/63
"0
3"
-
8/8/2019 MS BI Reporting Guide
27/63
"2
2 -
3 6 " 0 !
-
8/8/2019 MS BI Reporting Guide
28/63
"3
$
:& )
& )
67 /
! # $ %
/9 9 :
% /9 9 9
; - --
; =A 9 9 B
& % / 79
' (% / @
9 9
-
8/8/2019 MS BI Reporting Guide
29/63
"*
& % ( # @ 5 -B 8 9
8 /
%
0 )
% !
C 9 )
-
8/8/2019 MS BI Reporting Guide
30/63
&.
)*+
0 0& &
& ' () * ! + & #
)# ," ' 0 )&
' *6 J
* %
-
8/8/2019 MS BI Reporting Guide
31/63
&
/
6
-
8/8/2019 MS BI Reporting Guide
32/63
&"
7 ) //
-
8/8/2019 MS BI Reporting Guide
33/63
&&
0 )
* $ + - # - . # - . # - .# -
+ , + - // 0, /
,/ + - # - 1 # -
2 3+ - # - 4 56666)
$ $
-
8/8/2019 MS BI Reporting Guide
34/63
&'
6 ) % 0" ;
0 9
-
8/8/2019 MS BI Reporting Guide
35/63
&+
;
0 9
-
8/8/2019 MS BI Reporting Guide
36/63
&0
$ 56666#
-
8/8/2019 MS BI Reporting Guide
37/63
&2
0%*
-
8/8/2019 MS BI Reporting Guide
38/63
&3
& ' 7) * #
)# ," ' > :9 9
' 6) 0
)
6 )
( 8 "
7(7/0 0+ 2- 1! * J J & 7 , JJ J
* +! * J 6337 =+63
+3 * J J" K J" 6337 =+63
+3 * J J" K J"
57 7 K L
; +1 C J J J
5&:63; K
+ %7 C 7 , %7 /
-
8/8/2019 MS BI Reporting Guide
39/63
&*
9
& 2-
-
8/8/2019 MS BI Reporting Guide
40/63
'.
& 1
-
8/8/2019 MS BI Reporting Guide
41/63
'
),+ -
!& " " 6
0 #9 $
0H
/ ) #2 C, +4 & 0
M M> & M M N
0
6 O
+
+ 9 H
0
0
!" N
09
-
8/8/2019 MS BI Reporting Guide
42/63
'"
& ' () % "
)# ," ' C ))
0% "
H
" % # % ." # #
%" (# # & % /" 0 1 #
' ! 6
&
7(7/0 ) * J J JJ
* +! * J 6337 =+63
+3 * J J" K J" 6337 =+63
+3 * J J" K J" 6337 =+63
+3 * J J" K J"
-
8/8/2019 MS BI Reporting Guide
43/63
'&
+ ,
0 )
-
8/8/2019 MS BI Reporting Guide
44/63
''
& ' 7) % "
," ' C )
' & H) )
0
&
7(7/0 0 J J J1! * J J & 7 2 J
* +! * J 6337 =+63
+3 * J J" K J" 6337 =+63
0 J +3 J" K 0 J J" 6337 =
+3 * J J" K J"
; +1 C 0 J J JJ
+ %7 C 0 J
-
8/8/2019 MS BI Reporting Guide
45/63
'+
$ ,
0
-
8/8/2019 MS BI Reporting Guide
46/63
'0
)2+
& %"
* 9
) $ $C
G
% 9/ / 9
# 0 $
:
9
+ 0 :* :
9
6 :6
: 6:
1 /$
C
:
0*
CN
-
8/8/2019 MS BI Reporting Guide
47/63
'2
& ' () #
," ' C / C )
' * "
2 &
, / P %
4 / )
)
! &
7(7/0 & 7 2 J J* J J
* +! * J 6337 =+63
+3 * J J" K J" 6337 =+63
+3 * J J" K J" 6337 =+63
+3 * J J" K J"
; +1 C J J * J J
5&:63; K L &3% J K L J
+ %7 C * J J %7 /
-
8/8/2019 MS BI Reporting Guide
48/63
'3
& )
-
8/8/2019 MS BI Reporting Guide
49/63
'*
& ' 7) ( ( % #
," ' C / C )
' )
! &
* $ ! 3+ - # - ) ( ;.! 3+ - # - ) ( # . # -
, % 7> # -
+
-
8/8/2019 MS BI Reporting Guide
50/63
+.
7
0 ! +) " 0
*0
) )) 1
7 ;#6
2 - "2 -;
" ' 5 2 -9 2 - "
!
7 & ! ) N ) )) )
? & 0
-
8/8/2019 MS BI Reporting Guide
51/63
+
7
-
8/8/2019 MS BI Reporting Guide
52/63
+"
7
-
8/8/2019 MS BI Reporting Guide
53/63
+&
6 6
0 6
CG
7 ?#6
! '( 4 -! + $ "
" 99
0 4 -, -
-
8/8/2019 MS BI Reporting Guide
54/63
+'
+ 4 -
2 7
7 /? /
0 ) 9'(
0 " 0 ! 0#
/ " 3
-
8/8/2019 MS BI Reporting Guide
55/63
++
* % 0 "
& %0 ! N " 3 % ) #
-
8/8/2019 MS BI Reporting Guide
56/63
+0
0 % ) )#
/ " 7 0 ) N
/ " 6 ) C)
C $ )
/ " 7 0 P ) #
7(7/0 1! & 7 2 J0 CJ3 & /
* +! 6337 =+63
+3 J6% K J6% 6337 =+63
+3 J6% K J6%
57 7 C K L
; +1 C J0 C J3 &/
-
8/8/2019 MS BI Reporting Guide
57/63
+2
/ " 3 & * %& :
/ " 3 / ( #
& " 3 /#
-
8/8/2019 MS BI Reporting Guide
58/63
+3
/ " * #
C " 6C "
5 N 6
/ " % " %/ " 5
C #
-
8/8/2019 MS BI Reporting Guide
59/63
+*
/ " S ,--2 " S / N#
&9 /
7 '( ,--. $ !
&" 6
H
-
8/8/2019 MS BI Reporting Guide
60/63
0.
% ,
$ 7
0 '( ,--. 1 (
/ " #
/ " + #
7 1 (6 1 (
-
8/8/2019 MS BI Reporting Guide
61/63
0
'( ! ,--. $ "+ H 7 " " 1 ( *
1 ( #
#PP; #.-.-P J '(,--.
0 1 (/ " 1 (
& "
1 (
&" 1 *
-
8/8/2019 MS BI Reporting Guide
62/63
0"
% 9
In deployment issue we need to carefully configure the report services configure manager thenwe have web environment. Where we can view our report on web and give it to user also.
To show report into web we need to set the right Target Server URL. Where we want to publishour report.
For deploy go to Solution Explorer
In output window all history about deployment is shown. Where and what thing are successfullydeployed the deployment URL is also there
-
8/8/2019 MS BI Reporting Guide
63/63
If you have right configured reporting services configure manager then after right deployment,one new folder will created with the name of new report. From there you can access your report.