Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ws5926
Yak Posting Veteran
88 Posts |
 Posted - 2005-08-05 : 12:13:27
|
| 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 view2. the ability to reference a column in the source table of the view when I reference the viewThanks in advance for any help with the problem.Live to ThrowThrow to Live |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-05 : 12:39:38
|
| ok, you are going to have to provide us more information so we can help. We will need DDL of the underlying tables, your view in question as well as test data.You should also have an example of how the data is currently looking, and how you want the data to look.Read this blog entry for more details: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx-ec |
 |
|
|
|
|
|
View problems