Skip to Content
0

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

Oct 17, 2017 at 06:40 AM

41

avatar image
Pathuri Radhika

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
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sort by:
avatar image
Dell Stinnett-Christy Answered Oct 17, 2017 at 03:28 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
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

0
Comment
avatar image
Former Member Answered Oct 19, 2017 at 02:54 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users