Hide Sub Report(s) when records are null
in [Reports]
|
From: Bruce on 23 May 2010 22:37 I am running Access 2007 sp2 MSO. I have a report that has three (3) sub reports. There are times when not all three sub reports have values to display. Is there a way to code the given report to not be visible if there are no records to report? The second part of this question would be if there is a way to make the report invisible is it also possible to code so that the space where the report would normally reside would not be taken with a blank space (the foot print of where the report normally resides)? -- Bruce
From: Allen Browne on 23 May 2010 23:14 Part 1: If the main report is bound to a table/query, you can just cancel its NoData event. If the main report is unbound (merely a holder for the 3 subreports), you would need to write some code in the Open event of the report to DLookup() the 3 source queries for the 3 subreports to see if you get anything. If you don't, then cancel Report_Open. Part 2: Set the CanShrink property to Yes for the subreport control, and also for the section that holds the subreport. Provided there is nothing else overlapping the subreport's vertical space, it will then shrink if it has no data. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Bruce" <Bruce(a)discussions.microsoft.com> wrote in message news:EBE4F1FD-1366-486C-A4A5-EAE30095B0A8(a)microsoft.com... > I am running Access 2007 sp2 MSO. I have a report that has three (3) sub > reports. There are times when not all three sub reports have values to > display. Is there a way to code the given report to not be visible if > there > are no records to report? The second part of this question would be if > there > is a way to make the report invisible is it also possible to code so that > the > space where the report would normally reside would not be taken with a > blank > space (the foot print of where the report normally resides)? > -- > Bruce
From: John Spencer on 24 May 2010 08:58 You can use the HasData property of the sub-reports to control the visibility of the sub-report control. In addition, you can set the can shrink property of the section containing the sub-report control(s) to yes to recover the space. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Allen Browne wrote: > Part 1: > If the main report is bound to a table/query, you can just cancel its > NoData event. > > If the main report is unbound (merely a holder for the 3 subreports), > you would need to write some code in the Open event of the report to > DLookup() the 3 source queries for the 3 subreports to see if you get > anything. If you don't, then cancel Report_Open. > > Part 2: > Set the CanShrink property to Yes for the subreport control, and also > for the section that holds the subreport. > > Provided there is nothing else overlapping the subreport's vertical > space, it will then shrink if it has no data. >
From: Bruce on 24 May 2010 10:09 John, I cannot locate where I would use the HasData property of the sub-report. I am aware of the can shrink property and have that set to yes (also have the can grow property set to yes). I have looked at each line in the properties window but cannot locate where I set the HasData property. In fact I typed in HasData into the help menu and there were no results found. Could you please give me a little more assistance? -- Bruce "John Spencer" wrote: > You can use the HasData property of the sub-reports to control the visibility > of the sub-report control. In addition, you can set the can shrink property > of the section containing the sub-report control(s) to yes to recover the space. > > John Spencer > Access MVP 2002-2005, 2007-2010 > The Hilltop Institute > University of Maryland Baltimore County > > Allen Browne wrote: > > Part 1: > > If the main report is bound to a table/query, you can just cancel its > > NoData event. > > > > If the main report is unbound (merely a holder for the 3 subreports), > > you would need to write some code in the Open event of the report to > > DLookup() the 3 source queries for the 3 subreports to see if you get > > anything. If you don't, then cancel Report_Open. > > > > Part 2: > > Set the CanShrink property to Yes for the subreport control, and also > > for the section that holds the subreport. > > > > Provided there is nothing else overlapping the subreport's vertical > > space, it will then shrink if it has no data. > > > . >
From: Bruce on 24 May 2010 10:11 Allen, The main report is bound to a query. In fact the three (3) other sub-reports are bound to the same query. I have the sub-report can shrink set to yes for both the space it occupies and the report itself. -- Bruce "Allen Browne" wrote: > Part 1: > If the main report is bound to a table/query, you can just cancel its NoData > event. > > If the main report is unbound (merely a holder for the 3 subreports), you > would need to write some code in the Open event of the report to DLookup() > the 3 source queries for the 3 subreports to see if you get anything. If you > don't, then cancel Report_Open. > > Part 2: > Set the CanShrink property to Yes for the subreport control, and also for > the section that holds the subreport. > > Provided there is nothing else overlapping the subreport's vertical space, > it will then shrink if it has no data. > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > > "Bruce" <Bruce(a)discussions.microsoft.com> wrote in message > news:EBE4F1FD-1366-486C-A4A5-EAE30095B0A8(a)microsoft.com... > > I am running Access 2007 sp2 MSO. I have a report that has three (3) sub > > reports. There are times when not all three sub reports have values to > > display. Is there a way to code the given report to not be visible if > > there > > are no records to report? The second part of this question would be if > > there > > is a way to make the report invisible is it also possible to code so that > > the > > space where the report would normally reside would not be taken with a > > blank > > space (the foot print of where the report normally resides)? > > -- > > Bruce > > . >
|
Next
|
Last
Pages: 1 2 Prev: Grouped/Sorted Report by Month Next: Hide Sub Report(s) when records are null |