Relax and Let Favorites Do the Work
Save time by using Favorites in GP Reports Viewer |
 Just like in SmartList, you can have an unlimited number of Favorites in GP Reports Viewer with saved parameter values for your reports.
Here are the steps to create a Favorite:
- Go to Reports > GP Reports Viewer
- Select a report and enter parameter values
- Click the Favorites button
- Enter a name for the Favorite
- Choose if you want this Favorite to be visible to you or to all users in the company
- Click Add
Once a Favorite has been set up you can print your report without needing to choose parameters again. More detailed steps to manage Favorites are in Chapter 4 of the GP Reports Viewer User Guide. You can see an example of this time-saving technique in the GP Reports Viewer
demo video on our website. |
How to Use CASE in Crystal Reports
Syntax for Case statements |
 CASE statements in formulas are useful when you have a wide variety of values and a few results. For example, let's say your report lists all open customer transactions and you want to show the correct sign for the Current Transaction Amount depending on the type of transaction. Here is what that formula would look like:
select {RM20101.RMDTYPAL}
case 1, 2, 3, 4, 5, 6:
{RM20101.CURTRXAM}
case 7, 8, 9:
{RM20101.CURTRXAM} * -1;
To add the equivalent of an 'else' in Crystal, you can add a 'Default' line. Using the example above, to add an 'else' to the formula above where any other transaction type would show a positive number:
select {RM20101.RMDTYPAL}
case 1, 2, 3, 4, 5, 6:
{RM20101.CURTRXAM}
case 7, 8, 9:
{RM20101.CURTRXAM} * -1
Default:
{RM20101.CURTRXAM}; |
| February Trivia Contest - Win a $25 Gift Card
By: Joseph Puntasecca |
 The first modern Olympic Games were held in the summer of 1896. In 1908 skating was added. It was eventually decided to hold separate Winter Games.
Where was the first Winter Olympic Games held, in what year and who won the first Gold Medal?
The first correct answer submitted by e-mail to our Sales Department or by fax to (908) 654-0106 will receive a $25.00 Amazon.com gift card and recognition in next month's newsletter!
January Trivia Contest Results
Question: What was the most points ever scored in the Super Bowl (both
teams combined)?
Answer: The most points in a single Super Bowl was 75 points in Super Bowl XXIX - San Francisco 49ers (49) vs. San Diego Chargers (26)
Won by Tammy McMichael, Director of Business Development, Gilchrist Scott Ltd. |
