Jump to content
We've recently updated our Privacy Statement, available here ×

andrqxa

Members
  • Posts

    13
  • Joined

  • Last visited

Community Answers

  1. andrqxa's post in How add additional data to fields (SOLVED) was marked as the answer   
    I have found the solution. May be it will help somebody.
    In main report created parameter NAME_OF_MY_PARAMETER with type of net.sf.jasperreports.engine.JRDataSource
    Created scriptlet 
    In scriptlet beforeReportInit() method received value of  REPOT_CONNECTION parameter
    Connection conn = (Connection) this.parametersMap.get("REPORT_CONNECTION").getValue();[/code]    Run query which I needed and received result (ArrayList in my cause)
       Processed  result and got ArrayList which I needed (i.e. added additional rows)
    override setData method in scriptlet
    public void setData(Map parameters, Map fields, Map variables, JRFillGroup[] groups) { super.setData(parameters, fields, variables, groups); JRFillParameter parameter = (JRFillParameter) parameters.get("NAME_OF_MY_PARAMETER"); parameter.setValue(JRMeasureDataSourceFactory.getDataSource(measures));}[/code] call setData in beforeReportInit method of scriptlet
    In main report created subreport and as a DataSource of it  set parameter NAME_OF_MY_PARAMETER
    in subreport left its query as empty (or as select 1)
    added field to subreport which had type and name which I need
    created chart which I needed
×
×
  • Create New...