Headers In Multiple Column Reports - And Hiding On No data
in [Help]
|
From: divventknaa on 18 Jul 2010 19:08 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 ------------------- ----- ---- -- -
From: Marshall Barton on 18 Jul 2010 20:52 divventknaa wrote: >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. 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
From: divventknaa on 19 Jul 2010 13:27 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 ------------------- ----- ---- -- -
|
Pages: 1 Prev: Way pdf file not will stay permanent open Next: Hiding Headers In Multiple Column Reports |