Report chart problem

  • Thread starter Thread starter Ticotion
  • Start date Start date
T

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

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


Ticotion said:
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
 
Back
Top