Hello, there are two options. One, is that you must follow the guidelines to work with JSON data sources, since the data you enter in the spreadsheet is stored, by default in that format: https://community.jaspersoft.com/wiki/how-create-report-uses-remote-json-data-source

The other option is to modify the way in which you save the information from the spreadsheet, so that the information is formally stored in a table. For that, create a base form with the data structure (so the field and component types do not correspond to those in the spreadsheet, but are simply text fields, but with ID's exactly the same as the names of the fields the spreadsheet) by adding a field that serves as a relational field with respect to your main form, linked to, for example, the table tbl1.

With this form ready, change the way in which the information in the spreadsheet is stored in the section "Validation & data binder" - "Data binder" - "Store binder" by "Multirow form binder" and in section "Configure Multirow Form Binder" select the form you created previously and select the relational field in the "Foreign Key" list.

With that, you can have the information, row by row in table tbl1, indexed by a key field so you can easily build the report through a single query for the report.

Please contact us for complete information and solution.
https://www.mcl.in/jasperssrscrystal-reports/

As Camilo A. García mentioned, there will be a button in the form to view the Jasper. On the click of View Jasper, get all the rows of the spreadsheet by method convertJsonToRowSet(formData), once you have the FormRowSet, populate all the rows in a temp table with a record_id. and then call the jasper report and pass that id as a parameter to get all the current rows from the spreadsheet.