Group: microsoft.public.it.sql




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$>9E&#MS'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