simple chart not working

  • Thread starter Thread starter Thomas Spellman
  • Start date Start date
T

Thomas Spellman

I am creating a report to display data consisting of several parameters
collected monthly from 15 sites. I have the report set up to group by site,
showing each month's data as a row, with a page break after each group. I
would like to add a simple line chart to the group footer that displays the
value of one parameter for each month, with no sums or means. Just the
dates of samples on the X axis, and the parameter values on the Y axis,
displaying only the data that was sampled at the current site. I've tried
to do this using the chart wizard, but it always comes out blank if i try to
link the chart to the site. It works OK if I just do a generic chart that
is not linked to the current site value. What do I do to get this to work?
In summary, I have a report based on a query that returns rows with the ID,
site, date, and parameter fields. The report is grouped by site. I need to
chart the parameter values vs their dates for the current site. There will
be one chart per parameter. How do I do this with or without the chart
wizard?

T
 
What are your values in the Link Master/Child properties of the chart
control? I think they should be [Site]. If this doesn't work, come back with
the sql of the Row Source property of the chart control.
 
Hi Duane,

My values in the Link Master/Child properties are both set to "Site" with no
brackets. I tried adding the brackets but that didn't work. When I click
the elipsis "..." button next to either the Link Master or Link Child
properties, I get this error, "Can't build a link between unbound forms."
Both the report and the chart are based on the same query, but the chart
only uses the site, date and one parameter value, whereas the report uses
many more fields. The parameter field is a calculated field using an avg()
function based on a union query, as suggested by you in a previous message.

This is the automatically created Row Source value:

SELECT (Format([Date],"MMM 'YY")),Sum([pH_Mean]) AS [SumOfpH_Mean] FROM
[qTACdata with Calcs] GROUP BY (Year([Date])*12 +
Month([Date])-1),(Format([Date],"MMM 'YY"));

Again, I need to plot ALL the pH_Mean values, show the pH_Mean range on the
Y axis, and Date on the X axis, where Site = the current site of the report
group (report is grouped on Site)

T


Duane Hookom said:
What are your values in the Link Master/Child properties of the chart
control? I think they should be [Site]. If this doesn't work, come back
with the sql of the Row Source property of the chart control.

--
Duane Hookom
MS Access MVP


Thomas Spellman said:
I am creating a report to display data consisting of several parameters
collected monthly from 15 sites. I have the report set up to group by
site, showing each month's data as a row, with a page break after each
group. I would like to add a simple line chart to the group footer that
displays the value of one parameter for each month, with no sums or means.
Just the dates of samples on the X axis, and the parameter values on the Y
axis, displaying only the data that was sampled at the current site. I've
tried to do this using the chart wizard, but it always comes out blank if
i try to link the chart to the site. It works OK if I just do a generic
chart that is not linked to the current site value. What do I do to get
this to work? In summary, I have a report based on a query that returns
rows with the ID, site, date, and parameter fields. The report is grouped
by site. I need to chart the parameter values vs their dates for the
current site. There will be one chart per parameter. How do I do this
with or without the chart wizard?

T
Click to expand...
Click to expand...
 
I don't see Site in your Row Source. Does the section containing the chart
have a control/text box bound to Site?

--
Duane Hookom
MS Access MVP


Thomas Spellman said:
Hi Duane,

My values in the Link Master/Child properties are both set to "Site" with
no brackets. I tried adding the brackets but that didn't work. When I
click the elipsis "..." button next to either the Link Master or Link
Child properties, I get this error, "Can't build a link between unbound
forms." Both the report and the chart are based on the same query, but the
chart only uses the site, date and one parameter value, whereas the report
uses many more fields. The parameter field is a calculated field using an
avg() function based on a union query, as suggested by you in a previous
message.

This is the automatically created Row Source value:

SELECT (Format([Date],"MMM 'YY")),Sum([pH_Mean]) AS [SumOfpH_Mean] FROM
[qTACdata with Calcs] GROUP BY (Year([Date])*12 +
Month([Date])-1),(Format([Date],"MMM 'YY"));

Again, I need to plot ALL the pH_Mean values, show the pH_Mean range on
the Y axis, and Date on the X axis, where Site = the current site of the
report group (report is grouped on Site)

T


Duane Hookom said:
What are your values in the Link Master/Child properties of the chart
control? I think they should be [Site]. If this doesn't work, come back
with the sql of the Row Source property of the chart control.

--
Duane Hookom
MS Access MVP


Thomas Spellman said:
I am creating a report to display data consisting of several parameters
collected monthly from 15 sites. I have the report set up to group by
site, showing each month's data as a row, with a page break after each
group. I would like to add a simple line chart to the group footer that
displays the value of one parameter for each month, with no sums or
means. Just the dates of samples on the X axis, and the parameter values
on the Y axis, displaying only the data that was sampled at the current
site. I've tried to do this using the chart wizard, but it always comes
out blank if i try to link the chart to the site. It works OK if I just
do a generic chart that is not linked to the current site value. What do
I do to get this to work? In summary, I have a report based on a query
that returns rows with the ID, site, date, and parameter fields. The
report is grouped by site. I need to chart the parameter values vs their
dates for the current site. There will be one chart per parameter. How
do I do this with or without the chart wizard?

T
Click to expand...
Click to expand...
Click to expand...
 
Duane,

My group footer does not have a control bound to site. I assumed when the
wizard asked me what field to bind to that I didn't need to add a hack like
that, but that the fields of the table upon which the report is based would
be available to the group footer. So should I add a bound control (bound to
site) to the footer first? The only things I was going to have on the
footer were the charts.

T

Duane Hookom said:
I don't see Site in your Row Source. Does the section containing the chart
have a control/text box bound to Site?

--
Duane Hookom
MS Access MVP


Thomas Spellman said:
Hi Duane,

My values in the Link Master/Child properties are both set to "Site" with
no brackets. I tried adding the brackets but that didn't work. When I
click the elipsis "..." button next to either the Link Master or Link
Child properties, I get this error, "Can't build a link between unbound
forms." Both the report and the chart are based on the same query, but
the chart only uses the site, date and one parameter value, whereas the
report uses many more fields. The parameter field is a calculated field
using an avg() function based on a union query, as suggested by you in a
previous message.

This is the automatically created Row Source value:

SELECT (Format([Date],"MMM 'YY")),Sum([pH_Mean]) AS [SumOfpH_Mean] FROM
[qTACdata with Calcs] GROUP BY (Year([Date])*12 +
Month([Date])-1),(Format([Date],"MMM 'YY"));

Again, I need to plot ALL the pH_Mean values, show the pH_Mean range on
the Y axis, and Date on the X axis, where Site = the current site of the
report group (report is grouped on Site)

T


Duane Hookom said:
What are your values in the Link Master/Child properties of the chart
control? I think they should be [Site]. If this doesn't work, come back
with the sql of the Row Source property of the chart control.

--
Duane Hookom
MS Access MVP


I am creating a report to display data consisting of several parameters
collected monthly from 15 sites. I have the report set up to group by
site, showing each month's data as a row, with a page break after each
group. I would like to add a simple line chart to the group footer that
displays the value of one parameter for each month, with no sums or
means. Just the dates of samples on the X axis, and the parameter values
on the Y axis, displaying only the data that was sampled at the current
site. I've tried to do this using the chart wizard, but it always comes
out blank if i try to link the chart to the site. It works OK if I just
do a generic chart that is not linked to the current site value. What
do I do to get this to work? In summary, I have a report based on a
query that returns rows with the ID, site, date, and parameter fields.
The report is grouped by site. I need to chart the parameter values vs
their dates for the current site. There will be one chart per
parameter. How do I do this with or without the chart wizard?

T
Click to expand...
Click to expand...
Click to expand...
 
Why not add the control and make it invisible to see if it then works?

--
Duane Hookom
MS Access MVP


Thomas Spellman said:
Duane,

My group footer does not have a control bound to site. I assumed when the
wizard asked me what field to bind to that I didn't need to add a hack
like that, but that the fields of the table upon which the report is based
would be available to the group footer. So should I add a bound control
(bound to site) to the footer first? The only things I was going to have
on the footer were the charts.

T

Duane Hookom said:
I don't see Site in your Row Source. Does the section containing the chart
have a control/text box bound to Site?

--
Duane Hookom
MS Access MVP


Thomas Spellman said:
Hi Duane,

My values in the Link Master/Child properties are both set to "Site"
with no brackets. I tried adding the brackets but that didn't work.
When I click the elipsis "..." button next to either the Link Master or
Link Child properties, I get this error, "Can't build a link between
unbound forms." Both the report and the chart are based on the same
query, but the chart only uses the site, date and one parameter value,
whereas the report uses many more fields. The parameter field is a
calculated field using an avg() function based on a union query, as
suggested by you in a previous message.

This is the automatically created Row Source value:

SELECT (Format([Date],"MMM 'YY")),Sum([pH_Mean]) AS [SumOfpH_Mean] FROM
[qTACdata with Calcs] GROUP BY (Year([Date])*12 +
Month([Date])-1),(Format([Date],"MMM 'YY"));

Again, I need to plot ALL the pH_Mean values, show the pH_Mean range on
the Y axis, and Date on the X axis, where Site = the current site of the
report group (report is grouped on Site)

T


What are your values in the Link Master/Child properties of the chart
control? I think they should be [Site]. If this doesn't work, come back
with the sql of the Row Source property of the chart control.

--
Duane Hookom
MS Access MVP


I am creating a report to display data consisting of several parameters
collected monthly from 15 sites. I have the report set up to group by
site, showing each month's data as a row, with a page break after each
group. I would like to add a simple line chart to the group footer
that displays the value of one parameter for each month, with no sums
or means. Just the dates of samples on the X axis, and the parameter
values on the Y axis, displaying only the data that was sampled at the
current site. I've tried to do this using the chart wizard, but it
always comes out blank if i try to link the chart to the site. It
works OK if I just do a generic chart that is not linked to the current
site value. What do I do to get this to work? In summary, I have a
report based on a query that returns rows with the ID, site, date, and
parameter fields. The report is grouped by site. I need to chart the
parameter values vs their dates for the current site. There will be
one chart per parameter. How do I do this with or without the chart
wizard?

T
Click to expand...
Click to expand...
Click to expand...
 
Back
Top