MS Charts on Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to remove the "SumOfFieldName" and just have the name of the
field? Please Assist with this.
 
Find the Row Source property of the chart control and open it in design
view. You can change/alias the column heading in the grid.
 
Is there a way to remove the "SumOfFieldName" and just have the name of the
field? Please Assist with this.
Click to expand...

Yes. SINGLE click on the chart, go to Properties, Row Source, and look for
the something like this SUM([FieldName]) As [CountofFieldName]. Change the
[CountofFieldName] to whatever you want, it won't affect the chart, and the
name you want will appear.
db
 
I tried that, It changes the sort of the records. Can I resort on date? If so
how?

dbarton said:
Is there a way to remove the "SumOfFieldName" and just have the name of the
field? Please Assist with this.
Click to expand...

Yes. SINGLE click on the chart, go to Properties, Row Source, and look for
the something like this SUM([FieldName]) As [CountofFieldName]. Change the
[CountofFieldName] to whatever you want, it won't affect the chart, and the
name you want will appear.
db
Click to expand...
 
Both replies have talked about the Row Source of the chart. How about
providing the SQL view of your Row Source?

--
Duane Hookom
MS Access MVP
--

lmossolle said:
I tried that, It changes the sort of the records. Can I resort on date? If
so
how?

dbarton said:
Is there a way to remove the "SumOfFieldName" and just have the name of
the
field? Please Assist with this.
Click to expand...

Yes. SINGLE click on the chart, go to Properties, Row Source, and look
for
the something like this SUM([FieldName]) As [CountofFieldName]. Change
the
[CountofFieldName] to whatever you want, it won't affect the chart, and
the
name you want will appear.
db
Click to expand...
Click to expand...
 
Here is the SQL View,

SELECT (Format([Date],"mmm"" '""yy")) AS Expr1, Sum([DA Photo
Query].Scheduled) AS Scheduled, Sum([DA Photo Query].Cancelled) AS Cancelled,
Sum([DA Photo Query].[No Shows]) AS [No Shows], Sum([DA Photo Query].Arrived)
AS Arrived, Sum([DA Photo Query].[Standbys Seen]) AS [Standbys Seen]
FROM [DA Photo Query]
GROUP BY (Format([Date],"mmm"" '""yy")), (Year([Date])*12+Month([Date])-1);

Please assist with the sort on the date area.

Duane Hookom said:
Both replies have talked about the Row Source of the chart. How about
providing the SQL view of your Row Source?

--
Duane Hookom
MS Access MVP
--

lmossolle said:
I tried that, It changes the sort of the records. Can I resort on date? If
so
how?

dbarton said:
On Tue, 4 Apr 2006 05:19:02 -0700, lmossolle wrote:

Is there a way to remove the "SumOfFieldName" and just have the name of
the
field? Please Assist with this.

Yes. SINGLE click on the chart, go to Properties, Row Source, and look
for
the something like this SUM([FieldName]) As [CountofFieldName]. Change
the
[CountofFieldName] to whatever you want, it won't affect the chart, and
the
name you want will appear.
db
Click to expand...
Click to expand...
Click to expand...
 
Try order by your last group by expression.
SELECT (Format([Date],"mmm"" '""yy")) AS Expr1,
Sum([DA Photo Query].Scheduled) AS Scheduled,
Sum([DA Photo Query].Cancelled) AS Cancelled,
Sum([DA Photo Query].[No Shows]) AS [No Shows],
Sum([DA Photo Query].Arrived) AS Arrived,
Sum([DA Photo Query].[Standbys Seen]) AS [Standbys Seen]
FROM [DA Photo Query]
GROUP BY (Format([Date],"mmm"" '""yy")), (Year([Date])*12+Month([Date])-1)
ORDER BY Year([Date])*12+Month([Date])-1;



--
Duane Hookom
MS Access MVP
--

lmossolle said:
Here is the SQL View,

SELECT (Format([Date],"mmm"" '""yy")) AS Expr1, Sum([DA Photo
Query].Scheduled) AS Scheduled, Sum([DA Photo Query].Cancelled) AS
Cancelled,
Sum([DA Photo Query].[No Shows]) AS [No Shows], Sum([DA Photo
Query].Arrived)
AS Arrived, Sum([DA Photo Query].[Standbys Seen]) AS [Standbys Seen]
FROM [DA Photo Query]
GROUP BY (Format([Date],"mmm"" '""yy")),
(Year([Date])*12+Month([Date])-1);

Please assist with the sort on the date area.

Duane Hookom said:
Both replies have talked about the Row Source of the chart. How about
providing the SQL view of your Row Source?

--
Duane Hookom
MS Access MVP
--

lmossolle said:
I tried that, It changes the sort of the records. Can I resort on date?
If
so
how?

:

On Tue, 4 Apr 2006 05:19:02 -0700, lmossolle wrote:

Is there a way to remove the "SumOfFieldName" and just have the name
of
the
field? Please Assist with this.

Yes. SINGLE click on the chart, go to Properties, Row Source, and look
for
the something like this SUM([FieldName]) As [CountofFieldName].
Change
the
[CountofFieldName] to whatever you want, it won't affect the chart,
and
the
name you want will appear.
db
Click to expand...
Click to expand...
Click to expand...
 
That did it, THANK YOU!!!!

Duane Hookom said:
Try order by your last group by expression.
SELECT (Format([Date],"mmm"" '""yy")) AS Expr1,
Sum([DA Photo Query].Scheduled) AS Scheduled,
Sum([DA Photo Query].Cancelled) AS Cancelled,
Sum([DA Photo Query].[No Shows]) AS [No Shows],
Sum([DA Photo Query].Arrived) AS Arrived,
Sum([DA Photo Query].[Standbys Seen]) AS [Standbys Seen]
FROM [DA Photo Query]
GROUP BY (Format([Date],"mmm"" '""yy")), (Year([Date])*12+Month([Date])-1)
ORDER BY Year([Date])*12+Month([Date])-1;



--
Duane Hookom
MS Access MVP
--

lmossolle said:
Here is the SQL View,

SELECT (Format([Date],"mmm"" '""yy")) AS Expr1, Sum([DA Photo
Query].Scheduled) AS Scheduled, Sum([DA Photo Query].Cancelled) AS
Cancelled,
Sum([DA Photo Query].[No Shows]) AS [No Shows], Sum([DA Photo
Query].Arrived)
AS Arrived, Sum([DA Photo Query].[Standbys Seen]) AS [Standbys Seen]
FROM [DA Photo Query]
GROUP BY (Format([Date],"mmm"" '""yy")),
(Year([Date])*12+Month([Date])-1);

Please assist with the sort on the date area.

Duane Hookom said:
Both replies have talked about the Row Source of the chart. How about
providing the SQL view of your Row Source?

--
Duane Hookom
MS Access MVP
--

I tried that, It changes the sort of the records. Can I resort on date?
If
so
how?

:

On Tue, 4 Apr 2006 05:19:02 -0700, lmossolle wrote:

Is there a way to remove the "SumOfFieldName" and just have the name
of
the
field? Please Assist with this.

Yes. SINGLE click on the chart, go to Properties, Row Source, and look
for
the something like this SUM([FieldName]) As [CountofFieldName].
Change
the
[CountofFieldName] to whatever you want, it won't affect the chart,
and
the
name you want will appear.
db
Click to expand...
Click to expand...
Click to expand...
 
I have done this and I get a circular error, also in design view it shows the
way I want it, change to preview and it goes back to "sumof".
 
Back
Top