We help IT Professionals succeed at work.

Get Fields from second dataset insted of getting function Sum(dataset2)

665 Views
Last Modified: 2011-10-03
hi,

how do I get value from second dataset (in multi dataset report) in some function it provide scope parameter like Sum(Fields!amount.Value, "DataSet2").
but I need to show the value without using function

i.e; i want to have fields form second dataset but i am getting error when i enforce field values.
if i use Fields!amount.Value then its showing up an error stating 'not in scope'.
Please Help em resolve this problem for me.


Comment
Watch Question

Try just (Fields!amount.Value, "DataSet2")

Author

Commented:
Thanks for the reply
It gives out error and is not possible to use (Fields!amount.Value, "DataSet2").
Can you suggest me any other solution
Where are you using the data? In a textbox or table?

Author

Commented:
in the table
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.