How to orginize your sql for multiple datasets

• mario17

  SSCertifiable

  Points: 6079

  More actions

  December 3, 2013 at 1:02 pm

  #301927

  Hi,

  I have SSRS report with DocMap which has 6 datasets, all different, and our standards to use SP as sql unit, so I'm thinking what is the good way to nicely organize all, I'm still on 2008 so 1 sp can produce 1 dataset, correct ?

  Also not sure how execution flow works in ssrs, if I have same sp for all datasets with param A,B,C,D,E when I start it will it cause any conflicts or it will run one by one ?

  I tried that and don't know how/where to handle that A,B,C flag, I have other 3 parameters to be set in in conventional way in ssrs, and normally dataset calling just sp_Get01 without any param string, but in this case it should call sp_Get01 'A' ? I'm getting error on this logic, no matter how I define this flag in param list.

  So in other words I need hard coded parameter flag for each of dataset,

  My global task to make 1 sp for 5 dataset.

  Thanks

  Mario

• mario17

  SSCertifiable

  Points: 6079

  More actions

  December 3, 2013 at 4:17 pm

  #1670562

  I found the way to do it, but sp itself giving me errors on random datasets, so I think better don't try this