|
|
Subject: [Reporting Services] Problemi con SP2 su Matrix e funzione ins
From: Andrea Benedetti
Date: 5/2/2007 5:51:46 PM
Ciao Alessio,
"theorangejuice" <theorangejuice@discussions.microsoft.com> ha scritto nel
messaggio news:0D04B360-3114-4906-A840-4B34806F6B43@microsoft.com...
[cut]
> Per verificarlo:
>
> ho fatto una dataset su AdventureWorks con questa query:
>
> SELECT COUNT(*) AS EXPR1, MaritalStatus, Gender, SalariedFlag, Title
> FROM HumanResources.Employee
> GROUP BY MaritalStatus, Gender, SalariedFlag, Title
>
> poi ho fatto una matrix con enable-drilldown:
>
> matrix1_MaritalStatus
> matrix1_Gender
> raggruppamenti di riga,
>
> matrix1_SalariedFlag
> raggruppamento di colonna,
>
> poi ho aggiunto i subtotali a tutti e tre i raggruppamenti e sulla textbox
> dei dati:
>
> =iif(inscope("matrix1_Gender"),"none","Underline")
>
> a questo punto
>
> aprendo il drilldown "MaritalSatus" vengono fuori le righe per "Gender" e
> i
> valori nell'incrocio con i totali di colonna dovrebbero essere INSCOPE e
> invece NON LO SONO.
Scusa per il ritardo della risposta...
Ho seguito il tuo esempio.
A me sembra che il risultato sia corretto... oppure ho capito male? ;-)
Ti allego l'immagine.
> Ciao.
>
> Grazie
Ciao!
--
Andrea Benedetti
Microsoft MVP - SQL Server
www.absistemi.it - www.ugiss.org
http://blogs.ugidotnet.org/ab
http://mvp.support.microsoft.com
http://italy.mvps.org
begin 666 inScope.gif
M1TE&.#EAZ 'A`(<`````````2 ``= !(2$@``'0``$@`2$@`='0`2 !(G !T
MOTATOT:"M'" D&V"M'" I'" N$:"P4:"ST:9VTB<X$:OYVZ>RFZ>TVV9VVZ>
MW'"7RW"OW&ZOY72_X'2__V[ [FW$\YQ(`+]T`."<2/^_=(" @(R D(^"M)R_
MG*6 D+V7D*Z9M+V7I(^"P8J>RJ2>RKRORKROTX_$VXS$[HK0Y8_9YXK0]H_9
M_YS@_Z78_[S Y:3@]J3@_Z[L_[WL_[SP_[___]2OD,JOM-2ON.K$I.K$N/_8
MN/_@G/__O]/ RM/ W-30R-/3T]38W-3LR]/@W,K__]/@[M3L_]/PY=/P_]/_
M_]3__^7$P>K$R^'>V>K0T^K0W/_9S^K0Y?_LR__@W/_LV__LW/__W.7_\^#_
M_^7__^KP_^K____L[O_PY?_P[O__X/__Y___[O_P]O__\___]O___P``````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M`````````````````````"'Y! ```/\`+ ````#H`>$```C_`$MD&9BEQ!(`
M<1(J7,BPH<.'$"-*G$BQHL6+-JW,BQH\>/($.*'$FRI$6!! TB-,FRI<N7
M,&/*G$FSILV:* >JO,FSI\^?0(,*'4J48<Z"!XLJ7<JTJ=.G4$<>W1FUJM6K
M6+-J-3DUZ=:O8,.*'<NTZTJR:-.J7<M6H]FV<./*G0OV[5@N#/(RJ$"WK]^_
M2NTN9'-"K^'#>OD&Q9O8(Q@'B&\`GDRY<D/!"@DCWIQ7,4G-G2DR#KUQ-.<)
M92RK7BT7<T+0G ]['@E[-D33MBU>B:T7->O?P,FZC@.;-^G/A8^_-!W;=_#G
MT*\.;_BX=^J7M64*,>P\X6X&W:.+_Q]?=#K#ZGG#-]S._3K#[X8EQV&_.4*/
MAZ;EYX^S/^&;%7I)`(5#7*@'7U[V,?3?82 TM!]\"3I$7WKND6?A9.8MA!YX
M%2XT(8,+'7@8:A\:%J\25D6@W)&=8@<2TR\*)$(K:74(EZS<B?83) !J*'
ML>EXX9!S9:C0ANK=:)Q\-;:'(X+W$9CBCL8EN.!A`D+T)(57!JD0<_5%.=^2
M1);9&D%(G041DAU2R4"$7:(&6Y9Q+.A;=A/U!^9F+S;9V$*FG;@=:@<J!EN$
M>R*FV&AP`DBAF9"N961";"KH* /RJ:B7?1O:!@8&J>$ID9Z&T5FH?Y=RIEB7
M)ZHXP1B7TO_IIHR:6N==J5!TF:F;K4;J:UUH4A51I1KZN&1QO;[68FY2ZJ7?
ME'%TJE"7JD9K++/6_JFLK?W5>2FGQO*VZZ_D9C5IMH\":IRSU.*:V;*B3=FM
MJ IMB:EI0G[IXD)=9MEM' ?>D&ADY19L;K!>#6NL>@,?)MF&B+U([VWR0CLQ
M0R6"@"]^^TX;ZX#_!MPPM :7_-2YQ.KK+$5/)GAQLWD]N_*VRCTT804;PTRK
MQP&"3++())LLM'0(J_E0RI0:FV]$Q6$*H[81D3KSTZ&QT8*8#.$KK4-;H\HM
MR?2!F^/09!.=4L)K+MPAJUB_=O6G'6X,6Y(HSCPOO*!Y&NX-;&?__>K'1RI=
M:\SO6M<W0U:W7?;B/:&L=MU3+RCV;&'?1^VX.LM,.,U[46V<;X&*N1MJN'&.
MZ)34OLA<II(KSOCK-#ENZWI5]@"QH@HUF>S@3L^::79-AUDO;[[9N_.LI[EG
M_.ZP-_^2[.DVY">4MQLV6_#,2[VYYWP%C^6 (39WW9:[CFP@;\P[KWY)T',8
M48VM@DFWB-E7/#6]U=-]J\.6_JBNLQ-:VOY,Y+KU&9 DYSK@OP[(0*(DT( +
M;* $?_+ ]45P@ABT2075=\$,>C F&W1>!S](0I:$L(0H3"%(3JC"%KKP)$5[
MH0QG^!$6TO"&,K0A#G>80AWR\(<>- L3_X9(Q"(:\8A(3*(2E\C$)CKQB5",
MHA2G2,4J6O&*6,RB%K?(Q2YZ\8M0%"(03<($"YCQC&A,HQK7R,8VNO&-<(PC
M&LLHQSK:\8YXE",=\\C'/OKQC6(<(TGV^,="&I*/A#RD(A?IQD0R\I&0#*0@
M1>)(2%KRD)6\I";[F,E->M*.DIPD2#KYR5*^D92F3*4:4:G*5EH@E*+T""M=
MF<I9TK*4MKRE)V$92X[D,HT<. ,<8*!+0_ZRF)8\IAV#.4QDNI&7O=0((3-0
M!88D@8W,)*8S.7E&:C:D#2_89C*[64V&@'.-WKPF-H6I37&F$9K1Q,@TJZE.
M-V;3G7ETY#WQ"?])?;+3C>ELXS[Y:49XQM,B\XQ#/2W@S82<\YXV4$@S&]I,
M@EK GQ5EI@[.\(5@@O,"/XB#%AA:SHI:=(YJ'&@P$S),D"Y$">6,PT/_>5*#
M'I0B"5UH!J;@`@M$- TNR.8'X@!4"^P`!AY]`35-BD^,:G.E">GH&3X:4BTD
M=:GM/.E%4TK3JU9AF '=:4]_&E2:6M2F-Y5(0A5RSC,F-9L1-6E$OV !ER[4
MG4XUXSZ3ZE(MS+6N(;VK1?-J`1[$@:Z%%6E T?A6LQ(4K6F%2$[3&%&VOB";
M4)7I"PS+D)$2E+![G>H+^LK9A7A6JUL%)DT-B]BY+K:R#KVL8_D)V<C_.F2R
M9R1K8TTZ5)&R%K5F!&U714O:PP)WE5RMZ%\3JX6 ZE:T`WULT9A@VXS@UHR_
M'2HXX7I-N^Z3!X+=IG KBE5O6G6UX>6G<,&)5;LFEJ[:E2U3:3O=ZLH3C8LU
M8T/=`%UVPE:A^HTI@#^;W*>:M;)P,(-(2;J0]#:UP&X]`TNUV=LXP#0A_-WN
M;/%96_LJ1)G'M2.(0ZQ'$ENRPQZ.PXA-?$H6/W+%+F8CBCT,XQ@CU\:8Q/$A
M9VS?&NLXN#\NI(]_S./J#EG'1\9QDFU<9-LN.<9/=G&46=SDR$[9Q%<F<99#
M+$0P>OG+8 ZSF,=,YC*;^<QH/K,0@_Q')C3@_\UPCK.<YTSG.MOYSGC.LY[C
M3%W5]-DR?Z[,FMG,R3T;^M"(3K2A`TT91D_&T8 9-*'SJ>A*6_K2>H;T7S3M
M%T[W1=*3OJ.;,4WJ4E_:TW1!]5Q4?::S`6#+QQVUJ6=-ZSRS.BZWADNNVP+J
M4-=1UK4.MK#?O&NV%'LMQU:+I ' [&8W^XW>;&MO$8M:8$/ "@P)PK"WG>AD
M-V4-(6BV!Q*"A (`0 ! :(BWG8($!.! (>4^=[H9LFZGC" `[XY#O-%]F>F>
MT6@)`0"TRZE.SE);J];&MK:YS7!$UULI1UA 0DB ;W!3( XC2 `9Z)T6< ,`
MWPH1P<5'H !UK^4(!/\`N<4QKG&C^-N,`(^#P %:3J!"]> G37@<%M[PGMNZ
M+4<P``Z"_FZB<UPM1M>WN^-PA /,^\-J:3<*A,YTJB==(<MVR,S;2%$8P!;G
M@XWSM7?N\[+?^>%-(7G5WUWN<2\$[1"G^MKG_O:.A\ #1C=ZVUWNZCTBQ-E_
M'W@<HA"'+E1!#50P+G!UKA QI,#LD"?V6D; ['&7^^(H=SO4D2[WO,M]\V01
M0<GU7@#,$T#S"<EZ0[;.1F]>. Y;""G8/RMVA4?^]I)GB]%)P.P!?#XA<"]*
MTCV?;]"+Q>/.'C?O`>#[XJ?^Y1:(.>O124_#PB$&LH]U[<F.^\@'7RE[5PC_
M"5I>=\[GN]U%=_K1S<^0\6]\(:IGR/35F,Y@?L&ELU?O]GG>_;)_/R@D<'%Q
M0''%MW+KAQ97)W(85W('B("_9X#P!WV YVR"5T_XIWUP-G;\UW\]]W] @7+,
M!G(#R&P"V(!A@7P`T'+[]G3&YX#YMGPE&(%]YVMX!&P<B'L>F!4YB!4[:#8Z
M<1"PMG@WR($]:!5%6!5':!,3N(3,)H,_^&HT*&I#V'])"!55^!17Z!2]%H6G
M-(7=EX5-`89,(89+L85<V$8VZ(7^MQIDJ!1M6![0=X9=J(;>QX9VJ!IF*(>K
M1(=UZ&=W:!EYJ(=SE&:$6(B&>(B(F(B*R$2!*(C!_\6'D/>&1"&)0T&)0M&(
MCIB&D,AMEA@4G0@4GTA!<>B(>[B)/A>*/H&*/:&*/(&)@JB)IBALK'@3LV@3
MM8@3HTB*<Q2+'?B'E7&+L9.+NOB(O,APP#@3QR@3R0A"PCB,.N=X;[8!"6$$
MQ5AIRX@1R]=L);>")A=U2Y<0( @`J =\46=N_):-S,: 6->,NLAX"Y<#TUB-
MBG:-&V%Q*Y=Q[]>")QAN(@ANRL=OY4<6]TA^"0&!SS>#PUB*;S9V<> %)J !
M$A8'U"B/#M<6)(!NQ&>"8I%TZ*=TSJ=B:9&1X@>0ZXB0";F+&8AM,J4",Z 0
M$TF1B\86*T=ZXTB/&)& ^/^F=AKY%32I$ 9YD$\8A-6V?4T0!UA@!6$@!1()
MDX=FD]C(;Y?'=*>WDV!Q==DXCB")%E&9>2/)@D"9)D*)<-LW!"I9!#ZPE$RY
M9TYI$>$W@LSW>UD9DG+7D5P9D&2Q?,U';@6 E7'@BGJH<T$`CVW `F?YDFF)
M9VM9$?C8$.Y'E3S9>>KWDXEI$8W)<OGHA&!YDFD$F!!I! ]0F(>9:>6(E3\9
MERZHEY@'EY-)$0;8EGP7E)J)D@MI>V_VF6@9FF>G%B) D&X9@_H(%BC8<N&(
ME:L9$3 8<KR)F2H1ECF'FZ96G)3DBY3AEW((B\Y9D7Z8G63!A$NHG$ 8FV=D
MG=?_&9/:^8NK09UG*)[C*9KEV6CGR8ZDJ)[KB9C2^6CO:9*Q*9_S:6?0&1+]
M.4KW"9O@>5'[:8WU"1C_64/PF8F+V* .^J 0&J$2:D3HR87Z6:!SEJ"R=*!_
M4:%1>*$8RF<<VFD!FID#"J(AFGN -J*?MJ"OF*)-R:*I5J++.: $"J-J*:.K
M1J/?>:+;!I%MH *QJ*$=0:2^Q*-0Z*.SV1#0.&<::&= *J2FF* ="6_?*)65
MYYA9$6\?EV_#V8U@4:4*<6_%=YS>F:3@F891>F=/6F=K.J7 R8_YYG']>'<#
M2)*FN9$2AW'HYH]WZI7]2:?.AW(B>)%>^94UJJ1Q]J8-_P"1#J4"MJD09-EX
MC\>HD)B@5T=W'2FF>>J"FWJEY!@65R=U5.>G#N&A-*BF4R6E$.EXUQ:D3PH!
M3F "#="2#FFI?(BIOX>3.*"3OSD6AAH'(I"3ZOBK5Y%T_DAZXO::)IJF<_:F
M\#B1\$@$;0IGK9H"N$J'NCJHGW>56KH54>F6X@BFCYEOHC=WNX>GJ.IKJAJD
M;Q:M;]:21M"F+4FIV:J&V[H0'+ET=1FJ:1&N=#F5=KD51H>"E==TZ>::ZQIJ
M[2JE\OJN<4"MMF>K#WD&CG>O7IBO"C%\D1D",6BDJ+FQ'>N;&KNQ5/>ISK>P
MD]:P;W:MKPJI9ZEM\"J-%[NJ0_^ZD;LZEZ5'=_XZ%N$:LIG:J5D1M$EWKHM9
MD@+JK'+&J(ZZDM$HJ2J)!A:+K38+IU\1G&2 M5@ZK@,;%N@(`*:7I=_J%%H+
MCCK;I<R:J$J+HS_7GO:)AR[ZEVS+GEO!G7;;;,:J%7?K;%U[%7MKMTC;K/DY
MMVV[HFX;:7%;G81+GX>[:4C*G&&WN/RIHW(!LFZ1N.DIN9/;N"0*M_BIF2B:
MHI9K790;%UTVH:B;NJJ[NJS;NHNHLH06NB$ZNO)4NG !NVPFNQA*NQ?!NPCU
MN#:JNP7JNQ5!O#@%O(JJN7)FO!/!O&J%O&NKO"+*N7WAO!&!NT$FO/MIO9)E
MN[R&N5S_%U/S-90IF6US"[)<*H()0:;D2A:<RJEYFQ4H.&[AB+9GZG=,^$8K
M=4W4E'^1NZ0;R+8@&W'K"Y"$^I%">[5R6I +W+ZBNJ<$&+3W^V]:]T81U589
M\ 18MG^:R[MZAP!3A\"CFZD2G, X.W1P.<$P5\%N5&%%Q6* V<$6V:=W)\$C
MG+,(;,)AH7;AJ+Z!J[;2]T8NU6 ;7+Z4>KYL$97G:L,GA\.W-7EB&W)XVI<2
M*'-\.W_K%%M:QL&2.[I1:;!<&[]:0<(IK,-5Z<0J''TLW$8T$$YF=,%NC($`
M+,/_NK,,P<3L9[(YS+NN&;3QMQ!8C$81U5W9M\7E&\ XBKYV_WS'*7S#W+K'
M:1& $X=O!"RLR?G'"A'(Y$3$13S'71S)@%>">"R0X<9L&E>V8GRL!!"";&=N
M*7B9B-JCT9>_BBN]R^N]Q@:]@VO+TVNXOCP6?]N$/RS+N\S+*FJ>U$L7V/MC
MVCN?W/L0S_S$GINTQ6S,T>S "*K+H&O,<';-8XMKVGR2S;R>WMRWCCO-@@NZ
MKKO.[-S.[HR(RXQDW'S,[IG,10*^'SK/#5#.J0S.Z*RVU<S+_-RS]0R(^)RJ
M^CS09KRC_TS,VSS/"AW1X9R0XSR>$FW/K4;-#[VD32J-M[F[Y2AOXD>"V!P6
M53J_)7T58LJ-^F:.7AG/2K9]W >/'_\]O'8W<BT7K-),RO9;R03XS4PAJ"$W
M<B4WD)<)TS;&>+<:D89ITZ=)=*:ZTZ?)R!^IL73I="(9RVA:S0P9I/5:T]LK
MEZWL`5P:QOU\K"GLJV?=%,-G=4+7D\.\U1O=`&-7E$>9EMS'5L>GA'=3J]
MUE61J91GU@0]QIWGUCBPE0*KU9!+>^4[J7%@EGE-SFJ!EV^M?JZYT$.;PD&K
ML1EIV2E[T.RZ?X))F)-MT1:I<2@+U%8AP9EMU?RJ?N+'FT@-9?O7F;;9U&&]
M%@9HM,GIR!,G@#]MSFA=? JHUC]9VU+&Q0V0VS!JN6;:TO9+W%J!M3TLPG':
M;"KHTA-'TFG_Z]#BG-"XC&P3[8SBC='^7+?!W)V,';SG_<L%+6BBS;#OC<SP
MC2'SO;+U'=_\C=^?&]X0/=YJH=#*#</[_;;WC;C_3='OW. ._N 0CD4%WLG6
M+.!I0>#Y';L'GLWH?;L9GKL;?LX)WJ$?GKTAWKDC[A<3;LC<?-$IWJ(+;M[#
MAK%3Z.+V+=\QWHY&O!!-*F?5^JQ5NXE4^HWI>W[<3=U;ZLH^S+ZLS13PR^3K
MZ\-4G./Q">3N:F<_OK1!?JG9+8*5/ +\=MS%JMFMO:=@/F\'G-)1(=0;FW+%
ME^9I'-"-&N1-&Z21FA"0'0?02.-#6+)Z?-4LZ,$G"\*-?,)6&L+D_T;H'[GB
M(<:R<^ZJ5@"KMB>KM$JQ?'Z#?CYQ&(G82/X5AIJLA2ZJ<@?J[T;JWRW7`+ZH
M50NO#3"M67ZMETZ$AKX06\GI@%T52CQZH7[&YJKK[[;$<,GH<FRMJXZ6\DJO
M/$ZU5R[DLQZRZ/I[7KRS8%R3A@[&'5#*RQK7C:U_6G[E#]OJ$?NDECZUL4Z%
MS?ZS@-[I6/&S>JSF@0V79+SH)<[,5LZJ4_NRMBFS2TFSRBZES"[J1NZ;8M[D
M3\'N[4[P<?>1\7[JV]Y4]4[LC_JT>!ZUY+[EN9K=IDP&7WMQ+'WK3K'Q!Z_N
MWX;M!+GP<3[7`FWA:('A5)Z))QX5Z\W>9/]>%>LM\DP1\Q.H[>X=X!W>%BRO
MT:E>X3V?RPV-ZA3]\C,Z])(R[_+,\R^>] ;=\B_J]#?>WPH.]$=/]58OXC@>
ME!'^]6 ?]F(_]D\D[#8::RI/%C^?SF<OSFD_%FL/T&WO]DH_X.4]]YGX]F(1
M]^"M2-&%]^)DXUNOXM#74 O15FF47Q &^$T5IDI>ZMCN=E]J\U%1O_A6Y.Y>
M\(^OER(MW5.\A7^?^/0D4!O&^,74GU^.D1!<<7;ZUS-?^;MJYE.,^K(/!$8M
MK$3-\(MO`5#54B&E$*^G6;Q?^J9_2T0:[ZOM\6Q=QCQ;V 3[UHB=[CJO6ADE
M6N4U^F+E4T155N/_6_S&?Y=XJI/#VJMC/L"K/-V:#JC@#P0TF=53#O3?I7B&
MU5RCSUC]U?W>[TH:^K.#[7;>2OD`$4?@0((%#1Y$F%!A0A$"@ Q$4H""028+
M+5[$F!%AQ(D<XQPAX.&(`1P?21(LD45EEA)+`#"Q$%,FAS-P8,3D$>=+3!LZ
M,U2)DX0GP38O:-J4F53I4J9-G3Z%&E7J5*I5K2:MJ%'K5JYQ/!8<B0,)@I(@
M/1#,VE7MVHQA!7XMF);MW+5P20``,("D6[<#4ZYL^7+IT9L6>NZTD%/+SZ"&
MXZ1Q0;,HX:N5+5_&G%DS4[ET/6N$2S"BR ,/UX28.+#S9]9=W89&VUJV_T78
M`DDD(#.V;&F4*UFZA*F4L@7)+W[:O/"C<<Z='^),KEEX\W3JU:U;73U;NU>)
M!$FD)A% ;/>^`K-O1R_PR *!(G#75IT^/?S3J45,'*&@X%^5@8,G'8ZX,P1"
MR@+G!%("J#C<. .Z`J^#,$()ISM//L_NP@LO"D#"2SSU",#KK-@L)#$BO'"+
M`\,,4XN/Q-E4U##%&-\J``"']O/-OPEWY+%''Z&JT$4A#PIR2"/-.S))A/C[
M3; ?GX0RRNJ*5!*C#*_$,LLK6ZR2-2V_'+%+M;XD$TN_<@1.2C779%,J*L5,
M[TTXMY-SSMF8U+%-/?=DLTX[6_/SS\\"%90N/$73Y#-117LDM%"V&G54+4@C
MY>I0)Q?%-%/J)J54*TX[S>A34"^R]#]-3T45NU'C7!4]45M-J-149Z452%BU
*>_56BG25+2 `.P``
`
end
|