I am working with Crystal 8.5 and I have a long list of products, however, I only want to display products that contains the word "LOTION"...example below:
Skin-So-Soft Lotion
Mineral Lotion
Lotion To Sooth
Mineral Oil
Cocoa Butter Oil
I want to display the line items that contain the word...
I do apologize for not giving all details to my report setup. Okay here is what I have:
#1 - Formula:
if ({Table.IceCream Flavor} = ["Chocolate", "Vanilla","Strawberry","Banana"]) then
1
else
0
I have grouped the {Table.IceCream Brand} and grouped the
{Table.IceCream Flavor}
I've got the...
You can also, group the fields and move the field you are reporting into the Group Header line and suppress the Detail line. This will suppress the duplicate items.
-4hrlife
Hi, I am using Crystal Reports 8.5 Version. I am trying to get a count of items that only appears within a group. Example below, I have a category named 'Ice Cream' and I have several different flavors...I want to count the number of flavored ice cream within each group. In this case I have 3...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.