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 SQL Server Reporting Tools, OLAP Cubes, Objects, Datasets)?
b) How should I save the report designs ( as objects?, in database?, or in SQL Server Reporting Tools, in OLAP Cubes in MDX Queries)?
c) Should I use Analysis Services(OLAP) or SQL Reporting Services?
d) Is there complete solution or a (architecture) design pattern for this kind of design?
e) Do you have samples, walkthroughs?
Any contribution is helpful.