Use dataset inside function.

• arup chakraborty

  Hall of Fame

  Points: 3640

  More actions

  July 1, 2009 at 1:18 am

  #206538

  Hi,

  I am very new in SSRS and .net too. I need to write a function which will use a dataset (that already I have created) and return an interger based on the value that dataset returns.

  Is it possible in SSRS? If so, how? Can u give me code snoppet?

  If we are not able to access dataset from the custom function, then how could we establish a database connection inside a function (I mean, i ll apply the SQL for the dataset directly inside the function)? My .NET knowledge is so poor that i even dont know to write it. :ermm:

  Thanks in advance.

• arup chakraborty

  Hall of Fame

  Points: 3640

  More actions

  July 1, 2009 at 3:11 am

  #1018235

  Hi,

  My problem is solved.

  We had one dataset option from the expression field. I have used that instead of using custom function and IT IS WORKING