Report Chart Doesn't Recognize Numeric Values

My query report chart will not recognize numeric columns to choose as the Y-Value of my chart. Is there something I am missing to populate the Y-Value drop down menu? The values are integers in the database and I am specifying integer in the query format.

tabEntry.bears as “Bear Name::200”,
tabEntry.bear_cubs as “Cubs:Int:200”

Which then gives me this screen where the X menu is populated but the Y menu is not.


hello, I’m having the same issue. Do you find the solution yet?

No, I never made it work. Maybe a script report would be a work around.