Printing Report

  • Thread starter Thread starter Colin
  • Start date Start date
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
 
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
 
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.
 
emm. I juts notcied something else,

the layout preview shows the data, but normal preview and
print does not.
 
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
 
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
 
Back
Top