Subreport to delimit chart

  • Thread starter Thread starter NeoFax
  • Start date Start date
N

NeoFax

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.
 
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
 
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






- Show quoted text -
Click to expand...

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.
 
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.- Hide quoted text -

- Show quoted text -
Click to expand...

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.
 
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.
--
Duane Hookom
Microsoft Access MVP


NeoFax said:
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.- Hide quoted text -

- Show quoted text -
Click to expand...

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.
Click to expand...
 
Back
Top