none
Suppress Header Text Box on Project Footer RRS feed

  • Question

  • I have a report that displays hours worked by staff by week by project.  The detail section displays the hour count, the Week footer adds all values for a sub total.   The Project footer has a summary sub report that displays each week’s total and gives a grand total at the end.  This would be the project total of the reporting period.

    I use the page header to display the project name and the week dates, beginning and end. The Report Footer can suppress the header which I have done for the overall group of projects making up this effort.

    I have successfully used the .Page attribute to format the box to white for every 5th page.  (The report displays the past four weeks of effort)  Provided the number of staff working on a project is not greater than one page, this is a work around until a proper solution is found. 

    I would like to either conditionally format this date Text Box to be white during the Project footer so the dates are not displayed, or make the text box invisible during this footer. This is a cosmetic issue because the sub report displays the week ending dates in summary.


    • Edited by ClayInHou Monday, December 28, 2015 3:22 PM
    Monday, December 28, 2015 3:21 PM

All replies

  • While I follow the jist of what you seek - I don't quite get the detail....but perhaps this will help: in a section's OnFormat event one can control visibility of fields based on value of the fields.

    I believe this might give you what you seek.  It must be the field value from the record source rather than a calculated value occurring in the report object itself.

    Monday, December 28, 2015 10:21 PM
  • To determine the page was at a level break, the change of project number, one would have to test the current project number against the previous number. If it is unequal then make the visibility of the field = False.

    How would one do that test during the OnFormat event?

    Tuesday, December 29, 2015 4:25 PM
  • Not sure what is meant by "unequal" - but - my prior advice in general would not be a method to manage page breaks....although definitely can control visibility based on the value of a control.

    In regard to page breaks: One of course has the page break control, and then one also uses the features/options in Grouping & Sorting.

    That is all I rely upon and I can commiserate that any attempt to design exact page layout when the content volume varies is quite difficult to achieve.... one can sometimes expand the page footer vertical size to force an auto break......

    Tuesday, December 29, 2015 10:23 PM
  • My report groups on Project Number. I have a Project number footer containing a summary report of the previous weeks.  I force a page before this section break.  I wish to suppress that page header date text from the previous week in the page header of the project footer group .  

    I have an image of what I need but I am not verified yet so I cannot include it. 

    Wednesday, December 30, 2015 12:24 PM
  • Hi ClayInHou,

    Please share the image on the OneDrive, then post the link here.

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, January 1, 2016 2:53 AM
    Moderator
  • Hi ClayInHou,

    For image, you could refer the method from Starain.

    It would be helpful if you could share us your details steps.

    For a general suggestion, I suggest you try event in PageHeaderSection.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Monday, January 4, 2016 5:26 AM
  • Monday, January 4, 2016 12:26 PM
  • Hi ClayInHou,

    Did you mean you want to set the visible property of data range in different pages according different situation? If so, I am afraid it is impossible. Once we set the visible for the control in one page, this control in all pages would be formatted. You could only set it visible or not for all the report pages. If you want to remove it for all pages, you could remove it at design time.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Tuesday, January 5, 2016 8:01 AM
  • You can accomplish this using subreports:

    Subreport 1:  Your detail information and your page header date range information.

    Subreport 2:  Your Project summary information (without the page header)

    - Place both subreports in the DETAIL section of the main report, using Project as the Master-Child link. 

    - Place a page break control between the two subreports (this will make your summary info appear on its own page).

    You'll note that Page Headers in subreports don't actually print, but you can accomplish the same results by creating a "Fake" group header in Subreport 1:

    - Add a grouping level to your subreport.  At the very bottom of the popup from which you select fields to group on, click "Expression" rather than selecting a field.

    - Use  = 1 as the expression (include the = sign).  This is arbitrary.  It can be = "Dummy Header" or anything else.

    - Set the Repeat Section property of your fake group header to "Yes".    This will force the group header to repeat for each page of the subreport, essentially making it a Page Header for your subreport.

    These steps overall will give you a Page Header for one subreport (the details), but not the other (the project summary info) and not the main report... and if you tweak/customize the idea, you *should* be able to get the overall results you're looking for.


    Miriam Bizup Access MVP


    Tuesday, January 5, 2016 1:31 PM
  • Thank you very much for this. I would not have thought of putting a subreport in the Detail Section.  I'll work on this. 

    All my best,

    Clay

    Tuesday, January 5, 2016 7:01 PM