BAQ Calculated Field To Count Record

Yahoo Archive
1
>if you can summarize a table in E9 the answer
The summarize problem in my case is probably version specific.
I was using 9.04.506 which has several known issues in the BAQ designer.
I installed a one off fix to take care of the worst - table joins, but I know it broke some other features.

--- In vantage@yahoogroups.com, "brad_boes" <bboes@...> wrote:
>
> I am a little confused on what the true question is, but if you are asking if you can summarize a table in E9 the answer is yes. We have many BAQ's like this.
>
> However, one of the limitations that is not supported is summarizing more than one table name. You can add the same table more than once as an alias and summarize the same table multiple times.
>
> We are on 9.05.603 and this all works.
>
> For example we summarize part material demand to the part by different warehouses using the alias method.
>
> Brad Boes
> Metalworks
>
>
> --- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@> wrote:
> >
> > I am curious about these in 9.05 too.
> >
> > In V8 there is a "Summarize" checkbox for adding tables I want to display aggregate values for.
> >
> > When I try to build a BAQ with aggregates E9, it often fails even though the syntax check is OK.
> > But I can import a V8 BAQ with a calculated count field into E9 and it works fine.
> >
> >
> > --- In vantage@yahoogroups.com, "supertico05" <mvissuet@> wrote:
> > >
> > > In Epicor 9.05 can you add a calculated field to a BAQ where the calculated field counts the number of times a field has a value in a table.
> > >
> > > A simple example of this would be on a Part BAQ, count the number of released jobs for that part number. So the fields displayed would be Part Number, Part Description, and Calculated Field- Job Count.
> > >
> >
>
2
In Epicor 9.05 can you add a calculated field to a BAQ where the calculated field counts the number of times a field has a value in a table.

A simple example of this would be on a Part BAQ, count the number of released jobs for that part number. So the fields displayed would be Part Number, Part Description, and Calculated Field- Job Count.
3
I am curious about these in 9.05 too.

In V8 there is a "Summarize" checkbox for adding tables I want to display aggregate values for.

When I try to build a BAQ with aggregates E9, it often fails even though the syntax check is OK.
But I can import a V8 BAQ with a calculated count field into E9 and it works fine.


--- In vantage@yahoogroups.com, "supertico05" <mvissuet@...> wrote:
>
> In Epicor 9.05 can you add a calculated field to a BAQ where the calculated field counts the number of times a field has a value in a table.
>
> A simple example of this would be on a Part BAQ, count the number of released jobs for that part number. So the fields displayed would be Part Number, Part Description, and Calculated Field- Job Count.
>
4
Not that I'm aware of. You can do the query in Progress with a sub-select
count(*) and also in SQL. If SQL, turn your query with the subselect into a
View and hit the view via ODBC from Crystal. If you're progress, use ODBC
and design the query from within Crystal.



You could also write a BAQ for your "Released Jobs" portion of the report
which is only one field, your "Job Count". You could then set that BAQ to
dump to an XML file on the network at any frequency you desire. Then, from
within Crystal, you can make a subreport in the Detail band only for
calculating this value from your dumped dataset.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
supertico05
Sent: Monday, October 22, 2012 11:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Calculated Field To Count Record





In Epicor 9.05 can you add a calculated field to a BAQ where the calculated
field counts the number of times a field has a value in a table.

A simple example of this would be on a Part BAQ, count the number of
released jobs for that part number. So the fields displayed would be Part
Number, Part Description, and Calculated Field- Job Count.



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5347 - Release Date: 10/22/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5347 - Release Date: 10/22/12

[Non-text portions of this message have been removed]
5
A little Klugy but create a calculated field that puts a 1 in it when the condition is met and a zero otherwise then total in the dashboard or report.

Jim Kinneman
Encompass Solutions, Inc

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Not that I'm aware of. You can do the query in Progress with a sub-select
> count(*) and also in SQL. If SQL, turn your query with the subselect into a
> View and hit the view via ODBC from Crystal. If you're progress, use ODBC
> and design the query from within Crystal.
>
>
>
> You could also write a BAQ for your "Released Jobs" portion of the report
> which is only one field, your "Job Count". You could then set that BAQ to
> dump to an XML file on the network at any frequency you desire. Then, from
> within Crystal, you can make a subreport in the Detail band only for
> calculating this value from your dumped dataset.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> supertico05
> Sent: Monday, October 22, 2012 11:59 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ Calculated Field To Count Record
>
>
>
>
>
> In Epicor 9.05 can you add a calculated field to a BAQ where the calculated
> field counts the number of times a field has a value in a table.
>
> A simple example of this would be on a Part BAQ, count the number of
> released jobs for that part number. So the fields displayed would be Part
> Number, Part Description, and Calculated Field- Job Count.
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2441/5347 - Release Date: 10/22/12
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2441/5347 - Release Date: 10/22/12
>
> [Non-text portions of this message have been removed]
>
6
I am a little confused on what the true question is, but if you are asking if you can summarize a table in E9 the answer is yes. We have many BAQ's like this.

However, one of the limitations that is not supported is summarizing more than one table name. You can add the same table more than once as an alias and summarize the same table multiple times.

We are on 9.05.603 and this all works.

For example we summarize part material demand to the part by different warehouses using the alias method.

Brad Boes
Metalworks


--- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@...> wrote:
>
> I am curious about these in 9.05 too.
>
> In V8 there is a "Summarize" checkbox for adding tables I want to display aggregate values for.
>
> When I try to build a BAQ with aggregates E9, it often fails even though the syntax check is OK.
> But I can import a V8 BAQ with a calculated count field into E9 and it works fine.
>
>
> --- In vantage@yahoogroups.com, "supertico05" <mvissuet@> wrote:
> >
> > In Epicor 9.05 can you add a calculated field to a BAQ where the calculated field counts the number of times a field has a value in a table.
> >
> > A simple example of this would be on a Part BAQ, count the number of released jobs for that part number. So the fields displayed would be Part Number, Part Description, and Calculated Field- Job Count.
> >
>