Post reply

dataset error

  • April 25, 2012 at 6:44 pm

    #1479427

    i gave you ddl of my temp table.

    if i remove temp table ,and just keep select statement,i am not getting any error ,in dataset in report.

    like

    @Portfolios or @PortfolioObjectID cannot both be null, one must be populated

    @Portfolios or @PortfolioObjectID cannot both be null, one must be populated

    @Portfolios or @PortfolioObjectID cannot both be null, one must be populated

    An error occurred while getting new row from user defined Table Valued Function :

    System.ApplicationException: @Portfolios or @PortfolioObjectID cannot both be null, one must be populated

    System.ApplicationException:

    at Advent.Apx.CoreUtils.SqlC

    so somehow it is related to temp table?

  • April 25, 2012 at 7:04 pm

    #1479431

    What is the exact error message you are getting?

    Cut and paste it into this thread so that we may see it.

  • April 25, 2012 at 7:55 pm

    #1479440

    thanks Lynn.Got solve myself.

    i needed to use table variable as it is stored in the memory.i was displaying my result with temp.

    so ssrs was not picking it up

  • April 25, 2012 at 8:08 pm

    #1479442

    riya_dave (4/25/2012)

    thanks Lynn.Got solve myself.

    i needed to use table variable as it is stored in the memory.i was displaying my result with temp.

    so ssrs was not picking it up

    Table variables are not necessarily stored in memory. They can, and are many times, also stored on disk in tempdb. Just as it is possible for a temporary table to exist only in memory on occasions.

    I have no idea how you actually solved your problem, but I am glad you did.

  • April 26, 2012 at 6:27 am

    #1479629

    riya_dave (4/25/2012)

    need a suggestion

    i am putting my select statement in temp table.

    if i remove this temp and only keep select ,i am not getting this error.

    Is there any limitation of temp table?

    No. This is not a problem with a temp table. It's a custom error message from your code.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 5 posts - 16 through 19 (of 19 total)

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