Fields in page header... -- sql server reporting services

Pradeep
4/3/2006 6:00:05 PM

Hello,

In my sales quotation report, I need to display the name of the
customer on every page of the report. The customer name is passed as a
data source. However, Reporting Services does not let you apply
dataset fields in a page header.

[quoted text, click to view]
are facing. A workaround that was suggested is to declare a hidden
textbox on the page and use an expression in the page header that
points to ReportItems!textboxnn.Value.

Although this works, it only works only for one page. In our case, the
sales quotation table spans multiple pages. Depending upon whether the
hidden textbox is placed before the table or after the table, either
the first page or the last page shows the customer name.

Can someone please enlighten me on what tricks can we possibly play to
get the customer name show up on every page header?

Thank you in advance for your help.

Pradeep

vinodsh_82 NO[at]SPAM hotmail.com
4/4/2006 1:26:48 AM

try this..
You can add new parameter and assign the corresponding field to the new
parameter. then use the parameter in page header or footer.

[quoted text, click to view]

jenr
4/4/2006 5:34:24 AM

are you repeating your table header on multiple pages? if so, try
putting the customer name in the table header.

jenr

[quoted text, click to view]

Pradeep
4/4/2006 11:53:53 AM

Thank you, Vinod. I will try it out.

Pradeep
4/4/2006 11:56:57 AM

Jenr,

Thank you for your help. This technique works. However, it appears you
cannot insert multiple text boxes in a table header column. The new
text box replaces the old one. The old one is supposed to show the
column name.

For now, I am adding a new column to the table but I will make the
width of this column 0.

If anyone has a better suggestion, I would appreciate it.

Thank you in advance.

Pradeep

Pradeep
4/5/2006 1:29:48 AM

Okay. Fields as well as report items cannot be used in parameters.

Any other suggestions?

Pradeep

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Fields in page header...