Becca37

Does anyone know where I can find these files to add to classpath, or with what to replace the references? com.evnt.eve.modules.CurrencyModule [being used for --> com.evnt.eve.modules.CurrencyModule.isMultiCurrency()]com.fbi.sdk.constants.setup.CurrencySymbolConst [being used for --> com.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(]I have a working customized report running on Fishbowl 2020. I've searched and searched on the Fishbowl server to find these modules so I can copy them to my workstation's Jaspersoft Studio's classpath. To no avail. I opened the .jrxml in Jaspersoft Studio 6.13.0 - Visual Designer for JasperReports 6.13.0 with NO changes to the file and get the error shown at the very end. The modules are called in variables and expressions such as shown below. <variable name="isMultiCurrency" class="java.lang.Boolean"> <variableExpression><![CDATA[com.evnt.eve.modules.CurrencyModule.isMultiCurrency()]]></variableExpression> </variable>[/code]Full Error net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:1. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency(); //$JR_EXPR_ID=57$ <--------------------------------->2. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=82$ <--------------------------------->3. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTORDERTOTAL.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=82$<--------------------------------------------->4. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=84$ <--------------------------------->5. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_TotalShipped.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=84$<--------------------------------------------->6. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=86$ <--------------------------------->7. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTSHIPPEDTODAY.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=86$<--------------------------------------------->8. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=88$ <--------------------------------->9. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_LGShipped.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=88$<--------------------------------------------->10. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=90$ <--------------------------------->11. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTREMAINING.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=90$<--------------------------------------------->12. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=127$ <--------------------------------->13. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_LIAMTORDEREDTOTAL.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=127$<--------------------------------------------->14. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=130$ <--------------------------------->15. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTORDERTOTAL.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=130$<--------------------------------------------->16. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=132$ <--------------------------------->17. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_TotalShipped.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=132$<--------------------------------------------->18. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=135$ <--------------------------------->19. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_LIAMTSHIPPEDTODAY.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=135$<--------------------------------------------->20. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=138$ <--------------------------------->21. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTSHIPPEDTODAY.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=138$<--------------------------------------------->22. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=140$ <--------------------------------->23. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_LGShipped.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=140$<--------------------------------------------->24. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=143$ <--------------------------------->25. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_LIAMTREMAINING.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=143$<--------------------------------------------->26. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=146$ <--------------------------------->27. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTREMAINING.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=146$<--------------------------------------------->28. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency(); //$JR_EXPR_ID=57$ <--------------------------------->29. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=82$ <--------------------------------->30. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.math.BigDecimal)field_SOAMTORDERTOTAL.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=82$<--------------------------------------------->31. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=84$ <--------------------------------->32. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.lang.Double)variable_TotalShipped.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=84$<--------------------------------------------->33. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=86$ <--------------------------------->34. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.math.BigDecimal)field_SOAMTSHIPPEDTODAY.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=86$<--------------------------------------------->35. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=88$ <--------------------------------->36. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.lang.Double)variable_LGShipped.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=88$<--------------------------------------------->37. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=90$ <--------------------------------->38. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.math.BigDecimal)field_SOAMTREMAINING.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=90$<--------------------------------------------->39. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=127$ <--------------------------------->40. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.math.BigDecimal)field_LIAMTORDEREDTOTAL.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=127$<--------------------------------------------->41. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=130$ <--------------------------------->42. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.math.BigDecimal)field_SOAMTORDERTOTAL.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=130$<--------------------------------------------->43. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=132$ <--------------------------------->44. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.lang.Double)variable_TotalShipped.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=132$<--------------------------------------------->45. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=135$ <--------------------------------->46. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.math.BigDecimal)field_LIAMTSHIPPEDTODAY.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=135$<--------------------------------------------->47. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=138$ <--------------------------------->48. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.math.BigDecimal)field_SOAMTSHIPPEDTODAY.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=138$<--------------------------------------------->49. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=140$ <--------------------------------->50. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.lang.Double)variable_LGShipped.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=140$<--------------------------------------------->51. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=143$ <--------------------------------->52. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.math.BigDecimal)field_LIAMTREMAINING.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=143$<--------------------------------------------->53. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=146$ <--------------------------------->54. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.math.BigDecimal)field_SOAMTREMAINING.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=146$<--------------------------------------------->55. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency(); //$JR_EXPR_ID=57$ <--------------------------------->56. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=82$ <--------------------------------->57. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTORDERTOTAL.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=82$<--------------------------------------------->58. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=84$ <--------------------------------->59. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_TotalShipped.getEstimatedValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=84$<--------------------------------------------->60. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=86$ <--------------------------------->61. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTSHIPPEDTODAY.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=86$<--------------------------------------------->62. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=88$ <--------------------------------->63. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_LGShipped.getEstimatedValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=88$<--------------------------------------------->64. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=90$ <--------------------------------->65. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTREMAINING.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=90$<--------------------------------------------->66. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=127$ <--------------------------------->67. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_LIAMTORDEREDTOTAL.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=127$<--------------------------------------------->68. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=130$ <--------------------------------->69. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTORDERTOTAL.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=130$<--------------------------------------------->70. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=132$ <--------------------------------->71. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_TotalShipped.getEstimatedValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=132$<--------------------------------------------->72. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=135$ <--------------------------------->73. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_LIAMTSHIPPEDTODAY.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=135$<--------------------------------------------->74. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=138$ <--------------------------------->75. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTSHIPPEDTODAY.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=138$<--------------------------------------------->76. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=140$ <--------------------------------->77. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_LGShipped.getEstimatedValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=140$<--------------------------------------------->78. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=143$ <--------------------------------->79. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_LIAMTREMAINING.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=143$<--------------------------------------------->80. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=146$ <--------------------------------->81. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.math.BigDecimal)field_SOAMTREMAINING.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=146$<--------------------------------------------->81 errors1. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency(); //$JR_EXPR_ID=54$ <--------------------------------->2. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=78$ <--------------------------------->3. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)field_ORDERED.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=78$<--------------------------------------------->4. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=80$ <--------------------------------->5. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_TotalShipped.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=80$<--------------------------------------------->6. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=82$ <--------------------------------->7. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)field_SHIPPED.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=82$<--------------------------------------------->8. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=84$ <--------------------------------->9. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_LGShipped.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=84$<--------------------------------------------->10. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=86$ <--------------------------------->11. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)field_ORDERED.getValue()) - ((java.lang.Double)field_SHIPPED.getValue()), ((java.lang.String)variable_PriceDecimal.getValue())) //$JR_EXPR_ID=86$<--------------------------------------------->12. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency(); //$JR_EXPR_ID=54$ <--------------------------------->13. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=78$ <--------------------------------->14. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.lang.Double)field_ORDERED.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=78$<--------------------------------------------->15. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=80$ <--------------------------------->16. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.lang.Double)variable_TotalShipped.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=80$<--------------------------------------------->17. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=82$ <--------------------------------->18. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.lang.Double)field_SHIPPED.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=82$<--------------------------------------------->19. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=84$ <--------------------------------->20. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.lang.Double)variable_LGShipped.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=84$<--------------------------------------------->21. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=86$ <--------------------------------->22. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getOldValue()), ((java.lang.Double)field_ORDERED.getOldValue()) - ((java.lang.Double)field_SHIPPED.getOldValue()), ((java.lang.String)variable_PriceDecimal.getOldValue())) //$JR_EXPR_ID=86$<--------------------------------------------->23. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency(); //$JR_EXPR_ID=54$ <--------------------------------->24. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=78$ <--------------------------------->25. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)field_ORDERED.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=78$<--------------------------------------------->26. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=80$ <--------------------------------->27. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_TotalShipped.getEstimatedValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=80$<--------------------------------------------->28. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=82$ <--------------------------------->29. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)field_SHIPPED.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=82$<--------------------------------------------->30. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=84$ <--------------------------------->31. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)variable_LGShipped.getEstimatedValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=84$<--------------------------------------------->32. com.evnt.eve.modules.CurrencyModule cannot be resolved to a type value = com.evnt.eve.modules.CurrencyModule.isMultiCurrency() ? //$JR_EXPR_ID=86$ <--------------------------------->33. com.fbi.sdk.constants.setup.CurrencySymbolConst cannot be resolved to a typecom.fbi.sdk.constants.setup.CurrencySymbolConst.getFormattedCurrency(((java.lang.Integer)field_SYMBOL.getValue()), ((java.lang.Double)field_ORDERED.getValue()) - ((java.lang.Double)field_SHIPPED.getValue()), ((java.lang.String)variable_PriceDecimal.getEstimatedValue())) //$JR_EXPR_ID=86$<--------------------------------------------->33 errors. at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:229) at net.sf.jasperreports.eclipse.builder.JasperReportCompiler.compileReport(JasperReportCompiler.java:289) at com.jaspersoft.studio.editor.preview.view.control.ReportController.compileJasperDesign(ReportController.java:482) at com.jaspersoft.studio.editor.preview.view.control.ReportController.access$8(ReportController.java:467) at com.jaspersoft.studio.editor.preview.view.control.ReportController$1.run(ReportController.java:385) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)[/code]

Environment mysql version: 5.7.16 Java version: 7 mysql jdbc connector version: 5.1.44 database schema: Fishbowl Inventory 2019, Version: 19 Manufacturing Modifying report: Sales Order Summary iReports 5.6.0 Notes The report is executed on Fishbowl Client via a .jasper file created using iReports. So I only have access to the .jrxml that I put together in iReports and the error message that Fishbowl spits out after I upload the compiled report and run it. The report compiles in iReports with no issues. The SQL within it runs in MySQL workstation with no issues, but there I do replace all the parameterized values with actual values so that point might be moot. The full .jrxml file is attached. ERROR Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). </pre> Prepared Query This has 18 parameter placeholders. 18. Not 1. Not 2. 18. The 2 parameters it shows at the end of the prepared query are the 1st two it needs. Where are the other 16? Why does it think there should be only 1? What did I do wrong? <pre class="rteindent2">22 Jun 2020 15:07:22 DEBUG [ModifyingSalesOrderSummary subreports #1] jasperreports.engine.query.JRJdbcQueryExecuter (JRJdbcQueryExecuter.java:222) - SQL query string: SELECT locationgroup.name AS GROUPBY , LOCATIONGROUP.NAME AS LG , CUSTOMER.NAME AS CUSTOMER , SO.NUM AS SO , SO.DATEISSUED , SOSTATUS.NAME AS STATUS /* SO status */ , SO.SALESMAN AS "user" , (case when ? = 1 then soitem.productnum else product.num end) AS PRODUCTNUM , UOM.CODE AS SOITEMUOMCODE , SOITEM.DESCRIPTION , SOITEM.ID AS ITEMID , soitem.SOID , soitem.SOLINEITEM , solineitems.SOITEMSTATUS , soitem.UNITPRICE , soitem.ADJUSTAMOUNT , soitem.QTYTOFULFILL , IFNULL(solineitems.LIAMTORDEREDTOTAL, 0) as OPRICE /* LIAMTORDEREDTOTAL --OPRICE equivalent */ , IFNULL(solineitems.LIQTYSHIPPEDPRIOR , 0) as LIQTYSHIPPEDPRIOR , IFNULL(solineitems.LIAMTSHIPPEDPRIOR , 0) as LIAMTSHIPPEDPRIOR , IFNULL(solineitems.LIQTYSHIPPEDTODAY , 0) as LIQTYSHIPPEDTODAY , IFNULL(solineitems.LIAMTSHIPPEDTODAY , 0) as FPRICE /* LIAMTSHIPPEDTODAY --FPRICE replacement; limited to date of report ONLY */ , IFNULL(solineitems.LIQTYSHIPPEDTODATE , 0) as LIQTYSHIPPEDTODATE , IFNULL(solineitems.LIAMTSHIPPEDTODATE , 0) as LIAMTSHIPPEDTODATE , IFNULL(solineitems.LIQTYREMAINING , 0) as LIQTYREMAINING , IFNULL(solineitems.LIAMTREMAINING , 0) as LIAMTREMAINING /* OPRICE - FPRICE replacement */ , IFNULL(sototals.SOAMTORDERTOTAL, 0) as ORDERED /* SOAMTORDERTOTAL --SORDER.ORDERED equivalent */ , IFNULL(sototals.SOAMTSHIPPEDPRIOR, 0) as SOAMTSHIPPEDPRIOR , IFNULL(sototals.SOAMTSHIPPEDTODAY, 0) as SHIPPED /*SOAMTSHIPPEDTODAY --SORDER.SHIPPED replacement; limited to date of report ONLY */ , IFNULL(sototals.SOAMTSHIPPEDTODATE, 0) as SOAMTSHIPPEDTODATE , IFNULL(sototals.SOAMTREMAINING, 0) as SOAMTREMAINING /* SORDER.ORDERED - SORDER.SHIPPED replacement */ , MIN(SOITEM.DATESCHEDULEDFULFILLMENT) AS DATESCHEDULEDFULFILLMENT , SOITEM.DATESCHEDULEDFULFILLMENT AS ITEMFULFILLMENT , MIN(SO.DATEISSUED) AS MINDATEISSUED , POSTSO.POSTDATE , SO.DATEISSUED , CURRENCY.SYMBOL , SO.CUSTOMERPO , STATECONST.CODE AS SHIPTOSTATE , SOITEM.DATELASTFULFILLMENT , SO.DATEFIRSTSHIP , SO.DATECOMPLETED FROM SO LEFT OUTER JOIN SOITEM ON so.ID = soitem.SOID LEFT JOIN STATECONST ON so.SHIPTOSTATEID = stateconst.ID INNER JOIN LOCATIONGROUP ON locationgroup.ID = so.LOCATIONGROUPID INNER JOIN CUSTOMER ON customer.ID = so.CUSTOMERID INNER JOIN SOSTATUS ON sostatus.ID = so.STATUSID LEFT JOIN PRODUCT ON soitem.PRODUCTID = product.ID JOIN QBCLASS ON qbclass.ID = so.QBCLASSID LEFT JOIN CURRENCY ON currency.HOMECURRENCY = 1 LEFT JOIN ( SELECT postso.SOID AS SOID, MAX(postso.POSTDATE) AS POSTDATE FROM POSTSO WHERE postso.POSTDATE BETWEEN ? AND DATE_SUB(?, INTERVAL 1 SECOND) GROUP BY postso.SOID ) AS postso ON so.ID = postso.SOID INNER JOIN UOM ON uom.ID = soitem.UOMID /* SO TOTALS */ LEFT OUTER JOIN ( SELECT soitem.SOID , SUM(soitem.UNITPRICE * soitem.QTYTOFULFILL + soitem.ADJUSTAMOUNT) AS SOAMTORDERTOTAL , SUM(ROUND( ((IFNULL(qsp.QTYFULFILLEDPRIOR, 0) * soitem.UNITPRICE) + ((IF(soitem.QTYTOFULFILL = 0,0,soitem.ADJUSTAMOUNT / soitem.QTYTOFULFILL) * IFNULL(qsp.QTYFULFILLEDPRIOR, 0)))) * 10 ,1) / 10) AS SOAMTSHIPPEDPRIOR , SUM(ROUND( (((IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) - IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) * soitem.UNITPRICE) + (IF(soitem.QTYTOFULFILL = 0,0,soitem.ADJUSTAMOUNT / soitem.QTYTOFULFILL) * (IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) - IFNULL(qsp.QTYFULFILLEDPRIOR, 0)))) * 10 ,1) / 10) AS SOAMTSHIPPEDTODAY , SUM(ROUND( ((IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) * soitem.UNITPRICE) + (IF(soitem.QTYTOFULFILL = 0,0,soitem.ADJUSTAMOUNT / soitem.QTYTOFULFILL) * IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0)))) * 10 ,1) / 10) AS SOAMTSHIPPEDTODATE , SUM(ROUND( (((soitem.QTYTOFULFILL - IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0))) * soitem.UNITPRICE) + (IF(soitem.QTYTOFULFILL = 0,0,soitem.ADJUSTAMOUNT / soitem.QTYTOFULFILL) * (soitem.QTYTOFULFILL - IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0))))) * 10 ,1) / 10) AS SOAMTREMAINING FROM SOITEM /* get quantity shipped PRIOR to this date */ LEFT OUTER JOIN ( SELECT SOID , SOLINEITEM , IFNULL(MAX(soitem_aud.QTYFULFILLED),0) as QTYFULFILLEDPRIOR FROM SOITEM_AUD WHERE DATE_FORMAT(soitem_aud.DATELASTFULFILLMENT, '%Y %m %d') < DATE_FORMAT(?, '%Y %m %d') AND soitem_aud.PRODUCTNUM NOT IN ('Shipping', 'Shipping Out') GROUP BY SOID , SOLINEITEM ) AS qsp ON soitem.SOID = qsp.SOID AND soitem.SOLINEITEM = qsp.SOLINEITEM /* get quantity shipped ON this date */ LEFT OUTER JOIN ( SELECT soitem.SOID , soitem.SOLINEITEM , IFNULL(soitem_aud.QTYFULFILLED, 0) as QTYFULFILLEDTODATE /* INCLUDES items fulfilled THIS DATE */ FROM SOITEM LEFT OUTER JOIN SOITEM_AUD ON soitem.SOID = soitem_aud.SOID AND soitem.SOLINEITEM = soitem_aud.SOLINEITEM WHERE DATE_FORMAT(soitem_aud.DATELASTFULFILLMENT, '%Y %m %d') = DATE_FORMAT(?, '%Y %m %d') AND soitem_aud.PRODUCTNUM NOT IN ('Shipping', 'Shipping Out') GROUP BY SOID , SOLINEITEM ) AS qftd ON soitem.SOID = qftd.SOID AND soitem.SOLINEITEM = qftd.SOLINEITEM WHERE soitem.PRODUCTNUM NOT IN ('Shipping', 'Shipping Out') GROUP BY soitem.SOID ) as SOTOTALS ON soitem.SOID = sototals.SOID /* LINE ITEM DETAILS */ LEFT OUTER JOIN ( SELECT soitem.SOID , soitem.SOLINEITEM , IFNULL(qftd.SOITEMSTATUSNAME, IFNULL(qsp.SOITEMSTATUSNAME, 'Unknown')) AS SOITEMSTATUS , soitem.QTYTOFULFILL * soitem.UNITPRICE + soitem.ADJUSTAMOUNT as LIAMTORDEREDTOTAL , IFNULL(qsp.QTYFULFILLEDPRIOR, 0) as LIQTYSHIPPEDPRIOR , ROUND( ((IFNULL(qsp.QTYFULFILLEDPRIOR, 0) * soitem.UNITPRICE) + ((IF(soitem.QTYTOFULFILL = 0,0,soitem.ADJUSTAMOUNT / soitem.QTYTOFULFILL) * IFNULL(qsp.QTYFULFILLEDPRIOR, 0)))) * 10 ,1) / 10 AS LIAMTSHIPPEDPRIOR , IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) - IFNULL(qsp.QTYFULFILLEDPRIOR, 0) as LIQTYSHIPPEDTODAY , ROUND( (((IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) - IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) * soitem.UNITPRICE) + (IF(soitem.QTYTOFULFILL = 0,0,soitem.ADJUSTAMOUNT / soitem.QTYTOFULFILL) * (IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) - IFNULL(qsp.QTYFULFILLEDPRIOR, 0)))) * 10 ,1) / 10 AS LIAMTSHIPPEDTODAY , IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) as LIQTYSHIPPEDTODATE , ROUND( ((IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) * soitem.UNITPRICE) + (IF(soitem.QTYTOFULFILL = 0,0,soitem.ADJUSTAMOUNT / soitem.QTYTOFULFILL) * IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, IFNULL(qsp.QTYFULFILLEDPRIOR, 0))))) * 10 ,1) / 10 AS LIAMTSHIPPEDTODATE , soitem.QTYTOFULFILL - IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0)) as LIQTYREMAINING , ROUND( (((soitem.QTYTOFULFILL - IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0))) * soitem.UNITPRICE) + (IF(soitem.QTYTOFULFILL = 0,0,soitem.ADJUSTAMOUNT / soitem.QTYTOFULFILL) * (soitem.QTYTOFULFILL - IFNULL(qftd.QTYFULFILLEDTODATE, IFNULL(qsp.QTYFULFILLEDPRIOR, 0))))) * 10 ,1) / 10 AS LIAMTREMAINING FROM SOITEM /* get quantity shipped PRIOR to this date */ LEFT OUTER JOIN ( SELECT SOID , SOLINEITEM , soitemstatus.NAME as SOITEMSTATUSNAME , IFNULL(MAX(soitem_aud.QTYFULFILLED),0) as QTYFULFILLEDPRIOR FROM SOITEM_AUD INNER JOIN SOITEMSTATUS ON soitem_aud.STATUSID = soitemstatus.ID WHERE DATE_FORMAT(soitem_aud.DATELASTFULFILLMENT, '%Y %m %d') < DATE_FORMAT(?, '%Y %m %d') AND soitem_aud.PRODUCTNUM NOT IN ('Shipping', 'Shipping Out') GROUP BY SOID , SOLINEITEM ORDER BY SOID, SOLINEITEM, soitem_aud.DATELASTFULFILLMENT DESC ) AS qsp ON soitem.SOID = qsp.SOID AND soitem.SOLINEITEM = qsp.SOLINEITEM /* get quantity shipped ON this date */ LEFT OUTER JOIN ( SELECT soitem.SOID , soitem.SOLINEITEM , soitemstatus.NAME as SOITEMSTATUSNAME , IFNULL(soitem_aud.QTYFULFILLED, 0) as QTYFULFILLEDTODATE /* INCLUDES items fulfilled THIS DATE */ FROM SOITEM LEFT OUTER JOIN SOITEM_AUD ON soitem.SOID = soitem_aud.SOID AND soitem.SOLINEITEM = soitem_aud.SOLINEITEM INNER JOIN SOITEMSTATUS ON soitem_aud.STATUSID = soitemstatus.ID WHERE DATE_FORMAT(soitem_aud.DATELASTFULFILLMENT, '%Y %m %d') = DATE_FORMAT(?, '%Y %m %d') AND soitem_aud.PRODUCTNUM NOT IN ('Shipping', 'Shipping Out') GROUP BY SOID , SOLINEITEM ) AS qftd ON soitem.SOID = qftd.SOID AND soitem.SOLINEITEM = qftd.SOLINEITEM WHERE soitem.PRODUCTNUM NOT IN ('Shipping', 'Shipping Out') GROUP BY soitem.SOID , soitem.SOLINEITEM ) as SOLINEITEMS ON soitem.SOID = solineitems.SOID AND soitem.SOLINEITEM = solineitems.SOLINEITEM WHERE soitem.PRODUCTNUM NOT IN ('Shipping', 'Shipping Out') /*AND soitem.TYPEID IN (10,11,12,900,21,30,31,50,60,80) AND so.LOCATIONGROUPID IN (1,2) AND so.CUSTOMERID LIKE ? AND soitem.QBCLASSID LIKE ? AND UPPER(so.SALESMAN) LIKE UPPER(?) AND so.STATUSID IN (?, ?, ?, ?, ?, ?, ?) AND COALESCE(product.NUM,'') LIKE ? AND COALESCE(stateconst.NAME,'') LIKE '%'*/ AND soitem.SOID = 8369 /* TESTING PURPOSES ONLY */ GROUP BY so.num, locationgroup.name, customer.name, so.dateissued, so.statusid, sostatus.name, so.salesman, soitem.productnum, uom.code, solineitems.SOITEMSTATUS, SOAMTREMAINING, itemfulfillment, SOAMTSHIPPEDTODAY, soitem.description, soitem.id, soitem.totalprice, soitem.qtytofulfill, soitem.qtyfulfilled, soitem.unitprice, soitem.adjustamount, postso.postdate, qbclass.name, currency.symbol, stateconst.code ORDER BY groupby, locationgroup.name, IF(1 = 1,customer.name,so.num), so.num 22 Jun 2020 15:07:22 DEBUG [ModifyingSalesOrderSummary subreports #1] jasperreports.engine.query.JRJdbcQueryExecuter (JRJdbcQueryExecuter.java:336) - Parameter #1 (ckShowHistoricalProductNumber of type java.lang.String): 1 22 Jun 2020 15:07:22 DEBUG [ModifyingSalesOrderSummary subreports #1] jasperreports.engine.query.JRJdbcQueryExecuter (JRJdbcQueryExecuter.java:336) - Parameter #2 (dateRange1 of type java.util.Date): Mon Jun 01 23:59:59 EDT 2020