So I'm building a report model containing several 8 or so numeric amounts. All amounts are numeric(10,2), and there is nothing that would differentiate the columns other than their names.
One of the columns WILL NOT generate any aggregates. It just appears as an attribute. It's inexplicable.
I've even tried to build a model containing just this one numeric attribute, and it still does not work!! VS just hates this one element! Anyone seen anything like this?
I'm running VS 2005 Sp1.
Ah, the beauties of "automagic" model generation. :)
In this case, model generation thinks it's an "ID" column because it's numeric and it ends in "id", so it doesn't bother to generate aggregates. You'll have to do it manually, or change the name temporarily to fool it.
|||WHAAAAAAAAAAAAAAATTTTTT?
What genius came up with that! Any why would an ID field be numeric 10,2!!
Thank you thank you thank you!
And how do you do manual specification of aggregates in the model?
No comments:
Post a Comment