Print Page | Close Window

Multiple levels of grouping

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17125
Printed Date: 21 Apr 2025 at 2:47am


Topic: Multiple levels of grouping
Posted By: JackieTDA
Subject: Multiple levels of grouping
Date Posted: 26 Jul 2012 at 4:35am
Just getting back to crystal after several years away...need some refresher help. I am creating a report with company, name of product type A, name of product type b, and name of product type C. I have tried grouping and sub-reports, but either way, end up with repetitive results. I would like to see the report result of Company A, with a listing from each product type category. I get duplicates with each type of report.


Replies:
Posted By: lockwelle
Date Posted: 31 Jul 2012 at 6:55am
have you tried something like:
make a formula
{table.producta} + {table.productb} + {table.productc}
 
group by this formula and go from there...you might still get dupes, if there are dupes in the data, but you can work on a suppression formula like:
 
{table.producta} = prior(table.producta)
and
{table.productb} = prior(table.productb)
and
{table.productc} = prior(table.productc)
 
 
HTH


Print Page | Close Window