Recent content by MASTERMIKE

http://support.businessobjects.com/library/kbase/articles/c2000972.asp

Create a formula: if isnull ({S_ORDER_ITEM.X_SHOT_FEE}) then 0 else {S_ORDER_ITEM.X_SHOT_FEE} This will return a 0 if the field is null and return the field value if the field has a value.

How do I display discrete date values selected from a date parameter? I can easily display the first (minimum) and last (maximum) dates in a range, but what if I want only certain discrete dates that a user has selected, such as 8/14/03, 8/19/03, 8/27/03, etc.?

Write a formula using "maximum ({table.field of the field you are looking for}, {table.field of the group})". Place this formula in the report and it should return the maximum value within each group.

Have you tried to group in specified order? If you Use specified order grouping you can create your own group names using various table.field values, formulas, etc.

Go to File, Printer Setup, Orientation

The formula is a very basic switch formula, switching a list of 708 zip codes to town names. It would take up to 14 pages to print, so I don't think you want it pasted here. I wasn't about to actually write all 708 zips and town names, so I created a very simple Crystal Report to do it for...

What is the maximum number of arguments I can use with a switch function in Crystal 8.0? I tried to create a very long formula using switch (using Crystal to write the code for me...I'm not completely insane...just a little) and got the error message "Too many arguments have been given to...

Just don't try it with a running total! Leave the RTs in the footer.

Thank you! It works!

I am trying to calculate averages on fields where some records list as duplicates and others list as distinct. Using an average function yields an incorrect result since the multiple records are counted more than once. For example: Category A 7.40 Category B 10.00 10.00...

I am doing a report listing transaction dates for each customer. I want to show only the first transaction date for each customer, and if possible (but not required), group by first transaction date, so that I have a list of customers with a first trasaction date of 01/01/2002, a list with a...