Dashboard Query

Yahoo Archive
1
Ben,
I am on my way out the door, so this is untested, but something like below
should do the trick.
You may have to play with the syntax a bit.

for each PartPlant Where PartPlant.Company = cur-comp no-lock,
each PartWhse Where PartWhse.Company = PartPlant.Company
and PartWhse.PartNum = PartPlant.PartNum
and PartWhse.WarehouseCode = "Raw"
and PartWhse.OnHandQty > 0
or PartWhse.Company = PartPlant.Company
and PartWhse.PartNum = PartPlant.PartNum
and PartWhse.WarehouseCode <> "RAW"
no-lock,
each Part Where Part.Company = PartWhse.Company
and Part.PartNum = PartWhse.PartNum
and Part.NonStock = no and
Part.TypeCode = 'M' no-lock
BY Part.PartNum:
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of bbelzer42
Sent: Wednesday, June 22, 2005 4:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Dashboard Query


Oops... left the code out:


for each PartPlant Where PartPlant.Company = cur-comp no-lock,
each PartWhse Where PartWhse.Company = PartPlant.Company
and PartWhse.PartNum = PartPlant.PartNum
no-lock,
each Part Where Part.Company = PartWhse.Company
and Part.PartNum = PartWhse.PartNum
and Part.NonStock = no and
Part.TypeCode = 'M' no-lock
BY Part.PartNum:


Thanks! Ben

--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...> wrote:
> Ben,
> You can add a filter in the query where the linking is done.
> For instance where you call the PartWhse table,
> Add a line that reads... PartWhse.OnHandQty > 0
> If you need more detail, post the contents of your query.
>
> Good luck,
> Aaron Hoyt
> Vantage Plastics
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
> Of bbelzer42
> Sent: Wednesday, June 22, 2005 3:23 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Dashboard Query
>
>
> I have a dashboard query that shows me everything I have on hand for a
> part. It shows the part twice (two lines) if it is in 2 warehouses.
>
> Is there a way to keep a line from showing? Ie: If the Warehouse has
> 0 on hand, can I make the line not show?
>
> Thanks,
> Ben
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
I have a dashboard query that shows me everything I have on hand for a
part. It shows the part twice (two lines) if it is in 2 warehouses.

Is there a way to keep a line from showing? Ie: If the Warehouse has
0 on hand, can I make the line not show?

Thanks,
Ben
3
Ben,
You can add a filter in the query where the linking is done.
For instance where you call the PartWhse table,
Add a line that reads... PartWhse.OnHandQty > 0
If you need more detail, post the contents of your query.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of bbelzer42
Sent: Wednesday, June 22, 2005 3:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Dashboard Query


I have a dashboard query that shows me everything I have on hand for a
part. It shows the part twice (two lines) if it is in 2 warehouses.

Is there a way to keep a line from showing? Ie: If the Warehouse has
0 on hand, can I make the line not show?

Thanks,
Ben




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
4
Here is what I have. What I would like to NOT see are any lines where
there are 0 parts in the RAW warehouse. If there are 0 parts in any
other warehouse, I would like to see those.

Any help would be MUCH appreciated.

Thanks!
Ben

--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...> wrote:
> Ben,
> You can add a filter in the query where the linking is done.
> For instance where you call the PartWhse table,
> Add a line that reads... PartWhse.OnHandQty > 0
> If you need more detail, post the contents of your query.
>
> Good luck,
> Aaron Hoyt
> Vantage Plastics
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
> Of bbelzer42
> Sent: Wednesday, June 22, 2005 3:23 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Dashboard Query
>
>
> I have a dashboard query that shows me everything I have on hand for a
> part. It shows the part twice (two lines) if it is in 2 warehouses.
>
> Is there a way to keep a line from showing? Ie: If the Warehouse has
> 0 on hand, can I make the line not show?
>
> Thanks,
> Ben
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
5
Oops... left the code out:


for each PartPlant Where PartPlant.Company = cur-comp no-lock,
each PartWhse Where PartWhse.Company = PartPlant.Company
and PartWhse.PartNum = PartPlant.PartNum
no-lock,
each Part Where Part.Company = PartWhse.Company
and Part.PartNum = PartWhse.PartNum
and Part.NonStock = no and
Part.TypeCode = 'M' no-lock
BY Part.PartNum:


Thanks! Ben

--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...> wrote:
> Ben,
> You can add a filter in the query where the linking is done.
> For instance where you call the PartWhse table,
> Add a line that reads... PartWhse.OnHandQty > 0
> If you need more detail, post the contents of your query.
>
> Good luck,
> Aaron Hoyt
> Vantage Plastics
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
> Of bbelzer42
> Sent: Wednesday, June 22, 2005 3:23 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Dashboard Query
>
>
> I have a dashboard query that shows me everything I have on hand for a
> part. It shows the part twice (two lines) if it is in 2 warehouses.
>
> Is there a way to keep a line from showing? Ie: If the Warehouse has
> 0 on hand, can I make the line not show?
>
> Thanks,
> Ben
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links