parameters in header and footer

why data cannot be shown using (a field parameter and table field) in page header and footer?

thanks

-Ron-

You can show the parameter value in the page header and footer, just not any data from your dataset.

Jarret

|||

There is a work around if the data retrieved from the record is a single returned row, or filtered to only have a single row.

Example: Select Field1 from table where field2 = value <--Returns a single row

1. Create a parameter which reads this dataset and set the returned value of the query equal to the Default for the parameter.

2. The single field is now stored in the parameter and can appear within the Header/Footer.

If you need to return more than one row (such as a table) in your header, haven't tried it and have no suggestions..

Hope it helps