use Sum, convert, MIN, MAX

[deadsploid]

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?

[jgust]

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 EndDatefrom UnmeteredConsumption[/code]