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

Posted on 2007-07-30
Last Modified: 2013-11-26
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.
Question by:kosturdur
    LVL 11

    Accepted Solution

    You seem to know a little about SQL Server and you mention SQL Reporting Services. Are you aware that this is a featured web site that is designed specifically for this purpose? I have not used the 2005 version but I have built several sites using the 2000 version. You can either use the example web site straight out of the box or you can write your own using the web services interface.

    If you use it straight out of the box you will only need to configure it. It should take less than a day to get it up and running. We built a fully customised site with custom Authentication and Authorisation based on ASP.Net 2.0 master pages and it took us less than a month.
    LVL 5

    Author Comment

    Hi ethoths,
    We are writing add-on to a commercial program so while I'm looking for SQL Reporting Services, I realized that the original SQL Server 2005 that licensed with the program is not include Reporting Services and Anaysis Services. I'm so sorry to learn that now because your solution seemed to be perfect. But know we have to write our code with ASP.Net.
    Any suggestions?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
    More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now