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#, SQL Server 2005 and Devex. 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 XPO Objects, Datasets)?

 b) How should I save the report designs ( as XPO objects?, in database?, or in SQL Server)?

 c) Is there complete solution or a (architecture) design pattern for this kind of design?

 d) Do you have samples, walkthroughs?

 e) For all of these which Devexpress components, controls, you prefer?

Note: I mustn't use SQL Server Reporting Services or SQL Server Analysis Services

Any contribution is helpful.
Thanks,