Provided again Mark the sample skus, store, quantity on hand and date for the lush sales report checking on pentaho. Then as per Mark the details were already in pentaho but when I tried generating again the same issue is persisting, no data. After that Mark changed all the null values into 0 then I tried generating the report again and advised the user. This is now okay.