StoreProcedure - SQL - CR2013 - Issue in O/P fields

[Former Member]

When I am try creating a CR2013 report using a store procedure build in SQL DB the list of available o/p fields don't expand.

List of input parameters look ok though.

Not sure if there is issue in the syntax of the store procedure.

SQL DB is 2012

CR is 2013 designer

[abhilash_kumar · Accepted solution]

Hi Vishal,

What database driver are you using for the connection?

It is recommended that use the SQL Server Native Client 10.0 or 11.0 driver.

-Abhilash

[Former Member · Accepted solution]

I am using SQL Server Native Client 11.0

[abhilash_kumar · Accepted solution]

Does the SP work fine when run in the Management Studio?

-Abhilash

[Former Member · Accepted solution]

You are right, the user which I was using to run the proc didnt have access to one of the underlying table.

Works now.