Report chart problem

[Ticotion]

Hi

I have a report thats is activated by a form. There are several charts
placed in the report. The report and also the charts a filtered by using the
code below

DoCmd.OpenReport "Rpt_AfdelingOEEgraf2", acPreview, ,
"[Produktionslinje] = '" & Me.Kombinationsboks16 & "' and [Datem] >= #" &
Format(Me.Kombinationsboks5, "mm\/dd\/yyyy") & "# And [Datem] <=# " &
Format(Me.Kombinationsboks11, "mm\/dd\/yyyy") & "#", , acWindowNormal

The charts record source works fine and so do the reports source. When
runing them seperately I get the data needed for the reports. I've linked the
master and child links using [Datem];[Produktionslinje].
The problem is that when I run the report the charts only shows the first
record in the record source. It will not show the full date range. Any
suggestions as to what could be wrong?

Br
Ticotion

 

[Duane Hookom]

Try remove the Datem field from the Link properties.

 

[Ticotion]

Why is that the easiest things are the hardest?

That worked Duana. I thank you once again as I thing I've used your help
serveral times before

Br Ticotion

Try remove the Datem field from the Link properties.
--
Duane Hookom
Microsoft Access MVP

Hi

I have a report thats is activated by a form. There are several charts
placed in the report. The report and also the charts a filtered by using the
code below

DoCmd.OpenReport "Rpt_AfdelingOEEgraf2", acPreview, ,
"[Produktionslinje] = '" & Me.Kombinationsboks16 & "' and [Datem] >= #" &
Format(Me.Kombinationsboks5, "mm\/dd\/yyyy") & "# And [Datem] <=# " &
Format(Me.Kombinationsboks11, "mm\/dd\/yyyy") & "#", , acWindowNormal

The charts record source works fine and so do the reports source. When
runing them seperately I get the data needed for the reports. I've linked the
master and child links using [Datem];[Produktionslinje].
The problem is that when I run the report the charts only shows the first
record in the record source. It will not show the full date range. Any
suggestions as to what could be wrong?

Br
Ticotion