Hello, when I load a SQL query into a jasper studio report, the columns in which Sum, convert, MIN, MAX are used are either empty, or it says which column is counted. How to fix it?
Posted on February 9, 2023 at 6:28am
Assuming the SQL is correct you should provide an alias for each column by adding "as" followed by the alias name.
SELECT CONVERT(VARCHAR(10), MIN(DateBeginPeriod), 103) AS StartDate , CONVERT(VARCHAR(10), MAX(DateEndPeriod), 103) AS EndDate FROM UnmeteredConsumption