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?
Attachments:
1 Answer:
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
