Post reply

Cannot add stored procedure fileds to the report

  • April 14, 2015 at 6:57 am

    #317399

    Hi,

    I have a stored procedure whcich uses dinamyc SQL

    Like:

    set @SQLVAR = 'select a,b,c from tablename'

    exec @SQLVar

    When I add the store procedure into the report I cannot see the fields to add to my report.

    I want to see the a,b and c columns returned.

    Can someone help?

  • April 14, 2015 at 8:41 am

    #1790830

    try putting the following at the top of your proc

    set FMTONLY off;

  • April 14, 2015 at 8:49 am

    #1790837

    what's that?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply