Making Detail Section Not Visible Before Opening 1

[GoatieEddie]

Hi all,

I have a report with several subreports in it.

I want to have a button on a form that allows either the full report to be run or the report with the detail sections hidden (ie just summary data).

I have used this line in a module to effect one of the subreports:

Reports![Accounts Opened Over Period].Section(acDetail).Visible = False

but the report needs to be open in design mode to work.

How can i set it up so the property can be changed without the report being open? Even better, can I do it on the fly in preview mode? Switching to True seems to work but not back to false here.

Many thanks,

GE

 

[RoyVidar]

There's a report forum here (forum703), where such is perhaps more appropriate to address ...

instead of pushing this info (where the report probably need to be in design view), why not pull it? For instance use the on open event of the report or the on format event of the detail section, refer to for instance a checkbox on the form (or a puplic variable...) - here some "air code" demonstrating both approaches ...

[tt]'report open
me.section(acdetail).visible = forms("frmMyForm").contols("chkMyCheck").value

'detail on format
cancel = not forms("frmMyForm").contols("chkMyCheck").value[/tt]

Roy-Vidar

 

[TheAceMan1]

How are ya GoatieEddie . . . . .

In the Declaration Section of a module in the modules window, declare a boolean public variable:

[blue]Public rptDetail As Boolean[/blue]

Next, in the Open event of the report:

[blue]   Me.Detail.Visible = rptDetail[/blue]

Finally, set the variable before opening the report:

[blue]   rptDetail = False
   DoCmd.OpenReport "ReportName"[/blue]

See Ya! . . . . . .

 

[GoatieEddie]

All sounds good and I understand what you are suggesting (pleasant change!) but when I put in the me.detail bit, it bombs out saying it can't find the macro me! I have tried all sorts of permutations and I am now very frustrated!

 

[RoyVidar]

Use the intellisence within the reports on open event - note - TheAceMan1's notations/syntax uses the name of the section (which might be what is bombing here), which can be localized (where I reside, it defaults to Detalj), or altered by the developer. Me.Section(acDetail), as I used in my suggestion, should work regardless of locale and name of the section (but do note my typo, contols in stead of controls)...

Roy-Vidar

 

[GoatieEddie]

Got it to work. Thanks!