Call a stored procedure with different value

• Pranav Raval

  Grasshopper

  Points: 24

  More actions

  February 18, 2005 at 10:32 am

  #109697

  Hello All,

  I am new to reporting services and have a basic question.

  I have to create a report that gives me some cross-tab calculations and has 6 tables. All need to call same stored procedure with different parameter.

  I want to do this.

  table 1  - spGenerateReport 1

  ...

  table 6 - spGenerateReport 6

  The problem is I can not call the same stored procedure with different parameter for different table. 

  How can I achieve this? 

  I can not parse the data on client as there are some complex cross-tab calculations in the database that I did not feel comfortable doing with Matrix.

  Thanks for your time.

  -Pranav

• Pranav Raval

  Grasshopper

  Points: 24

  More actions

  February 18, 2005 at 1:14 pm

  #543163

  Okay. I can create different datasets to call the same stored procedure with different parameter value and link those datasets to different table.

  THanks.