T
tyrdrannoy
I posted a message back in November, and I still need help.
here is my original message:
I am trying to create a 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 the chart's 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. The chart itself is blank
I have tried making sure the column count matches the stored procedure's
columns, and that hasn't helped.
I need help, please.
here is my original message:
I am trying to create a 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 the chart's 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. The chart itself is blank
I have tried making sure the column count matches the stored procedure's
columns, and that hasn't helped.
I need help, please.