Dynamic Crosstab Chart

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I need help in creating a report that obtains its data
from a crosstab query. The columns and the rows of the
crosstab query change depending on how I want to search.
For example:
student A student B
class 1 100 98
class 2 89 95
class 3 91 75

can include another column for student C, and so on...

I don't have a problem displaying the data for different
number of rows or columns, but I don't know how to cope
with the changes in the chart that has its data source
from the crosstab query. Is there a way to create a
chart for the crosstab query that may have as many
columns (series) as needed?

Thanks!
 
Ben:

Yes, you can do this. See the current tip on our web site in the Code &
Design Tips area titled "Changing the Record Source for a Graph Object in
Reports"
 
Back
Top