Chart problem 2

T

Ticotion

Hi

I have once again problems using access 2003 chart possibilities.

I have a form that filters a report using the following code:

DoCmd.OpenReport "Rpt_SIMparetoH", acPreview, , "[Sektor] =" &
Me.Kombinationsboks16 & " and [Dato] = #" & Format(Me.Kombinationsboks7,
"mm\/dd\/yyyy") & "#", , acWindowNormal

I then have a report that builds on the following query

SELECT qrySimSektorparetoh.Dato, qrySimSektorparetoh.Sektor,
qrySimSektorparetoh.Fejlårsag, qrySimSektorparetoh.[Fejlen hyppighed],
qrySimSektorparetoh.[Hyp total], qrySimSektorparetoh.[Hyp procent]
FROM qrySimSektorparetoh
WHERE
(((qrySimSektorparetoh.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7]) AND
((qrySimSektorparetoh.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]));


in the report I've placed a chart that have the following source code

SELECT qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
qrySIMParetoHyppighed.Fejlårsag, Sum(qrySIMParetoHyppighed.[Fejlen
hyppighed]) AS [Fejl Hyp], Sum(qrySIMParetoHyppighed.[Hyp procent]) AS [Hyp
pct]
FROM qrySIMParetoHyppighed
GROUP BY qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
qrySIMParetoHyppighed.Fejlårsag
HAVING
(((qrySIMParetoHyppighed.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7])
AND
((qrySIMParetoHyppighed.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]))
ORDER BY Sum(qrySIMParetoHyppighed.[Fejlen hyppighed]) DESC;


I've linked the two using Sektor both as master and as child. The problem is
that I recieve an empty chart. Can anyone help?

Once again thank you for all your help

Ticotion
 
D

Duane Hookom

Is the chart in the Sektor group header or footer?
Do you have a text box bound to Sektor in the same report section as the
chart?
 
T

Ticotion

Hi Duane

The chart is placed in the report header and yes I have a text box where the
control source is Sektor. But I have now noticed that it seems like this
textbox does not have anything in it. I've tried changing the control source
to the combobox input from the form. This gives an error. There should be a
sektor number. So maybe it is because the filter is not be set correctly?

Br
Ticotion

Duane Hookom said:
Is the chart in the Sektor group header or footer?
Do you have a text box bound to Sektor in the same report section as the
chart?

--
Duane Hookom
Microsoft Access MVP


Ticotion said:
Hi

I have once again problems using access 2003 chart possibilities.

I have a form that filters a report using the following code:

DoCmd.OpenReport "Rpt_SIMparetoH", acPreview, , "[Sektor] =" &
Me.Kombinationsboks16 & " and [Dato] = #" & Format(Me.Kombinationsboks7,
"mm\/dd\/yyyy") & "#", , acWindowNormal

I then have a report that builds on the following query

SELECT qrySimSektorparetoh.Dato, qrySimSektorparetoh.Sektor,
qrySimSektorparetoh.Fejlårsag, qrySimSektorparetoh.[Fejlen hyppighed],
qrySimSektorparetoh.[Hyp total], qrySimSektorparetoh.[Hyp procent]
FROM qrySimSektorparetoh
WHERE
(((qrySimSektorparetoh.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7]) AND
((qrySimSektorparetoh.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]));


in the report I've placed a chart that have the following source code

SELECT qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
qrySIMParetoHyppighed.Fejlårsag, Sum(qrySIMParetoHyppighed.[Fejlen
hyppighed]) AS [Fejl Hyp], Sum(qrySIMParetoHyppighed.[Hyp procent]) AS [Hyp
pct]
FROM qrySIMParetoHyppighed
GROUP BY qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
qrySIMParetoHyppighed.Fejlårsag
HAVING
(((qrySIMParetoHyppighed.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7])
AND
((qrySIMParetoHyppighed.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]))
ORDER BY Sum(qrySIMParetoHyppighed.[Fejlen hyppighed]) DESC;


I've linked the two using Sektor both as master and as child. The problem is
that I recieve an empty chart. Can anyone help?

Once again thank you for all your help

Ticotion
Click to expand...
Click to expand...
 
D

Duane Hookom

I was wondering why you apply a WHERE CONDITION in the DoCmd.OpenReport as
well as having a similar WHERE CLAUSE in the record source query. You
shouldn't need both.

If the text box is blank the chart will be blank.
--
Duane Hookom
Microsoft Access MVP


Ticotion said:
Hi Duane

The chart is placed in the report header and yes I have a text box where the
control source is Sektor. But I have now noticed that it seems like this
textbox does not have anything in it. I've tried changing the control source
to the combobox input from the form. This gives an error. There should be a
sektor number. So maybe it is because the filter is not be set correctly?

Br
Ticotion

Duane Hookom said:
Is the chart in the Sektor group header or footer?
Do you have a text box bound to Sektor in the same report section as the
chart?

--
Duane Hookom
Microsoft Access MVP


Ticotion said:
Hi

I have once again problems using access 2003 chart possibilities.

I have a form that filters a report using the following code:

DoCmd.OpenReport "Rpt_SIMparetoH", acPreview, , "[Sektor] =" &
Me.Kombinationsboks16 & " and [Dato] = #" & Format(Me.Kombinationsboks7,
"mm\/dd\/yyyy") & "#", , acWindowNormal

I then have a report that builds on the following query

SELECT qrySimSektorparetoh.Dato, qrySimSektorparetoh.Sektor,
qrySimSektorparetoh.Fejlårsag, qrySimSektorparetoh.[Fejlen hyppighed],
qrySimSektorparetoh.[Hyp total], qrySimSektorparetoh.[Hyp procent]
FROM qrySimSektorparetoh
WHERE
(((qrySimSektorparetoh.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7]) AND
((qrySimSektorparetoh.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]));


in the report I've placed a chart that have the following source code

SELECT qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
qrySIMParetoHyppighed.Fejlårsag, Sum(qrySIMParetoHyppighed.[Fejlen
hyppighed]) AS [Fejl Hyp], Sum(qrySIMParetoHyppighed.[Hyp procent]) AS [Hyp
pct]
FROM qrySIMParetoHyppighed
GROUP BY qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
qrySIMParetoHyppighed.Fejlårsag
HAVING
(((qrySIMParetoHyppighed.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7])
AND
((qrySIMParetoHyppighed.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]))
ORDER BY Sum(qrySIMParetoHyppighed.[Fejlen hyppighed]) DESC;


I've linked the two using Sektor both as master and as child. The problem is
that I recieve an empty chart. Can anyone help?

Once again thank you for all your help

Ticotion
Click to expand...
Click to expand...
Click to expand...
 
T

Ticotion

Hi Duana

So I solve the issue regarding the empty Sektor field. Now I got it to draw
some sort of a chart but it kind off cumulates all the values in one bar. It
should show
[Fejl Hyp] (Frequence) on the y-axe as bars and the [Fejlårsag] (Error
Cause) on the x-axe and [Hyp procent] (Frequence in pct) on the y2-axe. The
chart should be set-up to do this as I've copied the data from the query into
the datasheet. So in desing mode I get the right layout.

I link with sector but I think this is the problem. I've tried linking with
[Fejlårsag] but here I get an empty result once again.

Any suggestions?

Br
Ticotion



Duane Hookom said:
I was wondering why you apply a WHERE CONDITION in the DoCmd.OpenReport as
well as having a similar WHERE CLAUSE in the record source query. You
shouldn't need both.

If the text box is blank the chart will be blank.
--
Duane Hookom
Microsoft Access MVP


Ticotion said:
Hi Duane

The chart is placed in the report header and yes I have a text box where the
control source is Sektor. But I have now noticed that it seems like this
textbox does not have anything in it. I've tried changing the control source
to the combobox input from the form. This gives an error. There should be a
sektor number. So maybe it is because the filter is not be set correctly?

Br
Ticotion

Duane Hookom said:
Is the chart in the Sektor group header or footer?
Do you have a text box bound to Sektor in the same report section as the
chart?

--
Duane Hookom
Microsoft Access MVP


:

Hi

I have once again problems using access 2003 chart possibilities.

I have a form that filters a report using the following code:

DoCmd.OpenReport "Rpt_SIMparetoH", acPreview, , "[Sektor] =" &
Me.Kombinationsboks16 & " and [Dato] = #" & Format(Me.Kombinationsboks7,
"mm\/dd\/yyyy") & "#", , acWindowNormal

I then have a report that builds on the following query

SELECT qrySimSektorparetoh.Dato, qrySimSektorparetoh.Sektor,
qrySimSektorparetoh.Fejlårsag, qrySimSektorparetoh.[Fejlen hyppighed],
qrySimSektorparetoh.[Hyp total], qrySimSektorparetoh.[Hyp procent]
FROM qrySimSektorparetoh
WHERE
(((qrySimSektorparetoh.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7]) AND
((qrySimSektorparetoh.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]));


in the report I've placed a chart that have the following source code

SELECT qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
qrySIMParetoHyppighed.Fejlårsag, Sum(qrySIMParetoHyppighed.[Fejlen
hyppighed]) AS [Fejl Hyp], Sum(qrySIMParetoHyppighed.[Hyp procent]) AS [Hyp
pct]
FROM qrySIMParetoHyppighed
GROUP BY qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
qrySIMParetoHyppighed.Fejlårsag
HAVING
(((qrySIMParetoHyppighed.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7])
AND
((qrySIMParetoHyppighed.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]))
ORDER BY Sum(qrySIMParetoHyppighed.[Fejlen hyppighed]) DESC;


I've linked the two using Sektor both as master and as child. The problem is
that I recieve an empty chart. Can anyone help?

Once again thank you for all your help

Ticotion
Click to expand...
Click to expand...
Click to expand...
 
D

Duane Hookom

Your chart display depends on the Row Source property and the Link
Master/Child. I expect your Link properties will be the Sektor.

If you can't figure this out, reply back with the Row Source and link
properties.
--
Duane Hookom
Microsoft Access MVP


Ticotion said:
Hi Duana

So I solve the issue regarding the empty Sektor field. Now I got it to draw
some sort of a chart but it kind off cumulates all the values in one bar. It
should show
[Fejl Hyp] (Frequence) on the y-axe as bars and the [Fejlårsag] (Error
Cause) on the x-axe and [Hyp procent] (Frequence in pct) on the y2-axe. The
chart should be set-up to do this as I've copied the data from the query into
the datasheet. So in desing mode I get the right layout.

I link with sector but I think this is the problem. I've tried linking with
[Fejlårsag] but here I get an empty result once again.

Any suggestions?

Br
Ticotion



Duane Hookom said:
I was wondering why you apply a WHERE CONDITION in the DoCmd.OpenReport as
well as having a similar WHERE CLAUSE in the record source query. You
shouldn't need both.

If the text box is blank the chart will be blank.
--
Duane Hookom
Microsoft Access MVP


Ticotion said:
Hi Duane

The chart is placed in the report header and yes I have a text box where the
control source is Sektor. But I have now noticed that it seems like this
textbox does not have anything in it. I've tried changing the control source
to the combobox input from the form. This gives an error. There should be a
sektor number. So maybe it is because the filter is not be set correctly?

Br
Ticotion

:

Is the chart in the Sektor group header or footer?
Do you have a text box bound to Sektor in the same report section as the
chart?

--
Duane Hookom
Microsoft Access MVP


:

Hi

I have once again problems using access 2003 chart possibilities.

I have a form that filters a report using the following code:

DoCmd.OpenReport "Rpt_SIMparetoH", acPreview, , "[Sektor] =" &
Me.Kombinationsboks16 & " and [Dato] = #" & Format(Me.Kombinationsboks7,
"mm\/dd\/yyyy") & "#", , acWindowNormal

I then have a report that builds on the following query

SELECT qrySimSektorparetoh.Dato, qrySimSektorparetoh.Sektor,
qrySimSektorparetoh.Fejlårsag, qrySimSektorparetoh.[Fejlen hyppighed],
qrySimSektorparetoh.[Hyp total], qrySimSektorparetoh.[Hyp procent]
FROM qrySimSektorparetoh
WHERE
(((qrySimSektorparetoh.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7]) AND
((qrySimSektorparetoh.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]));


in the report I've placed a chart that have the following source code

SELECT qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
qrySIMParetoHyppighed.Fejlårsag, Sum(qrySIMParetoHyppighed.[Fejlen
hyppighed]) AS [Fejl Hyp], Sum(qrySIMParetoHyppighed.[Hyp procent]) AS [Hyp
pct]
FROM qrySIMParetoHyppighed
GROUP BY qrySIMParetoHyppighed.Dato, qrySIMParetoHyppighed.Sektor,
qrySIMParetoHyppighed.Fejlårsag
HAVING
(((qrySIMParetoHyppighed.Dato)=[Forms]![frmSIMpareto]![Kombinationsboks7])
AND
((qrySIMParetoHyppighed.Sektor)=[Forms]![frmSIMpareto]![Kombinationsboks16]))
ORDER BY Sum(qrySIMParetoHyppighed.[Fejlen hyppighed]) DESC;


I've linked the two using Sektor both as master and as child. The problem is
that I recieve an empty chart. Can anyone help?

Once again thank you for all your help

Ticotion
Click to expand...
Click to expand...
Click to expand...
 

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

Running sum 5

Top