Hi phil,

My source is an SQL table from SQL server 2005. So you are suggesting me to leave everything till the SSRS side, then do a stored procedure? In my opinion which will be most prob wrong, would be getting the EVENT_DT column out in the correct format then followed by filtering the data that i want using condition split. After getting this two done. i shall do a order by, then store it in a destination table. Then i will be able to use the destination table at SSRS with the stored procedure methods u mention. Am i right to assume that?

Thanks,

10e5x