troubleshooting Question

Designing a reporting web site? Join the discussion, please.

Avatar of Umut Şeker
Umut ŞekerFlag for Turkey asked on
.NET ProgrammingASP.NETMicrosoft SQL Server 2005SSAS
2 Comments1 Solution288 ViewsLast Modified:
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.
Thanks,
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros