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

Parameters and Formulas in a group field

I have a formula in my group footer that I need to pass to a paramter. The formula doesn't come up in my select expert box? When I try to manually add it, it gives me this error
"This formula cannot be used because it must be evaluated later"

my formula is a account balance formula and I have a parameter that I want to choose where the balance is greater than ".01"

How can I get this accomplished?So you want to use the result of the group footer formula in the record selection formula?
What is your formula? You might be able to use the group selection formula instead.
e.g. if you're grouping on account and summing a value field your group selection formula could be something like
sum({value}, {account}) > 0
which will only return accounts whose 'balance' is > 0