G
GaryDennis
Have a report with a sub report. Both have the field "office name." When data
exists for office listed on the main report, but not for the same office on
the sub report, the office name still shows up in the "office name" field of
the sub report. I am trying to figure out how to prevent the name of the
office from appearing on the sub report when it has no corresponding data. Is
there a module to write that would work for that?
Backround: Data is input into a form and sub form to feed their respective
tables. The common field for the main and sub is "office name" and the
office name field on the sub form is bound to the office name field on the
main form. I have not figured out how to make it work when unbound and
suspect the problem may be here and not the report?
The two tables are placed into one query with an outer join using the
"office name" field as the related field.
Any ideas or suggestions are appreciated.
Thank you
exists for office listed on the main report, but not for the same office on
the sub report, the office name still shows up in the "office name" field of
the sub report. I am trying to figure out how to prevent the name of the
office from appearing on the sub report when it has no corresponding data. Is
there a module to write that would work for that?
Backround: Data is input into a form and sub form to feed their respective
tables. The common field for the main and sub is "office name" and the
office name field on the sub form is bound to the office name field on the
main form. I have not figured out how to make it work when unbound and
suspect the problem may be here and not the report?
The two tables are placed into one query with an outer join using the
"office name" field as the related field.
Any ideas or suggestions are appreciated.
Thank you