ms access dynamic reporting

[seth rosenberg]

i am a novice at microsoft access reporting (2007) I am trying to create a report that has sections or layers. I want specific sections or layers visable on a condition.. for example, within the data are a couple of yes no questions, if one of the questions are Yes, I want for that record another section to appear..

example, data for an inventory listing, where the report will generate a single page for each item, If there the item is flagged with a picture atachment (yes no option) then I want the report to include the picture, if not, I dont' want the space alocated for the picture to exist.. so the report will perhaps shift up.

thanks in advance.

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx

 

[S.Clark]

Each section, and some of the controls, has a 'Can Shrink' property.
Experiment with it to see if it behaves as desired.

 

[John Spencer]

try setting the visible property of the control for the picture to match the
flag field's value in the format event of the relevant section. Also turn on
can shrink/can grow for the section. You would have a line of VBA that would
look something like the following (replace generic names with actual control
names).

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.PictureControlName.Visible = Me.PictureFlagName
End Sub


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County