SQL Server Performance

Multiple datasets

Discussion in 'SQL Server Reporting Services' started by BobJ, May 6, 2004.

  1. BobJ New Member

    If I need to have multiple datasets for a report what is the best way to set up the report? When I try set up a textbox who's data value comes from the 2nd dataset, I get an error I can not access data not in the same dataset.
  2. harsh_sr New Member

    I also got this error.
    But than I realised that I've used Copy/Paste to create the second object(Table in my case). I deleted that, created the object afresh, set the properties....and all that worked afterwords.

    If thass the case, try the above method.


    Harsh
  3. rajcs25 New Member

    hi bob,
    did u find a possible solution to this?
    i am facing the same problem
    can u please mail me possible solution at rajcs25@yahoo.com
    thanks
    raj


    quote:Originally posted by BobJ

    If I need to have multiple datasets for a report what is the best way to set up the report? When I try set up a textbox who's data value comes from the 2nd dataset, I get an error I can not access data not in the same dataset.

    raj
  4. rajcs25 New Member

    hi harsh,
    how did it work?
    can you please let me know what shall i do?


    quote:Originally posted by harsh_sr

    I also got this error.
    But than I realised that I've used Copy/Paste to create the second object(Table in my case). I deleted that, created the object afresh, set the properties....and all that worked afterwords.

    If thass the case, try the above method.


    Harsh

    raj

Share This Page