First thing is to change the subreport into a second dataset in the report.
You don't need a subreport for multiple queries. You could put the field in
a table footer, First(Fields!Dislaimer.Value, "Dataset2") and set the footer
to repeat on new pages.

The best place to post these types of questions is in the
microsoft.public.sqlserver.reportingsvcs newsgroup.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

"Stu" <s.dee (AT) cognatus (DOT) com> wrote

from the database. Also the sub report is in the footer.

Hi Brian,

I have tried that
And when i drag the field into the footer and compile it
says
the value for the textbox 'text_1' refers to a field. Fields cannot be
used int headers or footers

Stu



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Could you move this over to the reporting services newsgroup? There are more
people over there who can answer Reporting Services questions than this
group.

You actually can't put a field directly in the page footer. You can put it
in the body and then put a reference to it in the footer, e.g.
ReportItems!Textbox.Value.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

The Microsoft legal department would like me to remind you that this posting
is provided "AS IS" with no warranties, and confers no rights.

"stuart Dee" <s.dee (AT) cognatus (DOT) com> wrote