Referencing fields not in the View, but in the source tables of the view.

  • 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
    Will Summers

  • Can you post more details :

    DDL of the tables

    Sample data (insert dml)

    the results you want from the query

    your query

    the results you are getting now.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply