Crosstab values of my chart

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

I got a suggestion to enter all of the possible values of StatusID into the
crosstab's Column Headings in the query properties of my graph chart but do
not understand how to do that.

The values can be R, G or B.

Thanx in advance for any assistance.

Regards,
Harmannus

 

[Duane Hookom]

Open the Row Source of the chart in design view. View the query properties.
There will be a Column Headings property (all crosstab queries have one).
Enter all of your possible StatusID values into this property.

 

[Harmannus]

Hallo Duane,

Found it! But i do not understand the format...

Could you be more specific as to what i have to input?

Field..
Table..
Total..
Crosstab...

The chart is based on a qselChart with all the fields in it.

So the values of StatusID can be R, G or B.

Thanx for any further help.

Regards,
Harmannus

Open the Row Source of the chart in design view. View the query properties.
There will be a Column Headings property (all crosstab queries have one).
Enter all of your possible StatusID values into this 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 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...

I got a suggestion to enter all of the possible values of StatusID into the
crosstab's Column Headings in the query properties of my graph chart but do
not understand how to do that.

The values can be R, G or B.

Thanx in advance for any assistance.

Regards,
Harmannus

 

[Duane Hookom]

"R","G","B"

--
Duane Hookom
MS Access MVP

Hallo Duane,

Found it! But i do not understand the format...

Could you be more specific as to what i have to input?

Field..
Table..
Total..
Crosstab...

The chart is based on a qselChart with all the fields in it.

So the values of StatusID can be R, G or B.

Thanx for any further help.

Regards,
Harmannus

Open the Row Source of the chart in design view. View the query properties.
There will be a Column Headings property (all crosstab queries have one).
Enter all of your possible StatusID values into this property.

--
Duane Hookom
MS Access MVP


present
and

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

I got a suggestion to enter all of the possible values of StatusID

into
the

crosstab's Column Headings in the query properties of my graph chart

but
do

not understand how to do that.

The values can be R, G or B.

Thanx in advance for any assistance.

Regards,
Harmannus

 

[Harmannus]

Thanx for the response!

But where do i put this values? Tried all 4 options but i get errors.

Field..
Table..
Total..
Crosstab...

Regards,
Harmannus

"R","G","B"

--
Duane Hookom
MS Access MVP

Hallo Duane,

Found it! But i do not understand the format...

Could you be more specific as to what i have to input?

Field..
Table..
Total..
Crosstab...

The chart is based on a qselChart with all the fields in it.

So the values of StatusID can be R, G or B.

Thanx for any further help.

Regards,
Harmannus

Open the Row Source of the chart in design view. View the query properties.
There will be a Column Headings property (all crosstab queries have one).
Enter all of your possible StatusID values into this 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

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

I got a suggestion to enter all of the possible values of StatusID into
the
crosstab's Column Headings in the query properties of my graph chart but
do
not understand how to do that.

The values can be R, G or B.

Thanx in advance for any assistance.

Regards,
Harmannus

 

[Duane Hookom]

None of those are the "Query Properties". All property dialog boxes look
pretty much the same. They appear like a small dialog form with property
names and a place for you to enter or select a value. You are referring to
the query grid, not the query properties. Double-click the background in the
upper pane of your crosstab query. This should open the query properties
dialog. The dialog will have a title of "Query Properties". If this doesn't
work, right-click the background and select "Properties...". If this doesn't
work, select View|Properties.

The Column Headings property should be the third from the top.

--
Duane Hookom
MS Access MVP
--

Thanx for the response!

But where do i put this values? Tried all 4 options but i get errors.

Field..
Table..
Total..
Crosstab...

Regards,
Harmannus

"R","G","B"

--
Duane Hookom
MS Access MVP

Hallo Duane,

Found it! But i do not understand the format...

Could you be more specific as to what i have to input?

Field..
Table..
Total..
Crosstab...

The chart is based on a qselChart with all the fields in it.

So the values of StatusID can be R, G or B.

Thanx for any further help.

Regards,
Harmannus


Open the Row Source of the chart in design view. View the query
properties.
There will be a Column Headings property (all crosstab queries have one).
Enter all of your possible StatusID values into this 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
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...

I got a suggestion to enter all of the possible values of StatusID into
the
crosstab's Column Headings in the query properties of my graph

chart
but

do
not understand how to do that.

The values can be R, G or B.

Thanx in advance for any assistance.

Regards,
Harmannus