Create Alphabet Row Numbering in Table Component of Jasper Report

Posted on by By admin, in Jaspersoft | 0

Prerequisites: Jasper Server 6.4.0
Database: Foodmart

In this blog, we learn to display a simple numbering to row in table component using an alphabet instead of numbers.

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Claim Your 30 Days Free Trail

  1. Create a tabular report to display store-name.
  2. Instead of row integer numbering want to display alphabet numbering.
  3. To displays, the alphabetic numbering create one string class variable “CharString” with expression “ABCDEFGHIJKLMNOPQRSTUVWXYZ” in main as well as in table dataset also.
  4. In column text field write “$V{CharString}.charAt( $V{REPORT_COUNT}-1 )” expression and run the report.

    1. Output:

      In case if you have any queries please get us at support@helicaltech.com

      Thanks,
      Koyalwar Neha
      Helical IT Solutions Pvt Ltd

      logo

      Free Open Source BI Platform

      logo
      • AI-Powered Analytics
      • Embedded Analytics
      • Single Sign-On (SSO)
      • Multi-Tenancy
      • Paginated Canned Reporting
      • Interactive Dashboard
      • White Labeling
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments