Silverlight / WPF - Visual Studio Reports

How do I set a rdlc report/WPF to show last 8 records in descending date order.?
I need to show last 8 records and an average of these,the average I can do.
Thanks

David

hi,

use the following query if there are id arrange in descending order like this

select top 8 * from table1 order by id desc

it will give you last 8 record from table

hope this will help you

Hi Reena

I have done it now and it works perfect I forgot to put the filter in for the last 8 dates

Thanks again for your help

Many Thanks

David