Custom Form Query

There’s a couple ways you could go about it. Do a trace to find the event called when you bring a resource group into the form, once you have that you can use either the BO reader or a search method from the resource assembly reference to query the resource table. A simple row count at that point can be stored in an unbound text box or you could write it to a UD field on the resource group table.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tracy.smith@...
Sent: Tuesday, February 25, 2014 6:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Custom Form Query



I want to show the number of Resources as a calculated field on the Resource Group. I know this field exists but it counts all Resources and I want the total for Active only but am unsure the best way to go about this as I haven't coded a calculation for counting \ filtering records in another table before. Any suggestions on my best approach?

We're on Vantage 8.03.409a. Thanks.



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


I want to show the number of Resources as a calculated field on the Resource Group.  I know this field exists but it counts all Resources and I want the total for Active only but am unsure the best way to go about this as I haven't coded a calculation for counting \ filtering records in another table before.  Any suggestions on my best approach? 

We're on Vantage 8.03.409a. Thanks.