Can any one let me know whether we can create Crystal reports from Asp.net at run time based on the user's selection of tables and fields that appear in the report.
User should select fields and tables in aspx and based on these the report(crystal report) should be developed.Here user can select any table & field from a given list.
From what you have said, Yes it is possible, as you stated. You provide the choices from which the user can pick from, and from the selections (essential just variables given the value by the selections made by the user) you should be able to pass those in to create reports.
Not saying I know how to do it off the top of my head, but essentially the logic is the same as the report generation in an Access Project. Same exact principles of a set of choices providing the sources of data on which to create the report.
Hope this makes sense. If you want actual code, that is something I would recommend you attempt and ask of assistance as needed.
It is more than just code. Reports are the output of your data stores, so design is as much of a consideration as code. It is not like I can say here, this is the code for writing a Crystal Report in ASP.Net, it is a little more involved than that. S
So saying that here are some questions I have: Q Do you have Visual Studio 2003 Architect or better? <-- At least do you have Visual Studio 2003 with Crystal Reports Installed ???