S
safi.sandila
Here is the scenario (using MS Access 2003):
Main Form: is the main form used to update all records with a control
tab and 3 pages where each page has its own sub-forms and all of these
are linked by a common serial number value
Amplitude Test Data: is one of the 4 tables that are used in the
database and has 4 fields: [Test ID], [Serial Number], [Degree], and
[Amplitude]. For each serial number in the main table [General Data],
there are 36 entries in this table with [Test ID] as the primary key,
and with [Degree] ranging from 0-350 in increments of 10 (kind of like
the degrees in a circle) and the corresponding [Amplitude] value for
each [Degree]
Amplitude Data Chart: is one of the aforementioned subforms on a page
within [Main Form]. This is actually a pivotchart that is only supposed
to display (no data entry) a plot of [Degree] and [Amplitude] from
[Amplitude Test Data] in a radar chart form much like a circle
Main Report: is the main report that shows relevant data per serial
number that is initally entered through [Main Form] on one page. It is
also supposed to display the same [Amplitude Data Chart] subform that
is displayed in [Main Form] as a subform to display the radar chart for
each serial number
This is the problem:
Basically, while [Amplitude Data Chart] will open up fine for each
serial number in [Main Form], it only shows up for the first shown
record in [Main Report] in both preview and print modes. For all
subsequent records, the chart object is entirely missing from the
report. I have tried to make copies of [Amplitude Data Chart] and
insert it in the report, I have tried to make a sub-report similar to
the chart itself, but haven't been able to even come close to
reproducing the same results as the original pivot chart, I have even
created separate reports with just the serial number as their only
field and inserted the chart there with the proper master/child linking
and am still unable to have the report show the any chart for each
serial number after the first one that is displayed.
I am at a loss as to which direction I should proceed in now and would
appreciate any help I can get. I hope I was clear enough in my
explanation and if anyone needs any more clarifications, please do let
me know.
Safi Sandila.
Main Form: is the main form used to update all records with a control
tab and 3 pages where each page has its own sub-forms and all of these
are linked by a common serial number value
Amplitude Test Data: is one of the 4 tables that are used in the
database and has 4 fields: [Test ID], [Serial Number], [Degree], and
[Amplitude]. For each serial number in the main table [General Data],
there are 36 entries in this table with [Test ID] as the primary key,
and with [Degree] ranging from 0-350 in increments of 10 (kind of like
the degrees in a circle) and the corresponding [Amplitude] value for
each [Degree]
Amplitude Data Chart: is one of the aforementioned subforms on a page
within [Main Form]. This is actually a pivotchart that is only supposed
to display (no data entry) a plot of [Degree] and [Amplitude] from
[Amplitude Test Data] in a radar chart form much like a circle
Main Report: is the main report that shows relevant data per serial
number that is initally entered through [Main Form] on one page. It is
also supposed to display the same [Amplitude Data Chart] subform that
is displayed in [Main Form] as a subform to display the radar chart for
each serial number
This is the problem:
Basically, while [Amplitude Data Chart] will open up fine for each
serial number in [Main Form], it only shows up for the first shown
record in [Main Report] in both preview and print modes. For all
subsequent records, the chart object is entirely missing from the
report. I have tried to make copies of [Amplitude Data Chart] and
insert it in the report, I have tried to make a sub-report similar to
the chart itself, but haven't been able to even come close to
reproducing the same results as the original pivot chart, I have even
created separate reports with just the serial number as their only
field and inserted the chart there with the proper master/child linking
and am still unable to have the report show the any chart for each
serial number after the first one that is displayed.
I am at a loss as to which direction I should proceed in now and would
appreciate any help I can get. I hope I was clear enough in my
explanation and if anyone needs any more clarifications, please do let
me know.
Safi Sandila.