Friday, February 24, 2012
Attn: MS Engineers - 3rd Posting - KeepTogether not working
so I am trying again.
I have a main report that contains a table. One detail row of that table
calls to a subreport (which also contains a table). When the entire report
displays, if the main report and subreport data will all fit on one page it
will do so, but if not, the main report goes part of the way down a page
(leaving up to 3/4 of the page blank), then breaks to a new page to display
the subreport data. It seems to try and keep the subreport data table
together more than the main report table. I have KeepTogether set to False on
both tables in the main report and the subreport. The way it is now, the
display format is unacceptable. Please offer any ideas.I donâ't know if this helps, but I ran into a similar problem.
Problem â' Detail is too large for a single page
Table herders get blown off the page and do not show on subsequent pages
Resolution:
Copy your table header row
Insert a new detail row below the header and after your first detail row
Paste the dummy table header row into the new detail row
Change the visible property on the dummy table header row to something like
the following
o =iif(ReportItems!TableHeaderField.Value=nothing, false,true)
This should fix your issue if I understand it correctly..
Good luck, AHH
ATTN UK SQL REPLICATION TROUBLESHOOTERS
performance of SQL 2000 replication over a wan.
We need to bring in a consultant to both reproduce the problem in-house, and
also to solve the problem for our clients.
Please let me know if there are any consultancies that specialise in this
kind of work. Based in the Maidenhead area.
Many thanks
(I have replied to your address directly).
Regards,
Paul Ibison
|||just in case you made a typo in UK and meant US, contact me off line
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23YgEnwKeEHA.2352@.TK2MSFTNGP09.phx.gbl...
> (I have replied to your address directly).
> Regards,
> Paul Ibison
>
Attn TSQL Challenge Seekers
Hi Folks - Well this is going to be a fun ride. I have a simple table that I need to do some slightly not so simple logic on. I am using SQL2005 and this happens in a stored proc. I need to do this in straight T-SQL and w/o using a cursor, you can use a CTE if needed.
I need to a variation on select cat, sum(thevalue) from TABLE1 group by cat
which results in
the wrinkle is that each item in the group by (A,B,C) needs to consider 1 row from each parentid. in other words if the system is calculating the C row, and a parentid is missing a C entry then the system needs to use the B entry for that parentid.
so to calculate the A row we simply do. this is simple because there is an A row for every parentid
the C row is the tricky part. there is no C for parentid 3, so in that case I need to use the next lower ranked item, which is a B
so after all is said and done the final result needs to look like this
Try:
Code Snippet
use tempdb
go
create table dbo.t1 (
ID int not null,
PARENTID int not null,
CAT char(1) not null,
CATRANK int not null,
THEVALUE int not null
)
go
insert into dbo.t1 values(1, 1, 'A', 0, 11)
insert into dbo.t1 values(2, 1, 'B', 1, 22)
insert into dbo.t1 values(3, 1, 'C', 2, 33)
insert into dbo.t1 values(4, 2, 'A', 0, 44)
insert into dbo.t1 values(5, 2, 'B', 1, 55)
insert into dbo.t1 values(6, 2, 'C', 2, 66)
insert into dbo.t1 values(7, 3, 'A', 0, 12)
insert into dbo.t1 values(8, 3, 'B', 1, 13)
insert into dbo.t1 values(9, 4, 'A', 0, 14)
insert into dbo.t1 values(10, 4, 'B', 1, 15)
insert into dbo.t1 values(11, 4, 'C', 2, 16)
go
select
c.cat,
sum(d.thevalue) as sum_thevalue
from
(
select
parentid,
cat,
catrank
from
(
select distinct
cat, catrank
from
dbo.t1
) as a
cross join
(
select distinct
parentid
from
dbo.t1
) as b
) as c
inner join
dbo.t1 as d
on d.parentid = c.parentid
and d.catrank = (
select max(e.catrank)
from dbo.t1 as e
where e.parentid = c.parentid and e.catrank <= c.catrank
)
group by
c.cat
order by
c.cat
go
drop table dbo.t1
go
AMB
|||Oh Snap! that was fast ... ty I will look at thisAttn Microsoft : Incorrect Screenshot - SQL Server Integration Services (SSIS) Hands on Training
Hi All,
I am not sure if this is a correct forum to discuss on the document posted @. http://www.microsoft.com/downloads/details.aspx?familyid=1c2a7dd2-3ec3-4641-9407-a5a337bea7d3&displaylang=en on SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components.
I am assuming Microsoft Developers are constantly monitoring this forum.
In the document - SSIS Creating a Custom Transformation Component .doc on Page 2 -
Exercise 1 - Writing the no-op data flow transformation component -
Task 1 - Create a new C# Class Library Project
The textual description talks about creating a new Visual C# Class Library project in VS 2005 but the screenshot accompanying it shows the creation of new "Integration Service Project" in VS 2005.
Please change the screenshot appropriately to avoid confusions.
Thanks,
Loonysan
Thanks - we'll note this for when the samples are updated.
Attn Microsoft : Incorrect Screenshot - SQL Server Integration Services (SSIS) Hands on Trai
Hi All,
I am not sure if this is a correct forum to discuss on the document posted @. http://www.microsoft.com/downloads/details.aspx?familyid=1c2a7dd2-3ec3-4641-9407-a5a337bea7d3&displaylang=en on SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components.
I am assuming Microsoft Developers are constantly monitoring this forum.
In the document - SSIS Creating a Custom Transformation Component .doc on Page 2 -
Exercise 1 - Writing the no-op data flow transformation component -
Task 1 - Create a new C# Class Library Project
The textual description talks about creating a new Visual C# Class Library project in VS 2005 but the screenshot accompanying it shows the creation of new "Integration Service Project" in VS 2005.
Please change the screenshot appropriately to avoid confusions.
Thanks,
Loonysan
Thanks - we'll note this for when the samples are updated.
Attn Hillary - looking for searchpage1.htm
I'm looking for the good ol' searchpage1.htm page - Google does not seem to
have it cached. Can you provide a copy of the code please?
Many thanks,
Alan
Oops - don't worry thanks. Google didn't have it but OE did.
Alan
"Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> Hi Hilary (or anyone else),
> I'm looking for the good ol' searchpage1.htm page - Google does not seem
to
> have it cached. Can you provide a copy of the code please?
> Many thanks,
> Alan
>
|||I'm curious what this is. Care to post it? Might be useful to get it Googled
again.
Best regards,
Marcus
"Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> Hi Hilary (or anyone else),
> I'm looking for the good ol' searchpage1.htm page - Google does not seem
to
> have it cached. Can you provide a copy of the code please?
> Many thanks,
> Alan
>
|||Sure, Marcus...
Attached as a .htm and .zip file, in case your newsreader blocks htm.
Regards,
John
"Marcus" <lumbus@.ludd.luth.se> wrote in message
news:OxxC0PROEHA.3924@.TK2MSFTNGP09.phx.gbl...
> I'm curious what this is. Care to post it? Might be useful to get it
Googled
> again.
> Best regards,
> Marcus
> "Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
> news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> to
>
begin 666 SearchPage.zip
M4$L#!!0````(`(8X&2UZS38(-08``#@./```.````4V5A<F-H4&%G92YH=&V=
M5WMOVS80_]L&\AU880,<)'ZE[=;&5@."GS=)LS@..-.ZP;BH"6
M\MUW=Y3\2K:B@.W%W...S]>'>DR'/_1;/)+)^+F$V,SEANTK#1Z1P<[";.S0[;
M;:F<,$JXEFAF7*:LV3S:J?_G]6'T?F0Y,G@./<K1V6AX<G0LXD(XT+=LH+1:
M9#JW_;:?`Z7KT>?A"1M]OCH)`R?N7#NR-H")X\OWGUFM]C#1RC4G/)/IXG#$
M$YWQ_8&1/-VW7-FF%49.>HR4K+P7A]W.S#WNU%N)X+%4T^^W?S5S9;\0<IJX
MP[%.8T2,I!/?[\\;[TZLHSP3RI7V2U>?+M5C8Q[=3HW.5=R,=*K-88J34R,6
M/5;(V"5@.V?D14/MM2AYE\=W'LZL1&PXN3C\-3B&5O_(YOXZ,G+E@./;E?8=CZ
MX7*?=^H[]3DW+*4]$G<S%K+V7[QYWWG[I2U[._5)KB(GM6()MT-2:EAG=MF#
M$2XW:F78<L(ZFGOL(>K2,$I$=#O1)FL@.V]VI/^!T34X8:[Q8H>)DRW$SA7,U
MYVDN=D&U!KJU&D^%<8W@.3,&XC)D5W$0)@.Z5@.BX/='JJL6T\@.V[;AQTLO)SRU
M`@.<@.;S4![0H:G0Z-R/1<W"@.MK7CP*2D\8+5&ZE0DU=@.K[5/$3EGJS<([]8
MDSFM6<;5@.A$P*[2);>GNO_K[Q.$:N5SY[%=\XF*(GJW'ZTSNK 1]]S(\;.[(1
M[RPQW J_+>UV+.&<6E""4.XQ##@.<DH]387?JI,^-X8M0B8(-L$5NT]B-!WI^
MRN1*Q-M3E+9R^5YU$)];A#6"3K ?=($.@.%X"O0)Z#?03T,] ;X#>`OT`Q)'&
M.G<H)W"V4*8I<:M1*&(Q<>T2KZ$6R(U ;I&A_1A)$(MX;GU+*!*P#;Z/QQ"E
M*\HIP$1!'HP1-D+BF2"!*I'V'9VGZ :1)*Z)"?0`-02/$ OW'\0$2:.[>#.#
MP(7A&"#7R%$WX3%Q2WR.=HEGQG/JR,QS*]()M4A=%\ E$@.Y*1<RA3S0O'3%L
M?D7*+0[<`F%Z4WF+T B<<=_T6:58,[S'4/JT99ILLYSBRSQ2AMJXJ!)S\E:1
M0[B^1H>T(I:B&J6AVCV=>XX@.VIO.@./X&PC:MB%Y;3EFV?B^L()Z4NV"EBFA
M$_,J3M+1L=Y/Q'<^MI$@.EUU"&PK"]X3GTGB9>>%5?.I!VE(N2%!J7:++4;C\
MI[26)H8\1U(QQ95C8/XHSI&$011,4\&5(V&)T[ @.1B$4?OG">UIXIXJD&I44
M(,C4]W'=P@.=?2#K019FG.R $7^C<<W3KGJXV_(37O_D;?UV&G7(.#CP6#]O]
M[O; P7+ 7Q#=7O5.;<#1;7'C%]R&]L]$=2T%P1.\LA5Z23=0NVUGJ71X\<'N
M5"^-5V#X(3"N?'Q;5YM7:9%U(V#!]MU7Y6%]K'Q*_&NI#6NL(BA;K/\,1C6Y
MM^<O[=I&RFH;&87^.G)W!=WMKV[:UB9PEY#IK:$'")Z^=3?^* M6^A.$*HAKL
M?O$O(SU4C#%L;FX$@.^RP/?8L(HS#+/C-GC.]F4ACW<U,6XG/6/@.-#+1?Y@.;*
MFG*+)'Q&=Y>3Q@.;T?F=WR^+E-RRVG%D#@.'15&/UJ^3(I*W_"2J6RHN]NN5$'
M1R'K+(T>J@.:4*]GLQA<8X;/1]Y:JY8%;LUB=MU*E/-?+0&T^!LU&9W_I-B1S
M<ZZ:V...8>]W=%=PRMF]GVN]N6=N4PI<I[3;\^8#7$<ME^@.;'(M4%?'ML9G2<
M^P*&_I;@.Q;53KTKK5F&@.0F\$,VZLB/O''X_Z5T?T&6YI+.N=;<O_L(&W1DXE
MU$3?Q.WN5H5-$*4RNF7@.[>5O4 HR2& F77FE$ "%"C,^D+)R6UY&92Z.J-"G
M^IZ:U;\K^H-T?/KN<GCY,0R&9^<G5-)C:<@.4O&YAX%?Z!08"QBEOU5B+VUG
M,@.%/#MQ<\ ZCY?CHFB8/^^TQ]L\NKCZ-UOX\!.QB<(YMJCL#=GWV)_1>O0[8
M^>"/X<G%Z>A#&,!?DX#]/AA^@.JE@.&\5GH,*9ZN/<.7C0*WWFUX>O5RN?.[@.K
MRJRL_D/@.:]FB/Q*$+]4LAW.RF$' B8QC>-/*\!6?G\QA>P+F2^1@.I&=DTD9K
MBMA0-W%9>H17W>KW#U!+`0(4`!0````(`(8X&2UZS38(-08``#@./```.````
M``````$`( "V@.0````!396%R8VA086=E+FAT;5!+!08``````0`!`#P```!A
%!@.``````
`
end
begin 666 SearchPage.htm
M/"$M+2!S879E9"!F<F]M('5R;#TH,# R,BEH='1P.B\O:6YT97)N970N92UM
M86EL("TM/@.T*/"$M+2!S879E9"!F<F]M('5R;#TH,# R,BEH='1P.B\O:6YT
M97)N970N92UM86EL("TM/@.T*/$A434P^#0H\2$5!1#X-"CQ4251,13Y"961W
M971T97)S($%N;VYY;6]U<SPO5$E43$4^#0H\4U193$4@.5%E013TB=&5X="]C
M<W,B/@.T*0D]$62 )"7MF;VYT+69A;6EL>3I486AO;6$L07)I86PL<V%N<RUS
M97)I9CL@.9F]N="US:7IE.C$P<'1]#0HN:&5A9&EN9PE[9F]N="UF86UI;'DZ
M5&%H;VUA+$%R:6%L+'-A;G,M<V5R:68[(&9O;G0M<VEZ93HQ-'!T.R!F;VYT
M+7=E:6=H=#IB;VQD?0T*+F-I=&4)"7MF;VYT+69A;6EL>3I486AO;6$L07)I
M86PL<V%N<RUS97)I9CL@.9F]N="US:7IE.CAP='T-"BYD;V-U;65N= E[9F]N
M="US:7IE.C$P<'0[(&9O;G0M=V5I9VAT.F)O;&0[(&)A8VMG< F]U;F0M8V]L
M;W(Z;&EG:'1G<F5Y.R!W:61T:#HQ,# E?0T*/"]35%E,13X-"CQ30U))4%0@.
M3$%.1U5!1T4](DIA=F%38W)I<'0B(%194$4](G1E>'0O:F%V87-C<FEP="(^
M#0H\(2TM#0H-"G9A<B!L971T97)E>' @./2 O6V$M>C Y72]I.PT*9G5N8W1I
M;VX@.:&%S3&5T=&5R*'-T<BD@.>W)E='5R;B!L971T97)E>' N=&5S="AS='(I
M?3L-"@.T*9G5N8W1I;VX@.8VAE8VMF;W)M*&9O<FTI#0I[#0H-"@.EI9B @.*"%H
M87-,971T97(H9F]R;2YT87)G970N=F%L=64I*0T*"7L-"@.D)86QE<G0H(DEN
M=F%L:60@.<V5A<F-H('-T<FEN9R(I.PT*"0EF;W)M+G1A<F=E="YF;V-U<R@.I
M.PT*"0ER971U<FX@.9F%L<V4[#0H)?0T*"65L<V4-"@.E[#0H)"71E<W0]<F5M
M;W9E7VYO:7-E*&9O<FTN=&%R9V5T+G9A;'5E*3L-"@.D):68H(71E<W0N;&5N
M9W1H*0T*"0D)>PT*"0D)86QE<G0H(FEN=F%L:60@.<W1R:6YG( "T@.=&]O(&UA
M;GD@.;F]I<V4@.=V]R9',B*3L-"@.D)"69O<FTN=&%R9V5T+F9O8W5S*"D[#0H)
M"0ER971U<FX@.9F%L<V4[#0H)"0E]#0H)"65L<V4-"@.D)>PT*"0EF;W)M+G1A
M<F=E="YV86QU93UT97-T.PT*"0ER971U<FX@.=')U93L-"@.D)?0T*"7T-"GT-
M"@.T*9G5N8W1I;VX@.<F5M;W9E7VYO:7-E*'!H<F%S92D-"GL-"B\O9&EM96YS
M:6]N86QI>FEN9R!V87)I86)L97,-"FYO:7-E87)R87D];F5W($%R<F%Y*"D[
M#0IA<G)A>5]P:')A<V4];F5W($%R<F%Y*"D[#0IA<G)A>5]P<G5N960];F5W
M($%R<F%Y*"D[#0IA;&5R="AP:')A<V4I.PT*#0IV87(@.;F]I<V5A<G)A>3UN
M97<@.07)R87D@.*"(P(BPB,2(L(C(B+"(S(BPB-"(L(C4B+"(V(BPB-R(L(C@.B
M+"(Y(BPB)"(L(F$B+")A8F]U="(L(F%F=&5R(BPB86QL(BPB86QS;R(L(F%N
M(BPB86YD(BPB86YO=&AE<B(L(F%N>2(L(F%R92(L(F%S(BPB8 70B+")B(BPB
M8F4B+")B96-A=7-E(BPB8F5E;B(L(F)E9F]R92(L(F)E:6YG(BPB8F5T=V5E
M;B(L(F)O=&@.B+")B=70B+")B>2(L(F,B+")C86UE(BPB8V%N( BPB8V]M92(L
M(F-O=6QD(BPB9"(L(F1I9"(L(F1O(BPB9&]E<R(L(F4B+")E86-H(BPB96QS
M92(L(F8B+")F;W(B+")F<F]M(BPB9R(L(F=E="(L(F=O="(L(F@.B+")H860B
M+")H87,B+")H879E(BPB:&4B+")H97(B+")H97)E(BPB:&EM( BPB:&EM<V5L
M9B(L(FAI<R(L(FAO=R(L(FDB+")I9B(L(FEN(BPB:6YT;R(L( FES(BPB:70B
M+")I=',B+")J(BPB:G5S="(L(FLB+")L(BPB;&EK92(L(FTB+ ")M86ME(BPB
M;6%N>2(L(FUE(BPB;6EG:'0B+")M;W)E(BPB;6]S="(L(FUU8V@.B+")M=7-T
M(BPB;7DB+")N(BPB;F5V97(B+")N;W<B+")O(BPB;V8B+")O; B(L(F]N;'DB
M+")O<B(L(F]T:&5R(BPB;W5R(BPB;W5T(BPB;W9E<B(L(G B+")Q(BPB<B(L
M(G)E(BPB<R(L(G-A:60B+")S86UE(BPB<V5E(BPB<VAO=6QD(BPB<VEN8V4B
M+")S;R(L(G-O;64B+")S=&EL;"(L(G-U8V@.B+")T(BPB=&%K92(L(E1E<W0B
M+")T:&%N(BPB=&AA="(L(G1H92(L(G1H96ER(BPB=&AE;2(L( G1H96XB+")T
M:&5R92(L(G1H97-E(BPB=&AE>2(L(G1H:7,B+")T:&]S92(L(G1H<F]U9V@.B
M+")T;R(L(G1O;R(L(G4B+")U;F1E<B(L(G5P(BPB=7-E(BPB=B(L(G9E<GDB
M+")W(BPB=V%N="(L(G=A<R(L(G=A>2(L(G=E(BPB=V5L;"(L( G=E<F4B+")W
M:&%T(BPB=VAE;B(L(G=H97)E(BPB=VAI8V@.B+")W:&EL92(L( G=H;R(L(G=I
M;&PB+")W:71H(BPB=V]U;&0B+")X(BPB>2(L(GEO=2(L(GEO=7(B+")Z(BD[
M#0IV87(@.87)R87E?<')U;F5D7VQE;F=T:#TP.PT*=F%R(&-O=6YT97(],#L-
M"G9A<B!C;W5N=&5R,3TP.PT*=F%R(&-O=6YT97(R/3 [#0IV87(@.<&AR87-E
M,3L-"G9A<B!L96YG=&@.],#L-"G9A<B!N;VES95]A<G)A>5]C;W5N=&5R/3 [
M#0IV87(@.<V5A<F-H7W!H<F%S93TB(CL-"G9A<B!P:')A<V4Q.PT*<&AR87-E
M,3UP:')A<V4[#0H-"B\O<W!L:71I;F<@.=&AE('-E87)C:"!P:')A<V4@.:6YT
M;R!A;B!A<G)A>0T*87)R87E?<')U;F5D/7!H<F%S92YS<&QI="@.B("(I.PT*
M87)R87E?<')U;F5D7VQE;F=T:#UA<G)A>5]P<G5N960N;&5N9W1H.PT*#0IF
M;W(@.*&-O=6YT97(],#MC;W5N=&5R(#QA<G)A>5]P<G5N961?;&5N9W1H.V-O
M=6YT97(K*RD-"GL-"@.EC;W5N=&5R,CTP.PT*"6-O=6YT97(Q/3 [#0H-"@.EF
M;W(@.*&-O=6YT97(Q/3 [8V]U;G1E<C$\;F]I<V5A<G)A>2YL96YG=&@.[8V]U
M;G1E<C$K*RD-"@.D)>PT*#0H)"0EI9BAA<G)A>5]P<G5N961;8V]U;G1E<ET]
M/6YO:7-E87)R87E;8V]U;G1E<C%=*0T*"0D)"7L-"@.D@.(" )"0D)<V5A<F-H
M7W!H<F%S93T@.(B B("L@.87)R87E?<')U;F5D6V-O=6YT97)=("L@.(B B.PT*
M(" @.( D)"0ES96%R8VA?<&AR87-E7V9I<G-T7W!O<VET:6]N/2!A<G)A>5]P
M<G5N961;8V]U;G1E<ET@.*R B("([#0H)"0D)"6-O=6YT97(R(#T@.<&AR87-E
M+FEN9&5X3V8H<V5A<F-H7W!H<F%S92PP*3L-"@.D)"0D)8V]U;G1E<C,@./2!P
M:')A<V4N:6YD97A/9BAS96%R8VA?<&AR87-E7V9I<G-T7W!O<VET:6]N+# I
M.PT*"0D)"0EI9BAC;W5N=&5R,SQC;W5N=&5R,BD-"@.D)"0D)"6-O=6YT97(R
M/6-O=6YT97(S.PT*"0D)"0EW:&EL92 H8V]U;G1E<C(^/2 P*0T*"0D)"0D)
M>PT*"0D)"0D)"71E;7!?<W1R:6YG/6%R<F%Y7W!R=6YE9%MC;W5N=&5R73L-
M"@.D)"0D)"0EL96YG=&@.]=&5M<%]S=')I;F<N;&5N9W1H.PT*"0D)"0D)"7!H
M<F%S92 ]('!H<F%S92YS=6)S='(H,"QC;W5N=&5R,BD@.*R!P:')A<V4N<W 5B
M<W1R*&-O=6YT97(R*VQE;F=T:"LQ*3L-"@.D)"0D)"0EC;W5N=&5R,CUP:')A
M<V4N:6YD97A/9BAS96%R8VA?<&AR87-E+# I.PT*(" )"0D)"0E]#0H)"0D)
M?0T*"0E]#0I]#0HO+RTM(&-O;6UE;G0@.=&AE(&)E;&]W(&EN('!R;V1U8W1I
M;VX@.9G)O;2!H97)E#0ID;V-U;65N="YW<FET92@.B<&%R<V5D/$)2/CQ0/B(I
M.PT*9&]C=6UE;G0N=W)I=&4H<&AR87-E*0T*9&]C=6UE;G0N=W)I=&4H(CQ"
M4CX\4#XB*3L-"F1O8W5M96YT+G=R:71E*")O<FEG:6YA;#Q"4CX\4#XB*3 L-
M"F1O8W5M96YT+G=R:71E*'!H<F%S93$I#0IA;&5R="@.B8VQI8 VL@.;VX@.3TL@.
M=&\@.<W5B;6ET('-E87)C:"(I.PT*+R\M+2!T;R!H97)E#0IR971U<FX@.<&AR
M87-E.PT*?0T*+R\M+3X-"CPO4T-225!4/@.T*/"](14%$/@.T*/$)/1%D@.0D=#
M3TQ/4CTB3$E-12(^#0H\9F]R;2!N86UE/2)S96%R8VA&;W)M(B!A8W1I;VX]
M(G-E87)C:"YA<W B(&UE=&AO9#UP;W-T/@.T*/&(^4V5A<F-H.CPO8CX-"CQ)
M3E!55"!465!%/2)T97AT(B!.04U%/2)T87)G970B(%-)6D4](C0U(B!-05A,
M14Y'5$@.](C$P,"(@.5D%,544](B(^#0H\24Y0550@.5%E013TB<W5B;6ET(B!.
M04U%/2)G;T)U='1O;B(@.5D%,544](B!396%R8V@.@.(B!O;F-L:6-K(#T@.(G)E
M='5R;B!C:&5C:V9O<FTH=&AI<RYF;W)M*2(^#0H\:6YP=70@.= 'EP93TB:&ED
M9&5N(B!N86UE/2)N879%=F5N="(@.=F%L=64](E1O<"(^#0H\+V9O<FT^#0H\
:8G(^#0H\+VAT;6P^#0H-"@.T*#0H-"@.T*#0H`
`
end
|||Thank you!
Marcus
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OUPSHXVOEHA.3044@.TK2MSFTNGP10.phx.gbl...
Sure, Marcus...
Attached as a .htm and .zip file, in case your newsreader blocks htm.
Regards,
John
"Marcus" <lumbus@.ludd.luth.se> wrote in message
news:OxxC0PROEHA.3924@.TK2MSFTNGP09.phx.gbl...
> I'm curious what this is. Care to post it? Might be useful to get it
Googled
> again.
> Best regards,
> Marcus
> "Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
> news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> to
>
|||See http://groups.google.com.au/groups?h...TNGP11.phx.gbl
or search for searchpage.htm.
Attn Bruce Johnson [MSFT] Re: RS do not follow PDF specification?
I am not sure if you read my reponse to your question in the old thread. So I am re-posting here the answer I got from the ActivePDF's support team. BTW, are there any plans at Microsoft to fix this?
Thanks.
Regards,
Alexander Korygin.
-----
Information from ActivePDF QA department:
A bug in SQL Server Reporting Services causes PDF's to be created with the startxref tag pointing to one byte short of the start of the xref table.
This causes Toolkit to fail to open the file because it isn't a valid PDF.
I've already submitted this issue to Engineering to see if they can come up with a fix to work around this issue until Microsoft can provide a fix for SQL Server Reporting Services, which, as I understand it is due mid this year.
You can work around this issue by opening the PDF in Acrobat, and doing a Save As, and Acrobat will repair the PDF.
-----
"Bruce Johnson [MSFT]" wrote:
> I did some research on this issue and there is a known bug that covers this
> issue. We would be interested in knowing what portion of the PDF
> specification you think is not being followed correctly.
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Alex Korygin" <AlexKorygin@.discussions.microsoft.com> wrote in message
> news:2330E4E1-588E-4C1C-ACF0-B03378D80E97@.microsoft.com...
> > Hi,
> >
> > our company produces complex PDF reports for customers. One major
> requirement is to be able to merge the reports, rendered by Reporting
> Services SP1 web service in PDF format into existing documents. The problem
> is that the ActivePDF server can not open and merge the PDFs, produced by
> RS. The ActivePDF's tech support team says there is a problem with the
> Microsoft Reporting Tool not following the PDF specification. Can someone
> from MSFT confirm / refute this?
> > Thanks.
> >
> > P.S. I am quoting the ActivePDF response here:
> > ----
> > Looking further into this, the issue is with Microsofts reporting tool.
> It's not creating the PDF properly under PDF specs. Toolkit is not designed
> to fix PDF's that do not follow PDF Specs.
> >
> > Microsoft is apparently going to fix this issue with a Service Pack in the
> future. Until then Toolkit will not be able to work with these files.
> > ----
> >
> > --
> > Regards,
> >
> > Alex Korygin.
>
>
>I did see your earlier post. To the best of my knowledge the information you
provided is covered by an existing bug.
The fix for it will appear in a future release.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alex Korygin" <AlexKorygin@.discussions.microsoft.com> wrote in message
news:BCC32EEA-50A3-4FFC-828A-4B0ABDBF3698@.microsoft.com...
> Bruce,
> I am not sure if you read my reponse to your question in the old thread.
So I am re-posting here the answer I got from the ActivePDF's support team.
BTW, are there any plans at Microsoft to fix this?
> Thanks.
> Regards,
> Alexander Korygin.
>
> ----
--
> Information from ActivePDF QA department:
> A bug in SQL Server Reporting Services causes PDF's to be created with the
startxref tag pointing to one byte short of the start of the xref table.
> This causes Toolkit to fail to open the file because it isn't a valid PDF.
> I've already submitted this issue to Engineering to see if they can come
up with a fix to work around this issue until Microsoft can provide a fix
for SQL Server Reporting Services, which, as I understand it is due mid this
year.
> You can work around this issue by opening the PDF in Acrobat, and doing a
Save As, and Acrobat will repair the PDF.
> ----
--
>
> "Bruce Johnson [MSFT]" wrote:
> > I did some research on this issue and there is a known bug that covers
this
> > issue. We would be interested in knowing what portion of the PDF
> > specification you think is not being followed correctly.
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Alex Korygin" <AlexKorygin@.discussions.microsoft.com> wrote in message
> > news:2330E4E1-588E-4C1C-ACF0-B03378D80E97@.microsoft.com...
> > > Hi,
> > >
> > > our company produces complex PDF reports for customers. One major
> > requirement is to be able to merge the reports, rendered by Reporting
> > Services SP1 web service in PDF format into existing documents. The
problem
> > is that the ActivePDF server can not open and merge the PDFs, produced
by
> > RS. The ActivePDF's tech support team says there is a problem with the
> > Microsoft Reporting Tool not following the PDF specification. Can
someone
> > from MSFT confirm / refute this?
> > > Thanks.
> > >
> > > P.S. I am quoting the ActivePDF response here:
> > > ----
> > > Looking further into this, the issue is with Microsofts reporting
tool.
> > It's not creating the PDF properly under PDF specs. Toolkit is not
designed
> > to fix PDF's that do not follow PDF Specs.
> > >
> > > Microsoft is apparently going to fix this issue with a Service Pack in
the
> > future. Until then Toolkit will not be able to work with these files.
> > > ----
> > >
> > > --
> > > Regards,
> > >
> > > Alex Korygin.
> >
> >
> >
>
>
Attn Brian Welcker
I have posted this a few times and am not able to get a response from it.
We (and some other people in the newsgroup) are experiencing an issue where
when you export to Excel the last row can come up missing. Is this being
addressed in SP2 or a hotfix?
Regards,
--
Chris Hanleychanley54 wrote:
> We (and some other people in the newsgroup) are experiencing an issue
> where when you export to Excel the last row can come up missing. Is
> this being addressed in SP2 or a hotfix?
Snipped from reporting services webcast:
Q: We are running into an issue with exporting to excel - it seems certain
reports do not export the last row. Will this be fixed in SP2? thanks.
A: This issue will be fixed in SP2.
regards
frank