Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Multiple levels of grouping Post Reply Post New Topic
Author Message
JackieTDA
Newbie
Newbie


Joined: 25 Jul 2012
Online Status: Offline
Posts: 1
Quote JackieTDA Replybullet Topic: Multiple levels of grouping
    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.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.