V
vpweiss
I really need help on two problems and I would appreciate
any help I can get including telling where to go if this
isn't the proper newsgroup to post this in:
1) I have this stealth field that won't work in a report.
There is a Table called Invoice, which has 18 fields of
various types. One of them is a text field called "Paid"
and when you look at the table view or do SQL lookup, it
functions normally. It typically contains either "YES"
or "NO". When I go to actually create a report that prints
the invoices, however, all the fields (such as "Invoice
date",etc, work fine, but not Paid. It won't show up, not
for filtering purposes, and not as data object in the
report. We don't want to print invoices that are paid, we
only want to print unpaid invoices. So we want to filter
on Paid, but it doesn't show up in the field lists and
if you enter it in the Expression Builder when you run the
report it says it doesn't recognize "Paid." I tried to
simply have Paid displayed in the report. The
field "Invoice date" shows up just fine. But when you go
to Properties and go to Control Source and check the list
of fields, Paid is not among them. If you click on the
ellipse (...) to go to the Expression Builder and select
<Field List> Paid is not there. If you type in Paid it
accepts it but when you run the report it asks for a
parameter value for Paid. If you go into the Expression
Builder for the report field, select Tables, then select
Invoice, "Paid" shows up and you can select it, which
gives you "[Invoice]![Paid]", but then when you want to
view the report it asks for the parameter value.
2) How do we call a User Defined Function from a report
field? I've tried several things from books and from the
internet but it always asks for the parameter value. I can
type the function name or select it in the Expression
Builder, either way its not recognized.Specifically, we're
trying to use one of several functions to convert the
invoice amount to English words. We found instructions for
doing it in a data access page, but it doesn't seem to
work in a report...
any help I can get including telling where to go if this
isn't the proper newsgroup to post this in:
1) I have this stealth field that won't work in a report.
There is a Table called Invoice, which has 18 fields of
various types. One of them is a text field called "Paid"
and when you look at the table view or do SQL lookup, it
functions normally. It typically contains either "YES"
or "NO". When I go to actually create a report that prints
the invoices, however, all the fields (such as "Invoice
date",etc, work fine, but not Paid. It won't show up, not
for filtering purposes, and not as data object in the
report. We don't want to print invoices that are paid, we
only want to print unpaid invoices. So we want to filter
on Paid, but it doesn't show up in the field lists and
if you enter it in the Expression Builder when you run the
report it says it doesn't recognize "Paid." I tried to
simply have Paid displayed in the report. The
field "Invoice date" shows up just fine. But when you go
to Properties and go to Control Source and check the list
of fields, Paid is not among them. If you click on the
ellipse (...) to go to the Expression Builder and select
<Field List> Paid is not there. If you type in Paid it
accepts it but when you run the report it asks for a
parameter value for Paid. If you go into the Expression
Builder for the report field, select Tables, then select
Invoice, "Paid" shows up and you can select it, which
gives you "[Invoice]![Paid]", but then when you want to
view the report it asks for the parameter value.
2) How do we call a User Defined Function from a report
field? I've tried several things from books and from the
internet but it always asks for the parameter value. I can
type the function name or select it in the Expression
Builder, either way its not recognized.Specifically, we're
trying to use one of several functions to convert the
invoice amount to English words. We found instructions for
doing it in a data access page, but it doesn't seem to
work in a report...