Chart problem 2

  • Thread starter Thread starter Ticotion
  • Start date Start date
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
 
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?
 
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...
 
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...
 
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...
 
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...
 
Back
Top