Hi Seema,
What version of Project Server? 2007 or 2010?
Which view are you talking about? I assume you are talking about a view in PWA (Project Center, Resource Center, ...)?
You can create this kind of report using SQL Server Reporting Services. Rather than adding such a link into a view, I would create a report with a parameter.
But before developing such a report, take a look at the available reporting options in Project Server (Project Center and Resource Center views, OLAP Cube, ...)
I hope this helps,
Hans
My EPM blog:
Projectopolis