Filter chart

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
 
D

Duane Hookom

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

Harmannus

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

Harmannus

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

Duane Hookom

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

Harmannus

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

Duane Hookom

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

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

Crosstab values of my chart 5
Limit query output 3
Link chart to report 4
chart child master link field 10
using WhereCondition:= on charts and graphs 1
Bar chart question 1
Creating a Chart From a Crosstab Query 6
Formatting Chart for Yes and No instead of -1 and 0 8

Top