Todd,
Is it possible to get a synopsis of these (Report Builder) performance
tips, or are they posted somewhere that I haven't looked?
Dan Maddox
Pactiv Corp
At 11:00 AM 10/10/2003 -0500, you wrote:
Is it possible to get a synopsis of these (Report Builder) performance
tips, or are they posted somewhere that I haven't looked?
Dan Maddox
Pactiv Corp
At 11:00 AM 10/10/2003 -0500, you wrote:
>Just a thought....but on what usually is a HUGE table like LaborDtl maybe
>using seperate date tests (>= and <=) rather than In-Range would yield a
>lot better performance. In-Range forces processing to the client rather
>than at the server and can be 10 times slower. If you have several years
>of labor data it can make a big difference. I generally avoid In-Range
>and In-List per the great RB Performance Tips session at the 1999 user
>conference (pre-Perspectives) give by Mark Pladson. I've had reports go
>from 3+ hrs down to 30 seconds to run.
>
>-Todd C.
>
>-----Original Message-----
>From: Karen Brodniak [mailto:karen.brodniak@...]
>Sent: Friday, October 10, 2003 10:52 AM
>To: vantage@yahoogroups.com
>Subject: RE: [Vantage] Job Report-CORRECTION
>
>
>Spell Check changed the name of the master table--master table should be
>LaborDtl.
>
>Karen Brodniak
>Accounting Manager
>425-742-7011 X44
>Fax 425-353-8945
>karen.brodniak@...
>
>-----Original Message-----
>From: Jim Horton [mailto:jim.horton@...]
>Sent: Friday, October 10, 2003 6:05 AM
>To: vantage@yahoogroups.com
>Subject: [Vantage] Job Report
>
>
>I'm trying to make a report in report builder that will tell me how many
>hours were on a job during the week, and also give me the total hours on the
>same job. Anybody have anything close to this or can point me in the
>correct direction.
>
>
>
>Jim Horton
>Information Systems
>Tel: 269-668-3377
>Fax: 269-668-5132
>www.Mol-Son.com
>
>
>
>Yahoo! Groups Sponsor
>
>ADVERTISEMENT
>
>< http://rd.yahoo.com/M=244522.3707890.4968055.1261774/D=egroupweb/S=17050071
>83:HM/A=1595054/R=0/SIG=124ukap9t/* http://ashnin.com/clk/muryutaitakenattogy
>o?YH=3707890&yhad=1595054> Click Here!
>
>< http://us.adserver.yahoo.com/l?M=244522.3707890.4968055.1261774/D=egroupmai
>l/S=:HM/A=1595054/rand=161098183>
>
>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/.
>< http://groups.yahoo.com/group/vantage/files/.>
>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
>< 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
>< 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
>
><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=436392987>
>
>
>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]
>
>
>
>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/