Skip to Content
avatar image
Former Member

Printing the same value in any part of the report


I made a stored procedure and on the basis of that I prepared a crystal report. I am facing a problem. Let me explain it with the data below

InvoiceNum OrderNum No. of Packets PartNum Qty

188888 5203 10 ABC123 15

188888 5203 10 ABC123 25

188888 5203 10 ABC120 45

188890 5203 0 PQR124 35

188890 5203 0 PQR126 75

The above data could also be in a reverse order which means the first two number of packets may be null and the remaining may have the value as 10

I want to have a formula which I put any where in the report I should get the number of packs as 10 (as per the above data) I tried different codes but nothing worked.


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Nov 07, 2016 at 03:17 PM

    Hi Sreejith,

    Create a formula with this code:

    Maximum({No. of Packets})

    Place this on any section and it should display highest packet number.


    Add comment
    10|10000 characters needed characters exceeded