Nilesh,
I think having the reporting server-side is a really good idea, especially if the data is accessed via both a Windows app and a browser app. I don't know if there are other solutions available (I have not researched this at all), all I know about is Crystal and I have not even used it, so I know very little about it. I have no idea what the price is for it.
I suppose another option is to "roll your own" reporting by using ASP.NET to produce web pages of reports.
I really don't know enough about it at this point because I haven't done anything with reporting yet, I'm just speculating.
Hopefully, someone else will jump in here and help you out.
~~Bonnie
>sometimes its really hard to findout the exact and practical practises, if i go for a browser based appl, it would be needing a central server for report. crystal reports has its central solution as enterprise edition which is tooooo costly. I'm really not able to find any alternate.
>I really wonder ppl who develop good multi tier appl have less exposure to the report tier. I really can not club my reports into executable, it has to be an independent tier. how do experts provide the reporting solutions ????? any idea...