As soon as we will or already we had the same problem. So, please join the discussion.
I would like to design a report tool(web site) by using ASP.Net, C# and SQL Server 2005. The user could be design his report and save from the design page and could view his designed page from report page by the help of grids and charts. The user could also give some filters while viewing the report. I have some questions while making this structure...
What should be done for the design page? For example;
a) How should I view the Database tables structure? Should I use views instead of table structures or any other way(like using Objects, Datasets)?
b) How should I save the report designs ( as objects?, in database?)?
c) Is there complete solution or a (architecture) design pattern for this kind of design?
d) Do you have samples, walkthroughs?
Note:I can't use SQL Server Reporting Services or SQL Server Analysis Services because original SQL Server 2005 that licensed with the commercial program, that we are writing add-on, is not include Reporting Services and Anaysis Services.
Any contribution is helpful.