Access

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

Guest

Hi,

I want to have a graph in a 0reports that are linked to a query.
I would like the graph to update automatically every time I send the report
to the printer.

I have tried to do a work-a-round by copying the query data sheet into the
data sheet behind the graph, but when I do that, i can't get it to display
the way I want.

Also, is there a linit to the number of categories that can be displayed.

Cheers,
 
Duane Hookom said:
The graph should always display the current date when the report is opened.
Are you not experiencing this?

Is the a particular maximum number of lines or bars that you anticipate?

ACG Soft has some good information about graphing on their web site
http://ourworld.compuserve.com/homepages/attac-cg/..

--
Duane Hookom
MS Access MVP





No, but thanks I will have a look at that site.
Click to expand...
My main problem is that I can't link the graph in the report to a query so
that whenever new data the put in or current data altered, tis is not being
refledcted in the graph.

Cheers,
 
Gary said:
My main problem is that I can't link the graph in the report to a query so
that whenever new data the put in or current data altered, tis is not being
refledcted in the graph.

Cheers,

I tried those links and tried what they suggested but it didn't work or I couldn't get it to work, one or the other.
Click to expand...
What I have done is use "insert" , "object" ' "microsoft excel chart" then
when I have finished editing I save it as an image.
When I use insert "chart" it tells me after all the editing is done that
the "ole server" is not installed.

I re-installed but the print preview graph only show one range whereas the
design view show everything just the way I want it.

Once again thanks for getting back as it all helps

Cheers,
 
Is there a reason you don't use the MS Graph control in Access. You then
place a sql statement or query in the Row Source property.
 
Duane Hookom said:
Is there a reason you don't use the MS Graph control in Access. You then
place a sql statement or query in the Row Source property.
Click to expand...
Hi,
I tried that but it doesn't work.

I get it right in the design view but in the print view I only get one
category instead of 39

I checked RowSourceType and RowSource and I even changed the Row Source from
the SQL statement to the actual query I want the graph tied to.

Iv'e checked everything else I can think of but no go.

Cheers,
 
I'm not sure about the limitation of "categories". I just created a line
graph with 31 lines based on SQL from Northwind.mdb. My Row Source property
is:
TRANSFORM Sum([UnitPrice]*[quantity]) AS Expr1
SELECT Orders.ShipCountry
FROM Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order
Details].OrderID
GROUP BY Orders.ShipCountry
PIVOT "D" & Format(DatePart("d",[OrderDate]),"00");
 
Duane Hookom said:
I'm not sure about the limitation of "categories". I just created a line
graph with 31 lines based on SQL from Northwind.mdb. My Row Source property
is:
TRANSFORM Sum([UnitPrice]*[quantity]) AS Expr1
SELECT Orders.ShipCountry
FROM Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order
Details].OrderID
GROUP BY Orders.ShipCountry
PIVOT "D" & Format(DatePart("d",[OrderDate]),"00");


--
Duane Hookom
MS Access MVP


Gary said:
Hi,
I tried that but it doesn't work.

I get it right in the design view but in the print view I only get one
category instead of 39

I checked RowSourceType and RowSource and I even changed the Row Source
from
the SQL statement to the actual query I want the graph tied to.

Iv'e checked everything else I can think of but no go.

Cheers,
Click to expand...


Hi,
Click to expand...

I don't do SQL and I thoutht it should be a relativley easy process to just
draw a graph and hook it up to a query.

If I use insert object I get "operation on the OLE object failed"

If I use insert chart and attach the graph to the query I end up with only
one range in the print view and it is the "y" category in a list of "A to Z"
categories even though they are all there in design view.

I don't do SQL but as I said before I use Table/Query in the RowSourceType
and in the RowSource there is an SQL statement or expression.

Should there be anything in Source Doc or Source Item inthe graph properties

Thanks for your time, I appreciate it.

Cheers,
 
Gary said:
Duane Hookom said:
I'm not sure about the limitation of "categories". I just created a line
graph with 31 lines based on SQL from Northwind.mdb. My Row Source
property
is:
TRANSFORM Sum([UnitPrice]*[quantity]) AS Expr1
SELECT Orders.ShipCountry
FROM Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order
Details].OrderID
GROUP BY Orders.ShipCountry
PIVOT "D" & Format(DatePart("d",[OrderDate]),"00");


--
Duane Hookom
MS Access MVP


Gary said:
:

Is there a reason you don't use the MS Graph control in Access. You
then
place a sql statement or query in the Row Source property.

--
Duane Hookom
MS Access MVP




:



:

The graph should always display the current date when the report
is
opened.
Are you not experiencing this?

Is the a particular maximum number of lines or bars that you
anticipate?

ACG Soft has some good information about graphing on their web
site
http://ourworld.compuserve.com/homepages/attac-cg/..

--
Duane Hookom
MS Access MVP


Hi,

I want to have a graph in a 0reports that are linked to a
query.
I would like the graph to update automatically every time I
send
the
report
to the printer.

I have tried to do a work-a-round by copying the query data
sheet
into the
data sheet behind the graph, but when I do that, i can't get it
to
display
the way I want.

Also, is there a linit to the number of categories that can be
displayed.

Cheers,



No, but thanks I will have a look at that site.
My main problem is that I can't link the graph in the report to a
query
so
that whenever new data the put in or current data altered, tis is
not
being
refledcted in the graph.

Cheers,

I tried those links and tried what they suggested but it didn't
work
or I
couldn't get it to work, one or the other.
What I have done is use "insert" , "object" ' "microsoft excel
chart"
then
when I have finished editing I save it as an image.
When I use insert "chart" it tells me after all the editing is done
that
the "ole server" is not installed.

I re-installed but the print preview graph only show one range
whereas
the
design view show everything just the way I want it.

Once again thanks for getting back as it all helps

Cheers,

Hi,
I tried that but it doesn't work.

I get it right in the design view but in the print view I only get one
category instead of 39

I checked RowSourceType and RowSource and I even changed the Row Source
from
the SQL statement to the actual query I want the graph tied to.

Iv'e checked everything else I can think of but no go.

Cheers,
Click to expand...


Hi,
Click to expand...

I don't do SQL and I thoutht it should be a relativley easy process to
just
draw a graph and hook it up to a query.

If I use insert object I get "operation on the OLE object failed"

If I use insert chart and attach the graph to the query I end up with
only
one range in the print view and it is the "y" category in a list of "A to
Z"
categories even though they are all there in design view.

I don't do SQL but as I said before I use Table/Query in the RowSourceType
and in the RowSource there is an SQL statement or expression.

Should there be anything in Source Doc or Source Item inthe graph
properties

Thanks for your time, I appreciate it.

Cheers,
Click to expand...
I don't know what you mean by you don't do SQL. A query is SQL. The chart
wizard may whine about too many fields but just ignore it. When the chart
has been completed set the row source property to your query that returns
multiple columns.
 
Back
Top