Specifiying Input Parameters from Chart Object To Stored Procedure

[PREvans]

I am currently working on automating a report for my office and have come across a problem.

Currently there is one stored procedure that calculates data from our data warehouse. From that store procedure, I can specify which data and the format I want it to be returned as by specifying it (@Table).

The stored procedure receives the following parameters:

@TestYear
@Locationkey
@TestGrade
@TestCategory
@Table

Inside the same report I currently have 3 different chart objects which each use this stored procedure with the only difference in them is the need for a different @Table variable to be passed to it for each chart.

Is there a way for me to pass a different @Table variable for each of the charts?


Thanks,

Paul