Subreport to delimit chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NeoFax - 12 Mar 2008 19:38 GMT

I have a chart report that I would like to use as a subreport.
Currently it shows all of the data in the chart. What I want is to
have the chart delimited based on link child and link master.
However, it is not working. I have set the link for the chart itself
and it asks for the criteria everytime I open the report like 20
times. So, I deleted the link criteria and tried setting it in the
main report to no avail. The subreport wizard doesn't help as it
never offers the ability to link the reports.

Reply to this Message

Evi - 12 Mar 2008 20:25 GMT

So long as the chart's data source and the main report have a field in
common (and if it isn't a parameter query field) then you should just be
able to put the same field name into the Link Master/LinkChild section in
the Property box.
You may find that your chart's field names aren't exactly what you think
they are. They are usually based on a crosstab so if you were planning to
link by a Column Heading, you will see, instead of eg WorkYear that your
'fields' are called 2007, 2008, 2009. Click on the chart in design view,
click on Properties and next to Row Source and run the query which appears.
If you need to, you can add fields to the Row Headings in this query's
Design View.
Evi

> I have a chart report that I would like to use as a subreport.
> Currently it shows all of the data in the chart. What I want is to
[quoted text clipped - 4 lines]
> main report to no avail. The subreport wizard doesn't help as it
> never offers the ability to link the reports.

Reply to this Message

NeoFax - 13 Mar 2008 14:13 GMT

> So long as the chart's data source and the main report have a field in
> common (and if it isn't a parameter query field) then you should just be
[quoted text clipped - 19 lines]
>
> - Show quoted text -

I just tried this and the info when I run the query in the row source
matches the link/master fields. However, it is asking for the data
when I open the main form.

Reply to this Message

NeoFax - 13 Mar 2008 14:19 GMT

> > So long as the chart's data source and the main report have a field in
> > common (and if it isn't a parameter query field) then you should just be
[quoted text clipped - 29 lines]
>
> - Show quoted text -

Here is the row source for my chart:
TRANSFORM Sum(qryStageDeltaRecovery.DeltaHours) AS SumOfDeltaHours
SELECT qryStageDeltaRecovery.[HELO#] FROM qryStageDeltaRecovery GROUP
BY qryStageDeltaRecovery.[HELO#] PIVOT qryStageDeltaRecovery.Stage;

In this property sheet I set the link/master fields to [HELO#];
[Stage]. Then in the main report(after adding the subreport), I
select the subreport and change in its property sheet the link/master
fields to [HELO#];[Stage]. Yet I am still being asked to enter the
parameters. I have checked the query and it does not have any
parameters set. This is driving me up the wall.

Reply to this Message

Duane Hookom - 13 Mar 2008 21:13 GMT

You can't link on the Stage field since the crosstab has no Stage field (only
Stage values). I expect you would be asked for Stage for every instance of
the chart on your report.

Signature

Duane Hookom
Microsoft Access MVP

> > > So long as the chart's data source and the main report have a field in
> > > common (and if it isn't a parameter query field) then you should just be
[quoted text clipped - 41 lines]
> parameters. I have checked the query and it does not have any
> parameters set. This is driving me up the wall.

Reply to this Message