View problems

[Will192]

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.

 

[Will192]

Admin please delete this post. I meant to post it in a different group, not the DTS group.