L
Langton
Hi all,
I need to create a line chart that maps revenue over time. I already have
the fields with this data:
Fields: 2000 Revenue, 2001 Revenue, 2002 Revenue, 2003 Revenue, 2004 Budget
My report shows 1 row of data per page, for example, my first page shows all
the data on one account (John Doe Taxes), it shows things like his Account
No, Comments, etc. I need a graph on this page that shows his 2000 revenue,
2001 revenue, etc (I'm already displaying the fields on the page) in a line
graph format.
The next page, for example, is Jane Doe, who will have her own graph showing
her Revenue from 2000-2004. Etc. Etc. Etc.
The problem is that when I draw a line graph, it seems to be trying to sum
data from all Revenues in the table. Do I need to create a query first that
takes data only from the row I am working with? What would this query look
like?
SELECT Revenue2000, Revenue2001, etc
FROM Table1
WHERE ID = Table1.ID
??
Am I on the right track here? Thanks for any help.
I need to create a line chart that maps revenue over time. I already have
the fields with this data:
Fields: 2000 Revenue, 2001 Revenue, 2002 Revenue, 2003 Revenue, 2004 Budget
My report shows 1 row of data per page, for example, my first page shows all
the data on one account (John Doe Taxes), it shows things like his Account
No, Comments, etc. I need a graph on this page that shows his 2000 revenue,
2001 revenue, etc (I'm already displaying the fields on the page) in a line
graph format.
The next page, for example, is Jane Doe, who will have her own graph showing
her Revenue from 2000-2004. Etc. Etc. Etc.
The problem is that when I draw a line graph, it seems to be trying to sum
data from all Revenues in the table. Do I need to create a query first that
takes data only from the row I am working with? What would this query look
like?
SELECT Revenue2000, Revenue2001, etc
FROM Table1
WHERE ID = Table1.ID
??
Am I on the right track here? Thanks for any help.