Printing Report

C

Colin

Hi,

When a print or print-preview my report no data appears
in the fields.

I had designed a report for 'CashSales' which worked
fine, so I made a copy of it and named it 'Invoices'.

I have created the new tables and forms for
the 'Invoices' but for some reason no data appears in the
report.

Any ideas on how to fix this is greatly appreciated.

Regards

Colin
 
F

Fons Ponsioen

Hi Colin. Usually when I have a report where no data is
showing I first go to the underlying query and make sure I
can see the desired data there.
You did not indicate if you are using a query or table as
the source for your report.
I would make sure that the report is infact sourced from
the table or query you intend, and than check that through
the copying etc the autoupdate did not play tricks with
source data field names for all the text boxes.
If you need more help, provide some more specific
information.
Hope this gets you started.
Fons
 
C

Colin

sorry forgot about that bit,

the data for the report is sourced from two different
tables, one called 'Invoice Customers' which provides
customer name and company name, and one called 'Invoices'
which provides all the other fields.
 
G

Guest

emm. I juts notcied something else,

the layout preview shows the data, but normal preview and
print does not.
 
F

Fons Ponsioen

Colin, I prefer to keep the thread going. That way I do
not need to go to several messages in order to review my
previous thoughts.
Thanks for your reply. So you have as the source of this
report a query consisting of two tables
'Invoice Customers' and 'Invoices'
I assume these are linked by 'CustomerID'?
when in design view, can you open the query, and when
looking at the query in datasheet view, do you see the
data table with data in it?
Fons

Hi Colin. Usually when I have a report where no data is
showing I first go to the underlying query and make sure I
can see the desired data there.
You did not indicate if you are using a query or table as
the source for your report.
I would make sure that the report is infact sourced from
the table or query you intend, and than check that through
the copying etc the autoupdate did not play tricks with
source data field names for all the text boxes.
If you need more help, provide some more specific
information.
Hope this gets you started.
Fons
 
C

Colin

Hi,

thanks for your help,

instead of copying the forms and reportsand trying to
change their data source etc i just started each from
scratch and it seems to be working now thanks
 
Top