BAQ Summarize Blank Title 71497

Yahoo Archive
1
Don't summarize the table unless you don't need to impose criteria limits on any fields in it, base a calc field upon it in anyway - or just plain want the ability to see the detail (perhaps through an expandable detail dashboard).

Instead (when setting up the joins) indicate you want the first join linked record instead of all.

--- On Tue, 12/2/08, Daniel Laidig <daniellaidig@...> wrote:
From: Daniel Laidig <daniellaidig@...>
Subject: [Vantage] BAQ Summarize
To: vantage@yahoogroups.com
Date: Tuesday, December 2, 2008, 2:39 PM











I writing a search baq for quotes. I found that each Salesman linked to a

quote is stored in a separate table but in sales order entry, all the

salesmen are stored in one field. My problem is trying to write a baq for

the quote because in order to display the salesmen you have to link to the

other table, resulting in duplicate quote lines if you have multiple

salesmen. It is very awkward. IS there a way to use the summarize table

feature to summarize the salesmen into one field?



Daniel Laidig



[Non-text portions of this message have been removed]
2
I writing a search baq for quotes. I found that each Salesman linked to a
quote is stored in a separate table but in sales order entry, all the
salesmen are stored in one field. My problem is trying to write a baq for
the quote because in order to display the salesmen you have to link to the
other table, resulting in duplicate quote lines if you have multiple
salesmen. It is very awkward. IS there a way to use the summarize table
feature to summarize the salesmen into one field?



Daniel Laidig



[Non-text portions of this message have been removed]
3
At the very least you can use the "first" instead of "each" modifier
on the table join to only return a single record from the workforce
table versus all of them.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Daniel Laidig
Sent: Tuesday, December 02, 2008 2:40 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Summarize



I writing a search baq for quotes. I found that each Salesman linked to
a
quote is stored in a separate table but in sales order entry, all the
salesmen are stored in one field. My problem is trying to write a baq
for
the quote because in order to display the salesmen you have to link to
the
other table, resulting in duplicate quote lines if you have multiple
salesmen. It is very awkward. IS there a way to use the summarize table
feature to summarize the salesmen into one field?

Daniel Laidig

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]