Filter chart

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

I have report based on a query qsel_Insurance with the field SID present and
with a Chart on it. How can i filter the output of the chart to the key
field SID?

I used link master, link child by putting SID there but i constantly get a
error "Cannot use the crosstab of a non-fixed column as a subquery".

Unbound object frame: Chart
TRANSFORM Count(*) AS [Count]
SELECT qselChart.Insurance
FROM qselChart
GROUP BY qselChart.Insurance
PIVOT qselChart.StatusID;

qselChart contains the field SID...

Thanx for any assitance!

Regards,
Harmannus
 
You can enter all of the possible values of StatusID into the crosstab's
Column Headings property.
 
Hallo,

Thanx for the response!

Where can i find the crosstab's Column Heading property? Searched and
searched (through Help) but can't find it.

Thanx for the assistance.

Regards,
Harmannus

Duane Hookom said:
You can enter all of the possible values of StatusID into the crosstab's
Column Headings property.

--
Duane Hookom
MS Access MVP
--

Harmannus said:
Hallo,

I have report based on a query qsel_Insurance with the field SID present and
with a Chart on it. How can i filter the output of the chart to the key
field SID?

I used link master, link child by putting SID there but i constantly get a
error "Cannot use the crosstab of a non-fixed column as a subquery".

Unbound object frame: Chart
TRANSFORM Count(*) AS [Count]
SELECT qselChart.Insurance
FROM qselChart
GROUP BY qselChart.Insurance
PIVOT qselChart.StatusID;

qselChart contains the field SID...

Thanx for any assitance!

Regards,
Harmannus
Click to expand...
Click to expand...
 
Hallo,

Found it (at last)! Its in the the row source, query builder. But what do
you mean with enter alle the values?

The StatusID values are R, G, or B:

Now it says:

Field: StatusID
Table: QselGraph
Total: Group By
Crosstab: Column Head

Regards,
Harmannus


Duane Hookom said:
You can enter all of the possible values of StatusID into the crosstab's
Column Headings property.

--
Duane Hookom
MS Access MVP
--

Harmannus said:
Hallo,

I have report based on a query qsel_Insurance with the field SID present and
with a Chart on it. How can i filter the output of the chart to the key
field SID?

I used link master, link child by putting SID there but i constantly get a
error "Cannot use the crosstab of a non-fixed column as a subquery".

Unbound object frame: Chart
TRANSFORM Count(*) AS [Count]
SELECT qselChart.Insurance
FROM qselChart
GROUP BY qselChart.Insurance
PIVOT qselChart.StatusID;

qselChart contains the field SID...

Thanx for any assitance!

Regards,
Harmannus
Click to expand...
Click to expand...
 
I don't think you found it yet. Open the properties dialog box and make sure
you are viewing the query properties.

--
Duane Hookom
MS Access MVP
--

Harmannus said:
Hallo,

Found it (at last)! Its in the the row source, query builder. But what do
you mean with enter alle the values?

The StatusID values are R, G, or B:

Now it says:

Field: StatusID
Table: QselGraph
Total: Group By
Crosstab: Column Head

Regards,
Harmannus


Duane Hookom said:
You can enter all of the possible values of StatusID into the crosstab's
Column Headings property.
Click to expand...
get
a
error "Cannot use the crosstab of a non-fixed column as a subquery".

Unbound object frame: Chart
TRANSFORM Count(*) AS [Count]
SELECT qselChart.Insurance
FROM qselChart
GROUP BY qselChart.Insurance
PIVOT qselChart.StatusID;

qselChart contains the field SID...

Thanx for any assitance!

Regards,
Harmannus
Click to expand...
Click to expand...
Click to expand...
 
Hallo Duane,

I view the query properties but i do not understand how to put alle the
possible values there.

The status values can be R, G or B.

Could you please explain how i can do this..

Thanx in advance.


Regards,
Harmannus


Duane Hookom said:
I don't think you found it yet. Open the properties dialog box and make sure
you are viewing the query properties.

--
Duane Hookom
MS Access MVP
--

Harmannus said:
Hallo,

Found it (at last)! Its in the the row source, query builder. But what do
you mean with enter alle the values?

The StatusID values are R, G, or B:

Now it says:

Field: StatusID
Table: QselGraph
Total: Group By
Crosstab: Column Head

Regards,
Harmannus


Duane Hookom said:
You can enter all of the possible values of StatusID into the crosstab's
Column Headings property.

--
Duane Hookom
MS Access MVP
--

Hallo,

I have report based on a query qsel_Insurance with the field SID present
and
with a Chart on it. How can i filter the output of the chart to the key
field SID?

I used link master, link child by putting SID there but i constantly
Click to expand...
get
a
error "Cannot use the crosstab of a non-fixed column as a subquery".

Unbound object frame: Chart
TRANSFORM Count(*) AS [Count]
SELECT qselChart.Insurance
FROM qselChart
GROUP BY qselChart.Insurance
PIVOT qselChart.StatusID;

qselChart contains the field SID...

Thanx for any assitance!

Regards,
Harmannus
Click to expand...
Click to expand...
Click to expand...
 
Find the property and enter the three possible values.
Column Headings: "R","G","B"

--
Duane Hookom
MS Access MVP


Harmannus said:
Hallo Duane,

I view the query properties but i do not understand how to put alle the
possible values there.

The status values can be R, G or B.

Could you please explain how i can do this..

Thanx in advance.


Regards,
Harmannus


Duane Hookom said:
I don't think you found it yet. Open the properties dialog box and make sure
you are viewing the query properties.

--
Duane Hookom
MS Access MVP
--

Harmannus said:
Hallo,

Found it (at last)! Its in the the row source, query builder. But what do
you mean with enter alle the values?

The StatusID values are R, G, or B:

Now it says:

Field: StatusID
Table: QselGraph
Total: Group By
Crosstab: Column Head

Regards,
Harmannus


You can enter all of the possible values of StatusID into the crosstab's
Column Headings property.

--
Duane Hookom
MS Access MVP
--

Hallo,

I have report based on a query qsel_Insurance with the field SID present
and
with a Chart on it. How can i filter the output of the chart to
Click to expand...
the
key
field SID?

I used link master, link child by putting SID there but i
Click to expand...
constantly
get
a
error "Cannot use the crosstab of a non-fixed column as a subquery".

Unbound object frame: Chart
TRANSFORM Count(*) AS [Count]
SELECT qselChart.Insurance
FROM qselChart
GROUP BY qselChart.Insurance
PIVOT qselChart.StatusID;

qselChart contains the field SID...

Thanx for any assitance!

Regards,
Harmannus
Click to expand...
Click to expand...
Click to expand...
 
Back
Top