We are working on a share point 2010 application where there is a requirements of complex reporting.
As per requirement there will be a Link List which will have couple of links. On clicking these link user can download reports in excel format. These Excel reports contains data from one of the List with conditional formatting. e.g. color code all the records which have order date > today.
I am not very sure if this can be achieved using any OOB functionality. if it is there. Please let me know also i will request you to help me with alternate solutions.