Need to display data fields in report header

• Vandy

  SSCommitted

  Points: 1827

  More actions

  March 14, 2007 at 11:23 am

  #176521

  Hi All

   

  I want to display customer address in header. I have table for that and made a dataset  but i am not able to place data fields in header

  Any help please

   

  Thanks

   

• Jamey Livingston

  SSC Journeyman

  Points: 92

  More actions

  March 14, 2007 at 11:57 am

  #695033

  Unfortunately you cannot display field data in the header.  There is a blog somewhere explaining this in more detail, but dont loose hope!  What you might want to try instead is, depending on the control you are using (List, Table, Matrix) make a pseudo-header area within the control.  I find the List Control to be the most forgiving and gives you some options on controling which page has what data.  So create a List Control, and great groupings for each bit of header data you want to include.  You can then insert another control like a Table control in the List control and you should be able move areas around in the controls to come up with something that approximates the behavior of a header but contains data elements.

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  March 14, 2007 at 6:10 pm

  #695116

  Another tricky solution is to use some fields/cells in your table. Basically what you do is...

  1. Using an unused cell in your table

  1. Set it's color to White
  2. Set the canGrow to FALSE
  3. assign the data field as it's value
  4. name it something inteligable like "txtHeader1"

• Now in the header

1. Set the value of the text box to "=ReportItems!txtHeader1.value"

This will work as long as the unused cell in step 1 is repeated on each page.

 

Make sense?

 

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg