Hello all,

I have created a query in which I have used first_value, lead, lag windows functions. I tried using the query in SSRS query text, but for some reason it could not load. Then I created a stored procedure and implemented that query in stored proc. The problem is that I am able to execute the stoured proc from sql server studio, but SSRS is not able to load data.

Would really appreciate any guidance on this.

Thanks,

Savi

Hi Savi,

Check this link

http://www.sqlservercentral.com/Forums/Topic1164088-391-1.aspx

@Milan : thank you for replying on this thread. However, I am using just one parameter which I have made mandatory. I have also verified the mapping in my ssrs and it looks Ok to me. Any other reason which you could tell?

Thanks,

Savi

Hi Savi, Which version of Database and SSDT are you using? How big is the dataset? Does it return resultset when run from query editor in SSDT?

Hello @ione : I am using SQL server 2012 version. Dataset is not very big; its just 900 rows and I dont get resultset when I run that in in the query editor, there also I dont get any result set. But I do get the results when I run that stored proc from sql server studio.

Thanks,

Savi