Mark
Thu Jun 30 08:37:17 CDT 2005
This is a multi-part message in MIME format.
------=_NextPart_000_0041_01C57D4E.F0A0AC70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Yes, the timestamps are part of the issue. There are certain memo=20
fields in the first record (or the ObjType =3D3D 1 record) such as Tag1=20
and Tag2 in the FRX table that can just be ignored. I believe these two =
fields' values can change, for example, every time a different printer=20
is used.=20
Also, in the EXPR memo field in that first record, every line can be=20
ignored except for the line that specifies the Orientation.
Incidentally, there is an informative MSDN page on report tables=20
at =
http://msdn.microsoft.com/library/default.asp?url=3D3D/library/en-us/dnfo=
xgen9/html/VFP9Reports1.asp. =20
(Look toward the bottom of the long page.)
We have similar reports running on many different systems, and=20
unfortunately we didn't start labeling them with version numbers until=20
recently. So manually comparing all of them is tedious and=20
time-consuming.
Thanks,
Mark
"Andrew Howell" <ajh@work> wrote in message =
news:eFgydUVfFHA.2496@TK2MSFTNGP15.phx.gbl...
The full message was supposed to be this but OE sent it before I =
wanted it=20
to..
> "Mark" <marktillman@dst.inc> wrote in message=20
> news:eT3KViOfFHA.3940@TK2MSFTNGP14.phx.gbl...
Anyone have a program that will compare reports to see if they're the =
same?
I know you can open the report as a table, but Memo fields complicate =
the
comparison somewhat.
*----------
Not sure what's wrong but newsreader doesn't want to indent your =
message
above.
Open a shell window and try
fc /b report1.frx report2.frx
fc /b report1.frt report2.frt
If they're both the same then they're both the same ;)
Alternatively, if you've many to do it may be neater to write a =
function to=20
do it..
** Actually, I just did that and tried it. I can now tell you that it =
is not=20
so very clever because the frx files contain timestamps, so a report =
may=20
produce identical output but not have an identical frx.
There are also other reasons, eg the "specific printer" data, maybe =
your=20
report has the same objects but in a different order, maybe a line is =
one=20
pixel out etc.etc.
No, with hindsight I think the best thing you can do is run each =
report,=20
examine the output and make up your own mind. Sorry.
--=20
Regards
Andrew Howell
------=_NextPart_000_0041_01C57D4E.F0A0AC70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.3790.327" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>Yes, the=20
timestamps are part of the issue. There are certain memo =
<BR>fields in the=20
first record (or the ObjType =3D3D 1 record) such as Tag1 <BR>and Tag2 =
in the FRX=20
table that can just be ignored. I believe these two <BR>fields' =
values can=20
change, for example, every time a different printer <BR>is used. =
<BR><BR>Also,=20
in the EXPR memo field in that first record, every line can be =
<BR>ignored=20
except for the line that specifies the Orientation.<BR><BR>Incidentally, =
there=20
is an informative MSDN page on report tables </FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>at </FONT><A=20
href=3D"
http://msdn.microsoft.com/library/default.asp?url=3D3D/library/en=
-us/dnfoxg"><FONT=20
face=3D"Times New Roman" size=3D3><A=20
href=3D"
http://msdn.microsoft.com/library/default.asp?url=3D3D/library/en=
-us/dnfoxgen9/html/VFP9Reports1.asp">
http://msdn.microsoft.com/library/de=
fault.asp?url=3D3D/library/en-us/dnfoxg</FONT></A><FONT=20
face=3D"Times New Roman" size=3D3>en9/html/VFP9Reports1.asp</A>. =20
</FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>(Look toward=20
the bottom of the long page.)<BR><BR>We have similar reports running on =
many=20
different systems, and <BR>unfortunately we didn't start labeling them =
with=20
version numbers until <BR>recently. So manually comparing all of =
them is=20
tedious and =
<BR>time-consuming.<BR><BR>Thanks,<BR>Mark</FONT><BR></DIV></FONT>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Andrew Howell" <<A href=3D"mailto:ajh@work">ajh@work</A>> =
wrote in=20
message <A=20
=
href=3D"news:eFgydUVfFHA.2496@TK2MSFTNGP15.phx.gbl">news:eFgydUVfFHA.2496=
@TK2MSFTNGP15.phx.gbl</A>...</DIV>The=20
full message was supposed to be this but OE sent it before I wanted it =
<BR>to..<BR><BR>> "Mark" <<A=20
href=3D"mailto:marktillman@dst.inc">marktillman@dst.inc</A>> wrote =
in message=20
<BR>> <A=20
=
href=3D"news:eT3KViOfFHA.3940@TK2MSFTNGP14.phx.gbl">news:eT3KViOfFHA.3940=
@TK2MSFTNGP14.phx.gbl</A>...<BR>Anyone=20
have a program that will compare reports to see if they're the =
same?<BR>I know=20
you can open the report as a table, but Memo fields complicate=20
the<BR>comparison somewhat.<BR><BR>*----------<BR>Not sure what's =
wrong but=20
newsreader doesn't want to indent your message<BR>above.<BR><BR>Open a =
shell=20
window and try<BR><BR>fc /b report1.frx report2.frx<BR>fc /b =
report1.frt=20
report2.frt<BR><BR>If they're both the same then they're both the same =
;)<BR><BR>Alternatively, if you've many to do it may be neater to =
write a=20
function to <BR>do it..<BR><BR>** Actually, I just did that and tried =
it. I=20
can now tell you that it is not <BR>so very clever because the frx =
files=20
contain timestamps, so a report may <BR>produce identical output but =
not have=20
an identical frx.<BR>There are also other reasons, eg the "specific =
printer"=20
data, maybe your <BR>report has the same objects but in a different =
order,=20
maybe a line is one <BR>pixel out etc.etc.<BR><BR><BR>No, with =
hindsight I=20
think the best thing you can do is run each report, <BR>examine the =
output and=20
make up your own mind. Sorry.<BR><BR>-- <BR>Regards<BR>Andrew=20
Howell<BR><BR><BR></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0041_01C57D4E.F0A0AC70--