Epicor 9.05.702 - Crystal Reports - Pass a Summary to a Group Fi

system · July 13, 2013, 9:44am

Good Idea, I will test. Thanks

I was really hoping Crystal could do this, I'm close in crystal, I have
tested the WhileReadingRecords, WhilePrintingRecords on RunningTotals
and got Zeros but have not used or tested the EvaluateAfter(f) and also
want to research the DO WHILE stuff in Crystal.

Patrick Winter

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cathyattechnologicsys
Sent: Friday, July 12, 2013 17:13
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9.05.702 - Crystal Reports - Pass a
Summary to a Group Filter?

Can you summarized the PartTran table in your BAQ?

Then you can create a Calculated field - Total(PartTran.TranQty).

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Winter, Patrick" <pjw@...> wrote:

>
> I need the Summary of the calculated field for the job.
>
>
>
> Detail Lines are suppressed
>
> Job X100 for 4,000 MFG-STK 1,000 ------- Record Line
>
> Job X100 for 4,000 MFG-STK 2,000 -------- Record Line
>
> Job x100 for 4,000 Sum(Mfg-Stk) 3000 ------- Group 1 Footer (Filter
> = Sum(MFG-STK for 3,000) <> Job.ProdQty)
>
>
>
> BAQ will only filter on record level. I want to filer at the Group
> Level.
>
>
>
> Patrick Winter
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of cathyattechnologicsys
> Sent: Friday, July 12, 2013 12:45
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Epicor 9.05.702 - Crystal Reports - Pass a
> Summary to a Group Filter?
>
>
>
>
>
> In your BAQ you should be able to filter on the calculated field under
> Display > Filter Results.
>
> You can choose your calculated field where <> a Filter Value where you
> would choose specified table field value of JobHead.ProdQty.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com> ,

> "Winter, Patrick" <pjw@> wrote:
> >
> > All,
> >
> > In Report Builder (centuries ago) I would "PrePass" a summary field

so

> I
> > could FILTER on that summary.
> >
> > Crystal BAQ Report Example.
> > Link JobHead to PartTran.
> > Group and Sort on JobNumber
> > Sum all the Part Tran Records for "MFG-STK"
> > Group 1 - Footer Line Filter for MFG-STK Qtys that Don't equal the
> > JobHead.ProdQty.
> >
> > Seems Simple but Crystal Group Selection Formulas Just don't seem to
> > work.
> >
> > Sum({BAQReportResult.PartTran.TranQty}) <>
> > {BAQReportResult.JobHead.ProdQty}
> >
> > Is there another way or am I missing something?
> > All suggestions, comments welcome.
> >
> > Patrick Winter
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · July 12, 2013, 1:03pm

All,

In Report Builder (centuries ago) I would "PrePass" a summary field so I
could FILTER on that summary.

Crystal BAQ Report Example.
Link JobHead to PartTran.
Group and Sort on JobNumber
Sum all the Part Tran Records for "MFG-STK"
Group 1 - Footer Line Filter for MFG-STK Qtys that Don't equal the
JobHead.ProdQty.

Seems Simple but Crystal Group Selection Formulas Just don't seem to
work.

Sum({BAQReportResult.PartTran.TranQty}) <>
{BAQReportResult.JobHead.ProdQty}

Is there another way or am I missing something?
All suggestions, comments welcome.

Patrick Winter

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

system · July 12, 2013, 1:26pm

You could try adding a logical field on the detail lines in BAQ.

Something like this:
SortLogical
If PartTran.TranQty <> JobHead.ProdQty then False
Else
True

You might be able to get the grouping and sums you want using that logical field in Crystal

--- In vantage@yahoogroups.com, "Winter, Patrick" <pjw@...> wrote:
>
> All,
>
> In Report Builder (centuries ago) I would "PrePass" a summary field so I
> could FILTER on that summary.
>
> Crystal BAQ Report Example.
> Link JobHead to PartTran.
> Group and Sort on JobNumber
> Sum all the Part Tran Records for "MFG-STK"
> Group 1 - Footer Line Filter for MFG-STK Qtys that Don't equal the
> JobHead.ProdQty.
>
> Seems Simple but Crystal Group Selection Formulas Just don't seem to
> work.
>
> Sum({BAQReportResult.PartTran.TranQty}) <>
> {BAQReportResult.JobHead.ProdQty}
>
> Is there another way or am I missing something?
> All suggestions, comments welcome.
>
> Patrick Winter
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · July 12, 2013, 1:45pm

In your BAQ you should be able to filter on the calculated field under Display > Filter Results.

You can choose your calculated field where <> a Filter Value where you would choose specified table field value of JobHead.ProdQty.

--- In vantage@yahoogroups.com, "Winter, Patrick" <pjw@...> wrote:
>
> All,
>
> In Report Builder (centuries ago) I would "PrePass" a summary field so I
> could FILTER on that summary.
>
> Crystal BAQ Report Example.
> Link JobHead to PartTran.
> Group and Sort on JobNumber
> Sum all the Part Tran Records for "MFG-STK"
> Group 1 - Footer Line Filter for MFG-STK Qtys that Don't equal the
> JobHead.ProdQty.
>
> Seems Simple but Crystal Group Selection Formulas Just don't seem to
> work.
>
> Sum({BAQReportResult.PartTran.TranQty}) <>
> {BAQReportResult.JobHead.ProdQty}
>
> Is there another way or am I missing something?
> All suggestions, comments welcome.
>
> Patrick Winter
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · July 12, 2013, 1:55pm

Will Test but I don't see how grouping below the level I need the
Summary will help.

Patrick Winter

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of b_ordway
Sent: Friday, July 12, 2013 12:26
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9.05.702 - Crystal Reports - Pass a
Summary to a Group Filter?

You could try adding a logical field on the detail lines in BAQ.

Something like this:
SortLogical
If PartTran.TranQty <> JobHead.ProdQty then False
Else
True

You might be able to get the grouping and sums you want using that
logical field in Crystal

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Winter, Patrick" <pjw@...> wrote:

>
> All,
>
> In Report Builder (centuries ago) I would "PrePass" a summary field so

I

> could FILTER on that summary.
>
> Crystal BAQ Report Example.
> Link JobHead to PartTran.
> Group and Sort on JobNumber
> Sum all the Part Tran Records for "MFG-STK"
> Group 1 - Footer Line Filter for MFG-STK Qtys that Don't equal the
> JobHead.ProdQty.
>
> Seems Simple but Crystal Group Selection Formulas Just don't seem to
> work.
>
> Sum({BAQReportResult.PartTran.TranQty}) <>
> {BAQReportResult.JobHead.ProdQty}
>
> Is there another way or am I missing something?
> All suggestions, comments welcome.
>
> Patrick Winter
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · July 12, 2013, 2:12pm

I need the Summary of the calculated field for the job.

Detail Lines are suppressed

Job X100 for 4,000 MFG-STK 1,000 ------- Record Line

Job X100 for 4,000 MFG-STK 2,000 -------- Record Line

Job x100 for 4,000 Sum(Mfg-Stk) 3000 ------- Group 1 Footer (Filter
= Sum(MFG-STK for 3,000) <> Job.ProdQty)

BAQ will only filter on record level. I want to filer at the Group
Level.

Patrick Winter

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cathyattechnologicsys
Sent: Friday, July 12, 2013 12:45
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9.05.702 - Crystal Reports - Pass a
Summary to a Group Filter?

In your BAQ you should be able to filter on the calculated field under
Display > Filter Results.

You can choose your calculated field where <> a Filter Value where you
would choose specified table field value of JobHead.ProdQty.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Winter, Patrick" <pjw@...> wrote:

>
> All,
>
> In Report Builder (centuries ago) I would "PrePass" a summary field so

I

> could FILTER on that summary.
>
> Crystal BAQ Report Example.
> Link JobHead to PartTran.
> Group and Sort on JobNumber
> Sum all the Part Tran Records for "MFG-STK"
> Group 1 - Footer Line Filter for MFG-STK Qtys that Don't equal the
> JobHead.ProdQty.
>
> Seems Simple but Crystal Group Selection Formulas Just don't seem to
> work.
>
> Sum({BAQReportResult.PartTran.TranQty}) <>
> {BAQReportResult.JobHead.ProdQty}
>
> Is there another way or am I missing something?
> All suggestions, comments welcome.
>
> Patrick Winter
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · July 12, 2013, 2:15pm

>I don't see how grouping below the level I need the
> Summary will help.

I was thinking of sub-grouping & then using running totals instead of sums.
But it was just a guess...

BTW, I often use the Crystal forums at TekTips when I have something odd.
http://www.tek-tips.com/threadminder.cfm?pid=767
Posts from lbass have been especially helpful.

--- In vantage@yahoogroups.com, "Winter, Patrick" <pjw@...> wrote:
>
> Will Test but I don't see how grouping below the level I need the
> Summary will help.
>
>
>
> Patrick Winter
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of b_ordway
> Sent: Friday, July 12, 2013 12:26
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Epicor 9.05.702 - Crystal Reports - Pass a
> Summary to a Group Filter?
>
>
>
>
>
> You could try adding a logical field on the detail lines in BAQ.
>
> Something like this:
> SortLogical
> If PartTran.TranQty <> JobHead.ProdQty then False
> Else
> True
>
> You might be able to get the grouping and sums you want using that
> logical field in Crystal
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Winter, Patrick" <pjw@> wrote:
> >
> > All,
> >
> > In Report Builder (centuries ago) I would "PrePass" a summary field so
> I
> > could FILTER on that summary.
> >
> > Crystal BAQ Report Example.
> > Link JobHead to PartTran.
> > Group and Sort on JobNumber
> > Sum all the Part Tran Records for "MFG-STK"
> > Group 1 - Footer Line Filter for MFG-STK Qtys that Don't equal the
> > JobHead.ProdQty.
> >
> > Seems Simple but Crystal Group Selection Formulas Just don't seem to
> > work.
> >
> > Sum({BAQReportResult.PartTran.TranQty}) <>
> > {BAQReportResult.JobHead.ProdQty}
> >
> > Is there another way or am I missing something?
> > All suggestions, comments welcome.
> >
> > Patrick Winter
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · July 12, 2013, 6:12pm

Can you summarized the PartTran table in your BAQ?

Then you can create a Calculated field - Total(PartTran.TranQty).

--- In vantage@yahoogroups.com, "Winter, Patrick" <pjw@...> wrote:
>
> I need the Summary of the calculated field for the job.
>
>
>
> Detail Lines are suppressed
>
> Job X100 for 4,000 MFG-STK 1,000 ------- Record Line
>
> Job X100 for 4,000 MFG-STK 2,000 -------- Record Line
>
> Job x100 for 4,000 Sum(Mfg-Stk) 3000 ------- Group 1 Footer (Filter
> = Sum(MFG-STK for 3,000) <> Job.ProdQty)
>
>
>
> BAQ will only filter on record level. I want to filer at the Group
> Level.
>
>
>
> Patrick Winter
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of cathyattechnologicsys
> Sent: Friday, July 12, 2013 12:45
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Epicor 9.05.702 - Crystal Reports - Pass a
> Summary to a Group Filter?
>
>
>
>
>
> In your BAQ you should be able to filter on the calculated field under
> Display > Filter Results.
>
> You can choose your calculated field where <> a Filter Value where you
> would choose specified table field value of JobHead.ProdQty.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Winter, Patrick" <pjw@> wrote:
> >
> > All,
> >
> > In Report Builder (centuries ago) I would "PrePass" a summary field so
> I
> > could FILTER on that summary.
> >
> > Crystal BAQ Report Example.
> > Link JobHead to PartTran.
> > Group and Sort on JobNumber
> > Sum all the Part Tran Records for "MFG-STK"
> > Group 1 - Footer Line Filter for MFG-STK Qtys that Don't equal the
> > JobHead.ProdQty.
> >
> > Seems Simple but Crystal Group Selection Formulas Just don't seem to
> > work.
> >
> > Sum({BAQReportResult.PartTran.TranQty}) <>
> > {BAQReportResult.JobHead.ProdQty}
> >
> > Is there another way or am I missing something?
> > All suggestions, comments welcome.
> >
> > Patrick Winter
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

Topic		Replies	Views
Crystal Report Formula Question Yahoo Archive	12	501	September 9, 2013
BAQ summaries by Group epicor 9.05.600 Yahoo Archive	3	1027	November 15, 2010
BAQ Calculated Field To Count Record Yahoo Archive	5	3931	October 22, 2012
Summing a formula field Crystal XIR2 Vantage 8.00.810C Yahoo Archive	4	306	February 14, 2007
Summing group footer amounts Yahoo Archive	10	399	September 11, 2012

Epicor 9.05.702 - Crystal Reports - Pass a Summary to a Group Fi

Related Topics