Need to sort data and get top 10 only by value

  • 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

  • Ignore £ sign question as I figured this one out - I hadn't set report language property to UK

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply