my dataset not showing any columns

• SWATH

  Old Hand

  Points: 303

  More actions

  November 27, 2012 at 5:36 am

  #265254

  HI all i am trying to create a report with data from a stored procedure, i created a stored procedure (which includes Dynamic SQL,Temp Tables) and i tried to create a new dataset with data from the stored procedure when i am trying to add it the dataset is getting created with zero fields, i went to the query part and passed the parameters and the result is showing up. i am kind of confused with the issue becuase my script is working perfectly. i browsed for the issue and some one told to

  SET FMTONLY OFF

  i tried it but no luck. can any one help me out with this issue.

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  November 27, 2012 at 7:04 am

  #1562665

  I wrote a blog about this that may help. There are also several alternative approaches in the comments below the blog.

  http://www.bidn.com/blogs/Daniel/ssas/1908/ssrs-dataset-fields-disappear-when-using-a-stored-procedure-with-dynamic-sql-%E2%80%93-how-to-get-them-back-and-save-your-report