Re: Calculated Field In Report

<<

Is this normal behavior?


Yes, this "can" be normal behaviour if the strucure of the table has changed
after the report was created.


--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"Willard Hoppe" <billh@xxxxxxxxxxxxxxx> skrev i meddelandet
news:47d6fa72$1@xxxxxxxxxxxxxxxxxxxxxxxxxxx

I use Paradox 7.

I have a calculated field in a report as follows:
[INCENTVE.City] + ", " + [INCENTVE.State] + " " + [INCENTVE.Zip]

Obviously the data is drawn from the

CITY
STATE
ZIP
fields in my database.

However, if the fields are not in the exact same order as when I made the
report, there are issues.

For example, if the fields are in the following order in the table

CITY
ZIP
STATE

The report will print:

TRENTON 08648 NJ


Is this normal behavior?

Thanks in advance!




.

Relevant Pages

  • Re: Calculated Field In Report
    ... Paradox Support & Sales ... Diamond Sports Gems ... I've used this report and table unchanged for years, ... Is this normal behavior? ...
    (comp.databases.paradox)
  • Re: Calculated Field In Report
    ... If you change the field order in a table then you can mess up reports as they generally bind to the field NUMBER not its name. ... So you have to open the report in design, and at least resave it after changing field order. ... Is this normal behavior? ... Bertil Isberg - CTECH ...
    (comp.databases.paradox)
  • Re: Calculated Field In Report
    ... I've used this report and table unchanged for years, ... Is this normal behavior? ... Bertil Isberg - CTECH ... online: http://hem.bredband.net/bertilisberg/ ...
    (comp.databases.paradox)
  • Re: My form shows up blank in print preview?
    ... That is the normal behavior when you try to print a form without data. ... Save the form as a report. ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ...
    (microsoft.public.access.forms)