Report chart problem

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
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top