Grouping a report

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

I have a query which has 4 fields.. say Company, Sector, Industry Group and
Industry. I have a report with a grouping in the all 3 levels (i.e, Sector,
IndustryGroupp and Industry). What I need is to limit the grouping. For eg.
My sector ID's are like 10, 15, 20, 25, 30, 35 etc... The report should
group .. if my Sector IDs are Less than 20 I need all the grouping as it is
now (all the 3 level grouping) but when the sectorID is Greater 25 then I
want to stop/hide the 3rd level grouping (i.e Industry Level). Is this
possible? Either by a code or function??


Thank you very much for the help and highly appreciated.

Mac
 
Thank you guys. I have solved the problem by making visible property of
group3 false

Thanks


Mac
 
Back
Top