Rendering problems with MSRS 2005

[Peager]

I am relatively new to MSRS and have a problem that's causing me to pull my hair.

I created an invoice report. In the page header, I have placed the logo and some text boxes, some of which are populated by expressions like the following formula.

 ReportItem("TableFieldObjectName").Value

The reference points to a cell named "TableFieldObjectName" in a hidden table header line in the table holding the invoice detail lines. The cell in the hidden header line is set to a formula field in the report data set with an expression like this:

 ="Invoice No" & Chr(10) & Fields!Inv_No.Value & "REV"

When viewing the report in preview, it works perfectly. When I try to render it into a PDF and then view the PDF, the fields are blank. Ditto if I direct it to a printer.

If I render the report as a Web Archive, all of the line feeds in the formatted text boxes disappear but the data does appear, it's just ugly due to being wrapped.

I have played around with page sizes and the like to no avail. There are text boxes above the ones I'm having problems with in the header that are rendering fine.

Anybody seen anything like this and know what the problem is?

Best regards,

Paul

 

[Peager]

Solution Found.... The problem was that the referenced item in the table header was in a hidden row. When it was moved to a group header or footer and only the cell hidden, rendering worked fine. Looks like one of those nasty 'gotchas'.

Paul