Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 how to make chart based on dynamic report

Author  Topic 

chloe
Starting Member

3 Posts

Posted - 2003-05-14 : 22:58:22
hi,
my problem is this...i've already finished a report based on a
crosstab query. my report looks like this:

Site Name= Row Heading
Month= Column Heading
Number of records= Value

example:
January February March
Place1 100 200 300
Place2 120 0 220
Place3 290 178 182

in this report, i need to add a BAR CHART FOR EACH SITE NAME, where
the months will be in the x-axis and the number of records will be in
the y-axis.

how do i do this?
i've tried using the chart wizard but it requires a table or query
AND NOT THE RESULTS OF A REPORT to be the source of data.i need to
finish this report by tomorrow.please help! Any suggestion would be
greatly appreciated. thanks!!!





X002548
Not Just a Number

15586 Posts

Posted - 2003-05-15 : 10:44:45
Your report is based on a query or a table right? Can't you use that?


Brett

8-)
Go to Top of Page
   

- Advertisement -