Access07 report requiring all fields of the record source?

Access07 designed new report using wizard

selected just the fields needed for report

but the report opened up with a parameter prompt for a field in the
underlying query but not on the report.....

so I put it on the report, made it not visible....and now when I open the
report there is another parameter prompt for another field not on the
report....

what gives?

When you run the query itself, do you get prompted for the parameters? If
so, you will be prompted for the same parameters when you run the report,
regardless of whether these fields are on the report or not.

If the query runs without asking for these parameters, you've been caught by
the report optimizer. It tries to be too clever: if it doesn't see a control
bound to the field, it may not fetch it. But if the field is needed for an
expression somewhere, then it handles the unfetched field by popping up the
parameter box.

The problem expression may not be in an obvious place: e.g. it could be in
the report's Filter or OrderBy properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"GBA" wrote in message
...
Access07 designed new report using wizard

selected just the fields needed for report

but the report opened up with a parameter prompt for a field in the
underlying query but not on the report.....

so I put it on the report, made it not visible....and now when I open the
report there is another parameter prompt for another field not on the
report....

what gives?

no prompt in underlying query; which is what makes this so frustrating.

have never heard of 'report optimizer'...will take a look around and let you
know....



"Allen Browne" wrote:

When you run the query itself, do you get prompted for the parameters? If
so, you will be prompted for the same parameters when you run the report,
regardless of whether these fields are on the report or not.

If the query runs without asking for these parameters, you've been caught by
the report optimizer. It tries to be too clever: if it doesn't see a control
bound to the field, it may not fetch it. But if the field is needed for an
expression somewhere, then it handles the unfetched field by popping up the
parameter box.

The problem expression may not be in an obvious place: e.g. it could be in
the report's Filter or OrderBy properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"GBA" wrote in message
...
Access07 designed new report using wizard

selected just the fields needed for report

but the report opened up with a parameter prompt for a field in the
underlying query but not on the report.....

so I put it on the report, made it not visible....and now when I open the
report there is another parameter prompt for another field not on the
report....

what gives?

you nailed it

there was an expression in both the filter and orderby ; both containing
the parameter prompt's field...

boy - that is a no fun feature flaw..... thanks much for the assist...



"Allen Browne" wrote:

When you run the query itself, do you get prompted for the parameters? If
so, you will be prompted for the same parameters when you run the report,
regardless of whether these fields are on the report or not.

If the query runs without asking for these parameters, you've been caught by
the report optimizer. It tries to be too clever: if it doesn't see a control
bound to the field, it may not fetch it. But if the field is needed for an
expression somewhere, then it handles the unfetched field by popping up the
parameter box.

The problem expression may not be in an obvious place: e.g. it could be in
the report's Filter or OrderBy properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"GBA" wrote in message
...
Access07 designed new report using wizard

selected just the fields needed for report

but the report opened up with a parameter prompt for a field in the
underlying query but not on the report.....

so I put it on the report, made it not visible....and now when I open the
report there is another parameter prompt for another field not on the
report....

what gives?