SQL Server Performance

View problems

Discussion in 'General Developer Questions' started by Will192, Aug 5, 2005.

  1. Will192 New Member

    I have a client/server reporting application that let's the user create and run adhoc queries on my database.

    I have a view that summarizes rows and does other calculations by office. I want to be able to combine offices and have the calucations come out correct.

    If I modify the source of the view I can make the numbers come out correctly. If I try to combine the offices in the view, the calculations don't come out correct. Some offices are bigger than others and the view just treats each office as the same size.

    The source of the view is way to complex to build into the reporting application without modifications to the application.

    Basically I am looking at two options :

    1. dynamically created view

    2. the ability to reference a column in the source table of the view when I reference the view

    Thanks in advance for any help with the problem.

    Live to Throw
    Throw to Live
  2. ghemant Moderator

    what type of tool you are using too develop reporting system ? if you are using VB / Crystalreport or ASP then you can achieve both option using sqldmo.dll as reference and by creting reportwizard ,actually examples are given in ms sql folder (installed at your system) and for more you can visit www.planet-source-code.com for more examples.<br /><br /><br />HTH<br /><br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards<br /><br />hsGoswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />

Share This Page