Post reply

Fields List is blank when executing a SP with sp_executesql

  • May 10, 2004 at 6:04 pm

    #108199

    Hi,

    I have a stored procedure which dynamically creates the 'where' condition based on the parameters supplied and is executed using sp_executesql.When i try to attach it to the Report, the Fields list is blank.Eventhough in the data tab when the dataset is previewed it shows all the records.Is there any solution to this problem.Thanks,

     

     

     

  • May 12, 2004 at 9:04 am

    #506160

    By report, what do you mean?

    What application is generating the report and what format is the report in.

    Sounds like an application problem rather than sql

    ------------------------------
    The Users are always right - when I'm not wrong!

  • July 2, 2004 at 12:01 am

    #513073

    Hi Rajesh,

    I am having exactly the same problem you describe. I have designed a stored procedure with a dynamic where clause. When I create a report using Visual Studio.net, which attaches to the stored proc in question, the fields do not show up. Looks like one step forward two steps back!

    Any suggestions on how to resolve this problem would be much appreciated.

    Kind Regards,

    Terry Pino

  • July 2, 2004 at 1:14 am

    #513077

    Hi,

    Go to the Fields List Box.By Right Clicking you will get the add option.In the add Screen give the name and database field for all the fields in the query.It will work.

    Rajesh

     

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

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