IC DATA in a Crystal Report MAX Function

Sort:
You are not authorized to post a reply.
Author
Messages
Jeff N
Advanced Member
Posts: 32
Advanced Member

    I have a Crystal Report that lists monthly usage for the year for inventory tracked locations. The problem I am having is I would like to pull the max usage month into an additional column. My row has the following data in columns; Item#, Description, MO1 Usage, MO2 Usage etc. Does anyone have any insight into any Crystal or SQL Function that will pull the max month data?

    Thanks,

    Jeff Nelson

    Red
    Veteran Member
    Posts: 87
    Veteran Member
      Jeff,
      So, I work in CR a fair amount. I just want to be clear on your request. Are you looking for the max amount (usage)? Or are you looking for a flag to indicate which period/month had the most usage (so that your values would be March, April or July)? Also, if you can let me know what your current grouping strategy is (if you are using groups).

      I understand your general question, because CR is not great at comparing items outside of a group. One think you may want to consider is the use of arrays. There are three steps in using arrays ( roughly speaking they are defining, populating, and then "printing") and there are some limitations in how large an array can be. Also, as I remember, the same performance impacts of putting summary fields in the header of a grouping, versus the footer of the same grouping, apply to how you might use an array as well.

      Something to consider,
      Red
      Learn from the Past. Prepare for the Future. Act in the Present.
      You are not authorized to post a reply.