Skip to Content
avatar image
Pathuri Radhika

how to add serial number in the SAP BO crystal report version 2016

Oct 17, 2017 at 06:40 AM | 61 Views

Hello All

Can anyone help me with how to insert serial number in my crystal report. add-serial-number.png. before connid i wanted to add one more coumn as serial number. Can anyone help please ?

Thanks

Paturi

add-serial-number.png (73.1 kB)
SAP Crystal Reports
SAP Crystal Reports, version for SAP Business One
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Dell Stinnett-Christy
    Oct 17, 2017 at 03:28 PM

    You need to edit the data source and add the table that has the serial number in it to the data that's being pulled for the report.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • Pathuri Radhika
      Oct 19, 2017 at 05:29 AM

      Hello Christy

      Thank you for your reply. I cant edit the data source and make changes to it. I have to do this from the report level only.

      I tried with @SerialNumber Predefined Function it worked.

      Thank you Christy

  • avatar image
    Former Member
    Oct 19, 2017 at 02:54 PM

    Hi Paturi,

    Please create a formula in place behind the other objects in detail.

    In this formula workshop for the Field 'SrNo' declare variable numbervar 'srno' and increment it (srno:= srno+1;) in a while loop 'WhilePrintingRecords' .

    1. WhilePrintingRecords;
    2. numbervar srno;
    3. srno := srno + 1;
    So for each record in details section it will increase the number by 1. Drag and drop the Formula in details section

    Thanks,

    Anish

    Add comment
    10|10000 characters needed characters exceeded