hi!
this is the query i use to show my database table in listview
"select item,description,price,category,date, sum(qty),sum(total) from tbl_records where Date ='" & BunifuDatepicker1.Value.Date & "' group by item,description,category"
but when i use this query for the crystal report the column for qty and total is empty. what will i do ? can anyone please help me.
thankyou!