Already tried that too, thanks. But on a hunch and since it is only two op codes I took out the total and group on oper and made it a summary instead and changed filter to only select one code. So now just group by Emp and sort descending on Emp total hrs. Bang! It works. But I still would have liked it to have both Op codes in one report. I may try backing the Oper sort/group back into now working one-level report. Maybe that's how I got the other ones to avoid the sort/group out of synch message.
-Todd C.
-----Original Message-----
From:
pjw@... [mailto:
pjw@...]
Sent: Monday, November 03, 2003 1:55 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB - Sort on Pre-Pass Total from Group
Try removing the prepass on the operation level since your only need to
prepass the employee total because that's the one your doing your descending
sort on.
Patrick Winter
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Monday, November 03, 2003 1:43 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB - Sort on Pre-Pass Total from Group
Yes, both are pre-pass. I have also tried making a calculated field out of
the Emp total and sorting on that without any luck there either. I think
the next thing I will try is going to a Win-98 PC and trying to run it there
just to eliminate something in Win2K. I think this is the 1st totally from
scratch sort on a group total I've written since going to Win2K at my desk.
No idea why it would make a difference though. -Todd C.
-----Original Message-----
From:
pjw@... [mailto:
pjw@...]
Sent: Monday, November 03, 2003 1:31 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB - Sort on Pre-Pass Total from Group
Are you prepassing aggregates on both the Operation and employee group
levels?
Patrick Winter
-----Original Message-----
From: Todd Caughey [mailto:
caugheyt@...]
Sent: Monday, November 03, 2003 1:22 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] RB - Sort on Pre-Pass Total from Group
[5.20.313 - Prog 9.1D patch level ?]
OK, just when I think I've got RB dialed in it tosses me a stumper.
Very simple little report to total labor hours by employee within two
operation codes. Std. Packing & Special Packing. Total hrs printed at
Employee footer and at Operation footer. No problems there. But when I try
to add a top level sort on the Employee total to sort employees descending
by hours (emp with most to emp with least) it produces a "Sort and Groups
out of synch" error. But I have dozens of other reports doing exactly the
same thing (so I think anyway). I've checked many of them and they really
look the same
Sort Group
------- ---------
EmpHrs (D) Oper
Oper (A) EmpNum
EmpNum (A)
where EmpHrs is a pre-pass aggregate total on LaborDetail:LaborHrs reset at
EmpNum.
Any clues as to why some reports allow presenting the employee records in
sorted order and this report? Also, right after getting the error when
trying to run the report the RB window blanks out and Win2K pops up a "not
responding" message and I have to end task RB. Hmmmm...perhaps related to
the other question about changing libraries and needs a patch?
Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=17050071
83:HM/A=1524963/R=0/SIG=12o885gmo/*
http://hits.411web.com/cgi-bin/autoredir?
camp=556&lineid=3614674&prop=egroupweb&pos=HM>
<
http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmai
l/S=:HM/A=1524963/rand=253845807>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>
<
http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=852870348>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]