SQL Server Performance Forum – Threads Archive
Multiple datasets
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.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
hi bob,
did u find a possible solution to this?
i am facing the same problem
can u please mail me possible solution at [email protected]
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
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
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
]]>