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.