Running sql below in data pane and it is returning data as I want i.e. it is giving data in highest value order.
However in preview pane it is returning data in customer name order. How can I circumvent this?
Also how do I get report to display £ sign instead of $ sign
Any recommendations for best book to read as I am new to RS 2005
select customername, year(startdate) as year, count(DISTINCT projectno) as proiects, SUM(DISTINCT oitvalue) as localoit
from forecast
group by customername, year(startdate)
Order by localoit desc