Tabular report section event rules

bvtaylor

Member
When I make the slightest of changes to an event rule the report runs but does not retrieve any data. Where before the change report runs fine. The code below is just one calculation on one variable on one line of a multipage report.

Even if I comment out the code I just added same "No data" message.

//
If RV Description is equal to "COST OF SALES AT STANDARD"
RV mnMtdActualAmtPerUnit = [RV mnActualMTD]/[RV SOLD+USED_MTD(g)]
Else
End If
//


Thanks for any insight you may provide.. Bob
 

Attachments

  • 186417-PUMA Code Snippet.png
    186417-PUMA Code Snippet.png
    136.7 KB · Views: 43
As a standard troubleshooting approach, try generating a jdedebug log, and inspect the generated SQL, and confirm that the SQL is what you are expecting (especially the "where" clause). Then, confirm the SQL actually returns data by processing the SQL command using a native SQL utility. If that is successful, then you will have to step through the log to find where the logic is breaking down.
 
Before doing a divide operation always check to ensure the divisor is not 0. Otherwise run risk of a divide by zero error.
 
Back
Top