Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on 

Crystal Reports Formula that counts the product type by packaging without

I have a product type that needs to counts the number of product types in boxes.
So if the product is Shampoo then how many boxes of shampoo or toothpaste how many boxes
What I want should look like this.
       Truck # 100
                                         Prell  :  20
                                        Crest : 48
                                        Floss : 52

Currently the data is in this format where the Products (Prell,Crest,Floss) are in a subreport with no way of counting the individual boxes. However at the primary report level I can count the boxes by product but do not know how to when I need to post them alongside the product types. As seen above. Can this be done...?

     Truck # 100
                        Total Boxes 120
                                                  Prell  
                                                  Crest
                                                  Floss
Crystal Reports

Avatar of undefined
Last Comment
RUA Volunteer2?
ASKER CERTIFIED SOLUTION
Avatar of code_me
code_me

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of RUA Volunteer2?

ASKER

You guys were right I did not need to add a subreport after all. I was mistaken. I do not think this is a good question for the knowledge base. Sorry for the confusion.
Crystal Reports
Crystal Reports

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo