By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,497 Members | 2,127 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,497 IT Pros & Developers. It's quick & easy.

Data in Reports - Where is it coming from?

P: n/a
I have a database I'm working with which has tables and reports. The
controls in the reports are bound to data, but I'm at a loss to explain
where the data is coming from. I have gone so far as to delete the tables of
data, yet the reports are unchanged and show the same data as always.

Anyone know what's going on, and how I can get to the underlying data to
delete some of it?

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Queen's" <sa**@post.queensu.ca> wrote in message
news:c5**********@knot.queensu.ca...
I have a database I'm working with which has tables and reports. The
controls in the reports are bound to data, but I'm at a loss to explain
where the data is coming from. I have gone so far as to delete the tables of data, yet the reports are unchanged and show the same data as always.

Anyone know what's going on, and how I can get to the underlying data to
delete some of it?


What is in the Report's RecordSource property? You should be able to
examine that to see where it is getting it's data. It will either have the
name of a table or query or a SQL statement which you would have to examine
to see what tables and/or queries it is using.

If the RecordSource is blank then you have an unbound report which means
the controls themselves would either have to be unbound or at least bound
to functions that have a way to pull data from some other source. Any
unbound controls could also be getting populated in code running the
report's module. Actually, the report itself could have a blank
RecordSource property and then have a RecordSource applied in the report's
open event.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.