Hello Damodar,
Deciding a Reporting tool is a difficult task 'coz it is based on a lot of conditions/requirements one is looking out to be fulfilled . So, it will be difficult for me to directly suggest that Crystal Report would be the right tool for you ,without knowing the features that you are looking out for.
Since I have worked only on Crystal Reports , I can talk only about pros and cons of using Crystal Reports .
I can suggest that you visit http://www.crystaldecisions.com/products/crystalreports/features.asp?ref=crystalreportsFeatures_LSLinks which talks about the features of Crystal Reports and, http://www.crystaldecisions.com/products/crystalreports/whatsnew.asp?ref=crystalreportsNew_LSLinks which talks about What's new in Crystal Reports. They might probably be able to help you !!
To know more about Licenses,please visit http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr85_asp_licensing.pdf .
Crystal Reports requires you to know some SQL to query the database.
Regards,
Pooja M.,
http://home.attbi.com/~pooja.mohan