[6.1 - CR 8.5] Need Some Crystal Help with Summing

Yahoo Archive
1
Perfect! That's exactly what it needed. Thanks!
-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Linda Lowney
Sent: Friday, March 06, 2009 9:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 - CR 8.5] Need Some Crystal Help with Summing


Hi Todd,

Try using a running total.

Regards,

Linda

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Todd Caughey
Sent: Friday, March 06, 2009 9:01 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] [6.1 - CR 8.5] Need Some Crystal Help with
Summing

OK, I figured out the cause first thing this morning - amazing what
getting away from the problem for awhile will do. But I still have no
solution. The report treats Misc Charges as a seperate detail line so
the summary counts things twice. Report Builder has an Accumulation
level to set where it accumulates at. I don't see this in Crystal. Can
this be done is a summary? Otherwise I'll play around with the
sort/group levels to get it to accumulate only at each pack line within
an order line.
Thanks,
-Todd C.

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Todd Caughey
Sent: Thursday, March 05, 2009 3:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] [6.1 - CR 8.5] Need Some Crystal Help with Summing

I'm completely preplexed. I'm making a version of ARFORM (invoice) that
consolidates invoice lines (derived from pack slip lines) under the
order line. When we ship from multiple Finished WIP locations it creates
a new pack line for each...which translates into multiple invoice lines
that will be very confusing to the customer.

I changed the grouping to group by Order Line. In most of my testing the
new version exactly matches the live version. But in one case (so far)
the sum for a very simple invoice (one invline, one order, one
orderline, one release) where the quantity is one....comes up as
quantity 2...the extended price is also doubled. The data in the DBF
files all looks correct and no file has more than one row. I even threw
in an extra detail line and it does not show anything odd either....just
one invoice line.

I'm forcing myself to do more CR to get away from Report Builder so I'm
still running into new things. Perhaps I am missing something subtle
about making a summary. Any ideas why it would be doubling the amounts?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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]





[Non-text portions of this message have been removed]
2
I'm completely preplexed. I'm making a version of ARFORM (invoice) that consolidates invoice lines (derived from pack slip lines) under the order line. When we ship from multiple Finished WIP locations it creates a new pack line for each...which translates into multiple invoice lines that will be very confusing to the customer.

I changed the grouping to group by Order Line. In most of my testing the new version exactly matches the live version. But in one case (so far) the sum for a very simple invoice (one invline, one order, one orderline, one release) where the quantity is one....comes up as quantity 2...the extended price is also doubled. The data in the DBF files all looks correct and no file has more than one row. I even threw in an extra detail line and it does not show anything odd either....just one invoice line.

I'm forcing myself to do more CR to get away from Report Builder so I'm still running into new things. Perhaps I am missing something subtle about making a summary. Any ideas why it would be doubling the amounts?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.



[Non-text portions of this message have been removed]
3
OK, I figured out the cause first thing this morning - amazing what getting away from the problem for awhile will do. But I still have no solution. The report treats Misc Charges as a seperate detail line so the summary counts things twice. Report Builder has an Accumulation level to set where it accumulates at. I don't see this in Crystal. Can this be done is a summary? Otherwise I'll play around with the sort/group levels to get it to accumulate only at each pack line within an order line.
Thanks,
-Todd C.


________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Todd Caughey
Sent: Thursday, March 05, 2009 3:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1 - CR 8.5] Need Some Crystal Help with Summing


I'm completely preplexed. I'm making a version of ARFORM (invoice) that consolidates invoice lines (derived from pack slip lines) under the order line. When we ship from multiple Finished WIP locations it creates a new pack line for each...which translates into multiple invoice lines that will be very confusing to the customer.

I changed the grouping to group by Order Line. In most of my testing the new version exactly matches the live version. But in one case (so far) the sum for a very simple invoice (one invline, one order, one orderline, one release) where the quantity is one....comes up as quantity 2...the extended price is also doubled. The data in the DBF files all looks correct and no file has more than one row. I even threw in an extra detail line and it does not show anything odd either....just one invoice line.

I'm forcing myself to do more CR to get away from Report Builder so I'm still running into new things. Perhaps I am missing something subtle about making a summary. Any ideas why it would be doubling the amounts?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

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





[Non-text portions of this message have been removed]
4
Hi Todd,



Try using a running total.



Regards,

Linda







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Friday, March 06, 2009 9:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1 - CR 8.5] Need Some Crystal Help with
Summing



OK, I figured out the cause first thing this morning - amazing what
getting away from the problem for awhile will do. But I still have no
solution. The report treats Misc Charges as a seperate detail line so
the summary counts things twice. Report Builder has an Accumulation
level to set where it accumulates at. I don't see this in Crystal. Can
this be done is a summary? Otherwise I'll play around with the
sort/group levels to get it to accumulate only at each pack line within
an order line.
Thanks,
-Todd C.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Todd Caughey
Sent: Thursday, March 05, 2009 3:37 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] [6.1 - CR 8.5] Need Some Crystal Help with Summing

I'm completely preplexed. I'm making a version of ARFORM (invoice) that
consolidates invoice lines (derived from pack slip lines) under the
order line. When we ship from multiple Finished WIP locations it creates
a new pack line for each...which translates into multiple invoice lines
that will be very confusing to the customer.

I changed the grouping to group by Order Line. In most of my testing the
new version exactly matches the live version. But in one case (so far)
the sum for a very simple invoice (one invline, one order, one
orderline, one release) where the quantity is one....comes up as
quantity 2...the extended price is also doubled. The data in the DBF
files all looks correct and no file has more than one row. I even threw
in an extra detail line and it does not show anything odd either....just
one invoice line.

I'm forcing myself to do more CR to get away from Report Builder so I'm
still running into new things. Perhaps I am missing something subtle
about making a summary. Any ideas why it would be doubling the amounts?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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]