ba_trainer
asked on
Collapse empty fields in reports & reduce area
I have a report where I want to collapse the area if there is no data.
I have set the field properties to CAN GROW/CAN SHRINK = YES.
When I run the report, this works - there is no data there.
However, the area for the field remains. So there is no data, but a large space instead.
Is there a property for the entire report to reduce this area if empty?
The report now takes up much unneccesary space. Thanks!!
I have set the field properties to CAN GROW/CAN SHRINK = YES.
When I run the report, this works - there is no data there.
However, the area for the field remains. So there is no data, but a large space instead.
Is there a property for the entire report to reduce this area if empty?
The report now takes up much unneccesary space. Thanks!!
Select on the detail area of the report and set Shrink/Grow to yes
Does the field cover the entire width of the Report?
Problem arises when adjacent fields may have data, then the field can't shrink.
Problem arises when adjacent fields may have data, then the field can't shrink.
In addition to Imoutwest, if this is in a Group, you'll need to set the Header or Footer's property to Can Shrink
ASKER
Using the detail secion doesn't work. I do understand what you mean about the adjacent fields, but that's not the case.
Hmmm..have to keep trying..
Hmmm..have to keep trying..
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
puppydogbuddy,
very helpful site, should explan the many variable when sizing a report and the expected outcome. Thanks
very helpful site, should explan the many variable when sizing a report and the expected outcome. Thanks