?
Solved

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

Posted on 2007-07-30
2
Medium Priority
?
219 Views
Last Modified: 2016-02-13
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,
0
Comment
Question by:kosturdur
2 Comments
 
LVL 10

Accepted Solution

by:
SystemExpert earned 1500 total points
ID: 19591811
SSAS will be the best option and you are using SQL-2005 so more suitable for customization and to save report template
0
 
LVL 5

Author Comment

by:kosturdur
ID: 19591854
Hi SystemExpert,
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 Idea?
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Screencast - Getting to Know the Pipeline

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question