Stor Proc with 2 set of parameters

[pko123]

Hi,
I have report that displays result from SQL stored proc. When i run stored proc with first set of parameteres, it results four columns
Market , Number1, Number2, Number3 as titles and
report runs fine. But when i enter second set of parameters,stor proc suppose to return following four columns
Category, Number1 , Number2, Number3 as titles but it still shows same titles as with first set of parameters i.e
Market , Number1, Number2, Number3

Now when i insert last 3 columns into the report for second set of parameters report runs fine but when i try to enter first column Market (supposed to be Category). report say
"One or more field could not be find in the result set. use verify database to update the report"

Even if i do verify database. it results nothing..could you please suggest something...we are using BO X1 R2

 

[Madawc]

Please don't multi-post.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10