|
Tips & Tricks from
CrystalReportsLibrary.com... 1.
MAS Crystal Report Version 8Conversion Wizard problem The MAS Crystal
Report Conversion Wizard will fail on any form or report that contains a
field that has been removed from the data dictionary. Within the Converting
Reports window, an error message will appear with a status of
"Failed." Be sure to note the path of the report, the report name,
the table name, and the field name in the error message. For more
information, go to http://support.us.sage.com/mas/
and search for CR3008-ABC in Program Fixes. 2. Tip for
utilizing Version 8 With the added
Web integration in Crystal Version 8, you can use this functionality to help
keep your name in front of your clients. When you write a Crystal Report for
a client, why not include a link to your web site or a link to your email
address? Go to the Hyperlink tab in the format editor to create links. You
can also create a link to another Crystal Report file if that makes sense. 3. Speed up your
report If you are linking two tables from a keyed field to a non-keyed field, go to Report Options and deselect the check box marked "Use Indexes or Server for Speed". This should speed up processing. 4. Displaying a
text object vertically with Version 8.5 and before. You need to
format the text object with the 'Can Grow' check box selected. Also, edit the
text to include a carriage return (press the ENTER key) after each character.
Here are the steps to follow: 1. Select the
text object and click Format / Format Text /Common tab. 5. Using Input
Parameters with Formulas Input
parameters can be very helpful when used in formulas. The
most common reason for using an input parameter is to use it in conjunction
with the select expert to limit the data included in a report. Input
parameters used with formulas can be used more selectively. You
might want to use the report date (defined as ReportDate) as an input
parameter with a formula to pull the correct current period from a history
file that stores data by period. To accomplish this, define a formula called
“period” using the Month function and the input date parameter to return the
month as a number. Then define another formula called “CurrentMonthSales”
with an if, then statement using “period” to pull the correct current period
data from a history file such as IM_13.The two formulas would look like this: Formula
name: Period Month({?ReportDate}) Formula
name: CurrentMonthSales If Period = 1 then
{IM_13CustomerSalesHistory.DollarsSoldPeriod1} else If Period = 2 then
{IM_13CustomerSalesHistory.DollarsSoldPeriod2} else etc,
etc Contact Us |
