pandit.sumit

I have the following query for a dataset: select item, sum(salesAmount) as TotalSales from sales group by item order by TotalSales desc; and I have set REPORT_COUNT<=5 for limiting the data to 5 records only. Now I want to display top 5 items through a list component and their Sales Amount in percentage to that of the TotalSales amount of the top 5 items. I have created a variable in the dataset as sales_sum class: BigDecimal Calculation : Sum Reset Type : Report Increment Type : None Variable Expression : $F{TotalSales} Now I am adding a text field and using expression $F{TotalSales}/$V(sales_sum) and set the evaluation time to Auto. But it is returning null and a NullPointerException What should I do? Thank you

I want to extract data from a json file. The file is stored in a directory whose path is fixed. New files are periodically added to this directory. The file name follows a specific naming convention that includes the time stamp and a header in it. I want to extract the timestamp and the header from the file name in order to isolate the latest file that is to be processed and save the header in a database table. This requires to iterate all files in the directory and extract the flie name. Then the file data can be extracted. How I can do this using jasper ETL?