page footer and detail section

  • i would like to assign the value from detail textbox to a textbox in page footer.

    in the detail section i have a textbox with firstname

    in the page footer i would like to use the name for prepared by:

    i am not able to do table in page footer.

    could anybody let me know how to do it?

  • Once you have the value available in the main report body, you should then be able to refer to it in the footer by using the expression such as:

    =ReportItems!FirstName.Value

    This of course assumes that you have named your text box in the main body as FirstName rather than TextBox1 which would be the default.

    If you don't actually want the first name to be printed in the main body, just mark it as hidden.

    Good luck,

    Nigel West
    UK

  • Thank you. it worked.

    is there anyway i can directly use the dataset field value to page footer.

  • No, for some reason unknown to me, they don't allow this.

    Go figure......

    Nigel West
    UK

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply