T
tyrdrannoy
I am trying to create a Pareto chart in an Access 2000 Project. I have the
rowSource set to a stored procedure in my SQL database.
The stored procedure returns a list of reasons and their costs, with the
reasons as the column names (for the x-axis) and the costs as the field
values (for the y-axis).
When I run the stored procedure independently, it returns data in the same
format as the "datasheet" in design view, except I only have (and only need)
one row.
Whenever I run a Print Preview on the report, the only thing that shows up
is the chart's title.
I have tried making sure the column count matches the stored procedure's
columns, and that hasn't helped.
I need help, please.
rowSource set to a stored procedure in my SQL database.
The stored procedure returns a list of reasons and their costs, with the
reasons as the column names (for the x-axis) and the costs as the field
values (for the y-axis).
When I run the stored procedure independently, it returns data in the same
format as the "datasheet" in design view, except I only have (and only need)
one row.
Whenever I run a Print Preview on the report, the only thing that shows up
is the chart's title.
I have tried making sure the column count matches the stored procedure's
columns, and that hasn't helped.
I need help, please.