"Enter Parameter Value" At Report Run Time?

[JeffGeorge]

This message is occurring when I try to run a report I am designing. The report format is as follows:



Field A, Field B, Field C, Field D

Field X = B+C+D

Field Y = A-X

When I run the report I get the Enter Parameter Value box referencing Field X. If I hit OK on this box the report displays with the correct value in Field X but no value in Field Y. Is it not possible to calculate fields based on other calculations at run time?

[Dal Jeanis]

1) It's probably the calculation for Y that is kicking up the "What's an X" question.
2) You should be able to bypass the whole question by first putting the calculations into the query.
3) Worst case scenario, workaround is Y = A - B - C - D

[JeffGeorge]

I was afraid it was the calculations based on calculations that were throwing it off. It's time for some workarounds where possible. This is giving me a headache. This is some very non-user friendly source data I'm working with.

[Dal Jeanis]

I don't generally do calculations in the report itself, although I'm sure there are many applications where it's necessary and valuable. In this case, the workaround is to let the computer do the calculation from the fields it already had... which will work, as long as the rounding gremlin doesn't get you.

[JeffGeorge]

With the lack of data currently available to the users of the software I'm working with they'll be happy if the least of their problems are rounding errors! Hell, even if the rounding creates a 10% variance they'll be ecstatic!

[Dal Jeanis]

(1) Know your application (2) Know your data (3) Know your users.

Sounds like you're golden.