Fields in query vs sub-report

[Guest]

Hi

I have a number of different invoices (reports) which all have debtor
address details on them at the top.

I'd like to know if it is more efficient to include the debtor address
fields in the underlying record source query or to have all these fields in
one sub-report linked to each invoice?

Thanks in advance for your advice.

Winsa

 

[Allen Browne]

It is generally simpler and more efficient to use a single report and a
single query than to use a subreport which has to be loaded for each record
that calls it.

 

[Guest]

Thanks Allen. My theory was that if I had to make any changes to the debtor
address fields, that I can do it in one location rather than to have to
change a number of different invoices, but database performance will have to
come first!

Thanks again
Winsa

 

[Allen Browne]

Winsa, I'm not sure I have understood your question correctly.

You will have a Client table, with the names and addresses of your clients.

You will have an Invoice table, such that one client can have many invoices.
(There will also be an InvoiceDetail table, for the line items of the
invoice.)

The report will rely on a query that contains all three tables. Since the
address is being read from the Client table, there is only one place where
it needs to be changed.

 

[Guest]

Hi Allen

Sorry for my delayed reply, I never got a notification that you replied to
my post.

Yes, I do have separate Client and Invoice tables. The changes I was
referring to were not to the actual data, but to the formatting of the
address details on the invoices, ie. the way the address is displayed on each
invoice. I thought having all the address fields in one sub-report would be
easier if I needed to tweak the textbox size or font, but that doesn't
matter. I don't envisage I will have to do this much, but was just thinking
ahead.

Sorry for the confusion!
Winsa