supressing or hiding groups and detail lines

[kenh9]

I am trying to write a report that has 4 levels.
district county voting precinct block.

a district can be comprised of a part of a county or many counties
likewise a district can be comprised of a part of a voting precinct or many
voting precincts, but a block can only be in one district.
Voting precincts are 1 to many blocks.

What i am trying to do is if a county is in only one district then just give a total line
for the county, but if the county is cut up into multiple districts then list the voting
precincts out that are in that district. I then need to do the same for Voting precincts
if they are cut into multiple districts and that is to list out the blocks that comprise it.

Example:
District 1:
County A:
Voting Precinct 1:
Block A: 1 2 3 4 5
Block B: 1 2 3 4 5
.
.
Voting Precinct 2: 1 2 3 4 5
Voting Precinct 3: 1 2 3 4 5
.
.
County B: 1 2 3 4 5
.
.
.
District 2:
.
.
.

My files look kind of like this

doj.dbf
block (C15)
District (C12)

block_key.db
block (C15)
county (C5)
Vtd (C11)

Co_key.db
county (C5)
county name (C40)

Vtd_key.db
Vtd (C11)
Vtd name (C40)

Any help is greatly appreciated

 

[kenhamady]

You can suppress any section based on a condition. Use the menu commands:

Format Section
Highlight the section on the left.
Click the button to the right of Suppress property.

The condition has to be a T/F formula like:

{sales.price} > 0

and it should be true when you want the suppress to happen.

So for the precinct header and footer you should have a formula that checks the count of the precincts in each County:

DistinctCount({table.Precinct}, {table.county}) = 1


This will suppress those sections when there is only one precinct in that county. Follow the same pattern for each section. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)