Here is a tip from the Flexible Solutions GP Reports October newsletter on how to create a running total in Crystal Reports.
Running totals are a great way to show totals that have a different calculation than a subtotal without having to write additional formulas.
Let’s look at an example: You have a list of unapplied vendor transactions grouped and subtotaled by vendor class. Below is an example of what this report looks like right now:
For each vendor class you already have a total due, but you also want to show the total credit limit so that you can compare the totals for each class. The credit limit is stored at the vendor level and because your report has more than one transaction per vendor, you cannot simply subtotal the credit limits for all the detail lines. Here are the steps to create a running total for the credit limit by vendor class:
-
Add the Credit Limit field somewhere in your detail section
-
Choose a name for the Running Total
-
Change the Evaluate setting to ‘On change of field’ and enter the vendor ID field (in this case PM00200.VENDORID)
-
Click OK to close the Create Running Total Field window
-
Click OK to close the Record Sort Expert window
Your report now has the credit limit totals per vendor class:
For more tips like this, sign up to receive GP Reports newsletters via e-mail. Or check out the newsletter archives on the Flexible Solutions website.
Victoria:
Thanks for the great info> We are a bit stuck. We have been using Crystal to provide a more “designed” SOP order and invoice report since GP8. We now have gp2010 and are using the latest crystal 11 for 2010. We have created some kits that when we send the sales order to the crystal printer, the kit components are printed below the “kit item”. So, if we sell a kit that has 15 items in it, my order acknowlegment report gives me the item with its price then the 15 items in the kit print on the report, unpriced like a kit should be. We were hoping to only provide the itme number line without the kit components printing on customer facing materials.
In the GP form, e.g the “long form”, unless i check “Print kit components” only the kit item shows up on the long form Sales order report – 1 line item with the price.
Is there a specific table or item field that we need to reference in Crystal to emulate the kit behavior in the GP report instead of the current description (we reference SOP10200.ITEMNMBR as well as ITEMDESC strings in the report) and non kit items print to the report exactly as planned.
Thanks in advance.
LikeLike
Chris,
I am tired and might have gotten lost a little in your explanation – are you asking how you can hide the components of the kit and just show one ‘main’ line item per kit? If so, you can add a restriction of CMPNTSEQ = 0 on the SOP10200 table – kit components will always have a CMPNTSEQ of something other than 0.
Hope that helps.
-Victoria
LikeLike
it is what we were trying to do, 1 main line. Thanks for the advice, we will put it in the table.
Best,
Chris
LikeLike
Excellent – glad to help.
-Victoria
LikeLike
Great stuff.. Victoria.
LikeLike
Great instructions. Thanks.
LikeLike
I bookmarked this link. Thank you for good job!
victoriayudin.com – go to my favorites!!!
LikeLike
Great Stuff Victoria! Thanks.
LikeLike
Thanks Frank! You were the inspiration for this one. 🙂
-Victoria
LikeLike