How to show data from Joget spreadsheet to Jasper report

 
1
0
-1

I have create data entry using spreadsheet. May I know how to extract this data to get it generate in Jasper report?

Below is sample from the entry screen and Jasper report that I create.

 

 

 

    CommentAdd your comment...

    3 answers

    1.  
      2
      1
      0

      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.

        CommentAdd your comment...
      1.  
        2
        1
        0

        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.

          CommentAdd your comment...
        1.  
          1
          0
          -1

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

            CommentAdd your comment...