Results 1 to 2 of 2

Thread: Crystal Report max function

  1. Mar 5th, 2008, 03:30 PM #1
    EyeTalion
    EyeTalion is offline

    Thread Starter
    Frenzied Member EyeTalion's Avatar
    Join Date
    Jul 2000
    Location
    New York
    Posts
    1,075

    Crystal Report max function

    I have 12 columns in a group header that gives a total amount of sales for each month. I'm using the INSERT SUMMARY to sum up each month. In another column I want to grab the total of the month with the most sales.
    It's tough being an unhandled exception...

    ___________
    VB.NET 2008
    VB.NET 2010
    ORACLE 11g
    CRYSTAL 11
    Reply With Quote Reply With Quote
  2. Mar 5th, 2008, 04:32 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Crystal Report max function

    There are 2 versions of the Maximum function.
    One will find the max of a group eg. Maximum({orders.AMOUNT}, {orders.ORDER DATE}, "monthly").

    The other will find the max from an array of values.
    Maximum (MakeArray({@Formula1},{@Formula2},{@Formula3}))

    Without knowing your report I don't know which method would apply to you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width