chart child master link field

[iccsi]

I have a chart on the report and has child master link to the report.

The chart shows my child field when the field is in my row source
query.
It lost link if I take the child field away.

I must do something wrong.
Are there any property of chart or report to hid the chaild field on
the chart of the reports?


Your help is great appreciated,

 

[Duane Hookom]

Did you bind your link master field to a control in the section containing
the chart control?

 

[inungh]

Did you bind your link master field to a control in the section containing
the chart control?

--
Duane Hookom
Microsoft Access MVP








- Show quoted text -

yes, my master field links to a field of the report.
It seems the chart creates a crosstab query when I insert the chart on
the report.

I use my query to replace it. I beleive that I need use the crosstab
query chart created and modify it to fit my chart.

I am still working on it.
Please let me know if I am on the right track.

Thanks again,

 

[inungh]

Did you bind your link master field to a control in the section containing
the chart control?

--
Duane Hookom
Microsoft Access MVP








- Show quoted text -

Thanks for helping,
The example is helpful.
My report has more than one data series.
Can you please help me put which field on the chart for data series?

Your help is great appreciated,

 

[inungh]

Did you bind your link master field to a control in the section containing
the chart control?

--
Duane Hookom
Microsoft Access MVP








- Show quoted text -

I download your example and see that your link child field does not
need in the query.

The differences between your application and mine are your application
data are from a table and mine is from a query.

Mine has more than one data series.
Yours has 2 group Company and Year Month and chart is in the group
Year Month Group Footer, mine has ony one group Element ID and my
chart is in the Element Group Footer.

I tried to take out the Element ID in the child then the link lost.
If I have Element ID in the query then Element ID shows on the chart
which makes sense.

Do I need 2 groups and have the chart in the second level of group to
have master child links?

For some reason, my report only recognizes the child link when it is
in the child chart query.

I must be doing something wrong on my application,

Thanks again,

 

[Duane Hookom]

I believe the linking child field needs to be in the query supplying the Row
Source of the chart but doesn't have to be directly in the chart row source
displayed fields.

 

[inungh]

I believe the linking child field needs to be in the query supplying the Row
Source of the chart but doesn't have to be directly in the chart row source
displayed fields.
--
Duane Hookom
Microsoft Access MVP













- Show quoted text -

Yes, it shows in the chart when I have the link field in the SQL.
Your example does not in the chart row sourc, since the query get data
from table.

It seems MS Access create a crosstab query in the background for the
chart and put child link field in the column heading. If I have a
select query than it works when I have set the linking field using
report wizard.

I did several testing and realized that my data source is a crosstab
query and the number of the fields are unknown, MS Acces is unable to
create crosstab again for the chart.

I have it work when I have fixed columns name and columns number.
I think that chart row source must have known field name and number to
support master child link.

Do you have any suggestions?
Thanks millions again,

 

[Duane Hookom]

I would have to review and test this with some sample data which I don't have
time at the moment. It seems to me I have done this before with the linking
with multiple datasets and a crosstab as the Row Source.

 

[inungh]

I would have to review and test this with some sample data which I don't have
time at the moment. It seems to me I have done this before with the linking
with multiple datasets and a crosstab as the Row Source.
--
Duane Hookom
Microsoft Access MVP










- Show quoted text -

Thanks millions for helping,
I will do more testing again.
I have it work with fix columns,
If it does not work, one solution is using a temp table or many charts
on the report and set visible and invisble accordingly or change te
SQL at run time for row source of the chart.

I just wonder if I have 10 charts on the group footer and set visible
property will it affect performance or not?
If yes, then I have to make it works or my program does not support
the functions.

Thanks again,

 

[inungh]

I would have to review and test this with some sample data which I don't have
time at the moment. It seems to me I have done this before with the linking
with multiple datasets and a crosstab as the Row Source.
--
Duane Hookom
Microsoft Access MVP










- Show quoted text -

Thanks again,
The problem is "SELECT * FROM MYTABLE"
SQL chart must specify the fields.
It should resolve if I build SQL at run time after get all the fields
and build it.

Thanks millions for helping,

 

[inungh]

I would have to review and test this with some sample data which I don't have
time at the moment. It seems to me I have done this before with the linking
with multiple datasets and a crosstab as the Row Source.
--
Duane Hookom
Microsoft Access MVP










- Show quoted text -

Thanks millions for helping,
Finally, I found that if I use crosstab query for the chart row
source, I must specify PIVOT in ("Field1", "Field2", "Field3") for
PIVOT clause, or MS Access chart does not support master child link.

Thanks again,