Crosstab values of my 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...

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


Duane Hookom said:
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


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

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
Click to expand...
Click to expand...
 
"R","G","B"

--
Duane Hookom
MS Access MVP


Harmannus said:
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


Duane Hookom said:
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
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...

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

The values can be R, G or B.

Thanx in advance for any assistance.

Regards,
Harmannus
Click to expand...
Click to expand...
Click to expand...
 
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

Duane Hookom said:
"R","G","B"

--
Duane Hookom
MS Access MVP


Harmannus said:
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


Duane Hookom said:
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
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...

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
Click to expand...
Click to expand...
Click to expand...
 
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
--

Harmannus said:
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

Duane Hookom said:
"R","G","B"

--
Duane Hookom
MS Access MVP


Harmannus said:
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
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...

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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top