DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Dynamic Columns & Dynamic Grouping ???

  1. #1
    Join Date
    Dec 2006

    Dynamic Columns & Dynamic Grouping ???


    We need to design more than 500 Reports for our ongoing project and we are dealing with MS SQL Server 2005 Reporting Services first time. We are currently confused in 2 things

    1) How to manage Reports? I mean we should store entire report in database and load at runtime or simply store as a report file
    2) Most Important is Dynamic Columns & Dynamic Grouping.
    We need something like Microsoft Office Accounting 2007 Reports. Header part of form has some parameters for filter and right part has some parameters for showing or hiding and reordering columns and groups.
    We are not getting clue for this dynamic stuff. Can any one post working sample or at least necessary basic code with some idea?

    Thanks lot

  2. #2
    Join Date
    Jan 2007
    Hi ngambhava!

    Well, without knowing the exact business requirements it seems that one possible solution for you would be MS Reporting Services (part of SQL2005).

    Reporting Services come with MS Business Intelligence Development Studio (a special version of Visual Studio for DB stuff). You can do all the grouping things with it and make nice headers and whatever else you need.

    It also manages all the reports you define and users can access everything via web (IIS is required).

    Check the MS SQL 2005 Server website

    Hope its helps!

Similar Threads

  1. DataGrid Header in Dynamically Added Template Columns
    By David Hirschfeld in forum ASP.NET
    Replies: 0
    Last Post: 01-05-2003, 12:49 PM
  2. Replies: 0
    Last Post: 11-14-2002, 02:19 PM
  3. dynamic cursor and pl/sql table
    By Ervin Rodriguez in forum Database
    Replies: 1
    Last Post: 10-31-2002, 11:41 PM
  4. Overriding Columns property of s List
    By Traci A Butler in forum .NET
    Replies: 2
    Last Post: 03-26-2002, 11:21 AM
  5. Adding dynamic columns in a stored procedure
    By Rick McLean in forum Database
    Replies: 0
    Last Post: 12-15-2000, 05:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center