--> --> -->
MAS 90/200 Tips Events

 

Back Up Next
Crystal Speed Tip

CRYSTAL SPEED TIP

There are a couple of ways to help improve the speed of your Crystal Reports and forms.  Once your report is open, go to File, Report Options and look at the middle of the screen.  You will notice two fields that may or may not be checked (as seen in the graphic below).  These fields are:
bulletUse Indexes Or Server for Speed (default is checked)
bulletConvert NULL Field to Default

crystal.gif (16737 bytes)

You should check the Use Indexes or Server for Speed if the tables in your report are linked by the Key Fields only.   If you are unsure if you are linking by the key fields, please refer to your TRSG.   Here, you will find an outline of every file in MAS90 with the key fields noted.   If you are linking to non-key fields, you should take the check mark out of this box as it will decrease your performance. 

If your report contains any outer-join types (i.e. left outer or right outer), you should check the Convert NULL Fields to Default box to increase your performance.  We normally do not recommend using right outer joins as this type of join is not supported by Best Software Support.

If you are unsure how to check your report linkages, please refer to your Crystal Reports Manual.

*NOTE: This tip is not meant to provide detailed instructions on how to use Crystal Reports or how to edit existing reports.  Please refer to your Crystal Reports Reference Manual if you are unclear about report linkages and how to check them.  If you have any questions or concerns about the above process, please contact your MAS90 reseller or Best/State of the Art Technical Support. Accuvar assumes no responsibility for any data loss or downtime caused by performing the suggestions outlined in this tip.

Back Next

 

© Accuvar, Inc. All Rights Reserved
All other trademarks and copyrights are the property of their respective holders.

Accuvar, Inc.
Corporate Office:
1849 Willow Pass Road, Suite 309
Concord, CA  94520
Phone us toll free at (888)Accuvar (222-8827)
Fax:(877)222-5458

Questions or comments about this website?  E-mail webmaster@accuvar.com.

MAS 90 and MAS 200 Authorized Reseller Microsoft Axapta Authorized Reseller DataHabitat for MAS 90 and MAS 200 Authorized Reseller Microsoft Certified Solutions Provider