SSRS question

• Tahir Gul

  SSC Veteran

  Points: 292

  More actions

  January 5, 2011 at 10:01 pm

  #243228

  A dataset is returned from a stored procedure, Now I want to manipulate the dataset and after some filtering and manipulation use it in my reports. I don't know how to play with the dataset. What I want is as under:

  Dataset ds = new dataset();

  SqlDataAdapter da = new SqlDataAdapter();

  da.fill(ds);

  for(int i =0 ; i < ds.tables[0].rows; i++)

  {

  if(ds.tables.row["columnName"] == "somethting")

  {

  }

  }

  here I want to pass the filtered dataset to reports.

  Any help

  Thanks

  Tahir

• rakhi.pathrikar

  Grasshopper

  Points: 17

  More actions

  January 6, 2011 at 12:01 am

  #1269884

  You Can use DataViews Rowfilter property

  DataView dv = new DataView();

  dv.Table = ds.Tables[Your Table Name];

  dv.RowFilter = filter criteria

• Satish-219904

  SSC Eights!

  Points: 874

  More actions

  January 6, 2011 at 2:54 pm

  #1270344

  Thanks man. I will use the SORT_IN_TEMPDB option while rebuilding indexes. I hope it will reduce the transaction log space. Yes, I do have enough space for TempDB.

  Don't understand the reason for rebuilding the indexes every day though.

  Thanks,

  Satish