Post reply

stored procedures with expression based connection string

  • January 14, 2007 at 12:49 pm

    #118504

    Hi,

    If i use stored procedure with expression based connection string, the report does not work. But the report works without the stored proc with expression based connection string.

    So can we use Stored procs or is there a way to use them?

     

    Thanks

  • January 15, 2007 at 12:58 am

    #683158

    Report work with store procedure justcheck your datasource which command type you have text or store procedure......... if you have store procedure type then can post more information about your query...

  • January 15, 2007 at 9:03 am

    #683271

    Yes, Report works fine with Stored procedures and command type is stored procedure and not Text.

    My question is Why does Report 2005 not work with stored procs when we use Expressions based connection string. if i dont use expressions based, report works fine with stored proc.

    Has anybody used expression based connection string?

     

  • January 16, 2007 at 12:11 pm

    #683576

    Could you pls show me how you are building the expression for connection string... based on ReportParameters / some variables??

    perhaps i'm ignorant, but i could not see any other way than to use a preset data source with a hard-coded connection string...

  • January 17, 2007 at 9:31 pm

    #683893

    My bad! My report was deployed on a remote server and stored proc was on the database locally on my computer... Since the remote errors was turned off i could not tell what the error msg is. so soon as i turned on the the remote errors on the remote server, it errored out sayin stored proc cannot be found.

     

    so i added the stored proc on the remote database and it works now!

     

    Thanks

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

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