Group Report - Supress Level

  • Thread starter Thread starter Dorian Chalom
  • Start date Start date
D

Dorian Chalom

How would I go about suppressing a group level if no records in the group
met the criteria?

I know how to suppress the details lines with in the group but how do I
determine if there are any valid values in the group before printing the
group header?
 
Dorian said:
How would I go about suppressing a group level if no records in the group
met the criteria?

I know how to suppress the details lines with in the group but how do I
determine if there are any valid values in the group before printing the
group header?
Click to expand...


You need to explain this in a lot moore detail. Since there
can't be a group header if there are no details, what you're
asking doesn't make sense as stated.
 
OK I have a set of data like this:

Company Person Total
AAA Joe 100
AAA Sam 90
BBB Sue 0
CCC James 0
CCC Walter 10

And I only want to print records with a value > 0

So the out put would be like this:

Company: AAA
Person Value
Joe 100
Sam 90

Company: CCC
Walter 10

Thus not printing Company BBB since there are no valid records for that
group
And only printing Walters record for Company CCC since he is the only one,
and not the first one, in Company CCC with a valid record.
Now it is important that he is not the first one because I can validate in
the Format of the Group Header for the first record, with out a problem, but
where I run into a problem is where i need to check in on all the records in
a group.

Does this help?
 
Dorian said:
OK I have a set of data like this:

Company Person Total
AAA Joe 100
AAA Sam 90
BBB Sue 0
CCC James 0
CCC Walter 10

And I only want to print records with a value > 0

So the out put would be like this:

Company: AAA
Person Value
Joe 100
Sam 90

Company: CCC
Walter 10

Thus not printing Company BBB since there are no valid records for that
group
And only printing Walters record for Company CCC since he is the only one,
and not the first one, in Company CCC with a valid record.
Now it is important that he is not the first one because I can validate in
the Format of the Group Header for the first record, with out a problem, but
where I run into a problem is where i need to check in on all the records in
a group.
Click to expand...


Ok, now I think I see what you're trying to do.

You're going about it the wrong way around, the records you
don't want to see in the report should be filtered out in
the report's record source query, instead of trying to
manage all the data in the table.

Create a query based on the same table that you're using
now. Drag all the fields in the table down to the fields
row in the query grid. Then enter
0
Click to expand...
in the criteria row under the value field. Run the wuery to
test and make sure it only returns the data you want to
display in the report.

When that is working, then open the report in design view,
display the report properties window (View menu) and select
the new query in the report's RecodeSource property. From
what you've said so far, I don't think you need any code in
the report.
 
Back
Top