Page 1 of 1

sorting report

Posted: Mon Dec 26, 2011 2:46 am
by ronak
hi i have data source that displayed data with this code

Code: Select all

select * from boiler where date like @date
in these data i have on field with name 'count ' i want to sort my report with this field
thanks

sorting report

Posted: Mon Dec 26, 2011 6:21 am
by HighAley
Hello.
ronak wrote:hi i have data source that displayed data with this code

Code: Select all

select * from boiler where date like @date
in these data i have on field with name 'count ' i want to sort my report with this field
Please, try to use next query:

Code: Select all

select * from boiler where date like @date order by count
Thank you.