August 5, 2005 at 10:25 am
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.
August 5, 2005 at 10:36 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply