I have created a scope of work report which uses 4 sub reports to display reference numbers for
defects, change requests etc. in multiple columns.

This works fine, but as I am using colours to highlight where the items lie, I need to put in a
reference so the user can see which colours signifies what.

The obvious way would be to put the header (which is a title then 4 - 8 labels underneath for the
legend) into the subreport header, then using the On No Data method, hide the lot if a report is
empty, which some sub reports will be for particular SystemID.

However, if the header is put inside the subreport header, it obviously moves the page to the right
to fit it in, which prevents the columns being displayed 6 across the page, which is the desired
method as it will enable me to get a plan-on-a-page approach

I realise I could use the visible method to make the titles and colored labels invisible using the
OnNoData interrogations, but this would leave empty spaces down the page, when the neatest way to
do it would be to just hide that report, and the other subreports would automatically fill the
space. I woul then have a normally hidden text box to say "No Defects Associsted With SystemXXX"
where the subreport would normally sit.

Any boffins got a fix for this please?

Thanks

J



--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

divventknaa wrote:

I don't follow your logic. This whole svenario should be
really simple.

If you uncheck the Same as Detail box in File - Page Setup -
Columns, you can make the subreport's design Width as wide
as the containing subreport control. Then your title and
color references can be in the subreport without any code or
the main report even being aware of it.

A subreport with no data will not display anything, not even
it's header, so there is no concern or any code needed to
deal with the no data situation for the header.

The code in the main report to show/hide the "no defects"
label would look like:
Me.label.Visible = Not Me.subreportcontrol.Report.HasData

--
Marsh

Marshall, I read your reply via the net on the developers forum (didnt know it interrogates this
newsgroup) and as you say it is quite simple, using the dont associate with detail. Again, I have
never used the basic formatting of reports using page setup, as previous stuff I have done I have
used code to resolve issues, and never really looked at the report format.

A lesson learned... And incrporated within 10 minutes of seeing your reply. One slight curiousity
was that although all 4 sub reports are identical, just display different query fields in the
Detail, one would not let me display the header in the Report Header Section, but all 3 others did,
and all formatting, Page Layout etc. options were the same. I copied and renamed over another
subreport, changed the underlying query and it was fine, but strange glitch.

I also like the using the has data as a yes/no for setting visibility, again, I traditionally used
the event from within the report, but this is a much neater method.

Thanks

JB

Apologies if double posted but Newsleecher sometimes tells me failed, and hasn't


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -