using two field from diffrent dataset in a table ,has error, what can i do
using two field from diffrent dataset in a table ,has error, what can i do
May 27th, 2012 4:15pm

Hi Shabnam2012 Your tablix is bond to one dataset at a time but If you are using SSRS 2008 you can use lookup function to get the data from another dataset. You can only use lookup when there is one-to-one relationship between source and destination. if there is 1 to many relationship you need to use LookupSet instead. The syntax for lookup function is look like this =Lookup(Fields!Code.Value, Fields!Code.Value,Fields!toatlHotcount.Value,"Dataset2") =Lookup(Fields!Code.Value, Fields!Code.Value,Fields!toatlHotcount.Value,"Dataset2") Where the first Fields! Code.Value is your first dataset field ("Dataset1") and Fields! Code.Value is the field in the second dataset ("Dataset2") and both have one to one relationship with each other Fields! toatlHotcount.Value is the value which you are getting from second dataset ("Dataset2") If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2012 6:49pm

Please provide the error, plus sample data. That's what you can do. Talk to me now on
May 27th, 2012 7:27pm

And please add what you want to achieve, too.
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2012 7:54pm

Hi Shabnam, Could you please be some more specific... put error message here and if possible, some sample dataPlease Mark as Answer if my post solved your problem or Vote As Helpful if this helps. Blogs: www.sqlserver2005forum.blogspot.com
May 28th, 2012 3:54am

thanks foe your response , somtimes , i shuld use sql2005, isnt any way for sql2005
Free Windows Admin Tool Kit Click here and download it now
May 28th, 2012 11:19am

Hi Sabnam2012 Thanks for your posting. You cannot use two dataset inside one table in SSRS 2005, you either need to merge these two dataset into one or you can use a sub report inside the main report to bring the data from another dataset. Another approach is put the data you need in a hidden multivalued parameter. In the table, refer the value of parameter like : = Parameters!data1.value For more information please look on the following threads http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/790790b8-f959-486e-aae6-05243aeae54b http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/dfd92048-58ac-47cf-b6f1-9185caff2e73 If you have any questions please do ask. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
May 28th, 2012 8:48pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics