Printing reports

Joe

Ask Vantage for their helpful document I think it was a short
tutorial for report builder it contained a list of things to do to
make reports run faster. Example when joining tables always make
your first join company:
mfgsys.ladorDtl.Compaty>mfgsys.empbasic.company, then do the joins
for the information you want
mfgsys.ladorDtl.EmployeeNum>mfgsys.empbasic.EmpId. Plus it told you
how to put joins in the right order. When we did the steps that were
recommended all of our reports ran quite a bit faster.
Unfortunately, I couldn't find it on the current Vantage website.
Hope this helps.

Terry

--- In vantage@yahoogroups.com, "bb66866" <bb66866@b...> wrote:
>
> We have a number of reports (Report builder) that take 15 to 20
minutes
> to print. On the average they have links between 5 to 7 tables
each.
> What are the most important factors that affect the speed of
printing
> reports. Other documents outside of Vantage print within seconds.
>
> Thanks in advance
> Joe
>
We have a number of reports (Report builder) that take 15 to 20 minutes
to print. On the average they have links between 5 to 7 tables each.
What are the most important factors that affect the speed of printing
reports. Other documents outside of Vantage print within seconds.

Thanks in advance
Joe
Using the indexes in filters and joins.

Example: LaborDtl.PayRollDate is indexed other laborDtl date fields are not.

If you don't use the indexed field and your new to vantage your report will
run ok with a few thousand records but as your database grows and you have
500,000 records the report will get very slow. If you used the indexed field
of PayrollDate your report will always be fast.

Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bb66866
Sent: Wednesday, January 25, 2006 8:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Printing reports

We have a number of reports (Report builder) that take 15 to 20 minutes to
print. On the average they have links between 5 to 7 tables each.
What are the most important factors that affect the speed of printing
reports. Other documents outside of Vantage print within seconds.

Thanks in advance
Joe






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
Yahoo! Groups Links
I did a presentation at the User-4-User conference last summer on exactly this topic.

In a nut shell the RB rules I live by are....
1. EVERY tables links FIRST with Company
2. EVERY report filters first on Company
3. EVERY table linkage utilizes a pre-set index (as defined in the data dictionary)
AND...uses every available field
4. Filter on components of the Primary Index of the Master table FIRST...then other fields
5. Avoid using In-Range or In-List funcitons in filters on larger tables
6. Link from the smallest table to the largest table first and if possible (depending on report requirements) link in a linear string ot tables rather than branched

I've seen these rules take reports from several hours down to 30-40 seconds

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of bb66866
Sent: Wednesday, January 25, 2006 8:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Printing reports


We have a number of reports (Report builder) that take 15 to 20 minutes
to print. On the average they have links between 5 to 7 tables each.
What are the most important factors that affect the speed of printing
reports. Other documents outside of Vantage print within seconds.

Thanks in advance
Joe






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




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]