calculation using 2 different dataset fields -- sql server reporting services

chieko
8/12/2005 10:18:03 AM

Hello.
I need to do a calculation using 2 fields from a different dataset.
I tried something like Value = (Fields!y.Value, "scope") /(Fields!x.Value,
"scope"), but I got the error.
How can I do that?

Thanks in advance for assistance
Chieko

Wayne Snyder
8/13/2005 2:13:10 PM

If you have both of the base values displayed somewhere in your report, have
you tried referring to them via the textbox name?

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

sql server reporting services : calculation using 2 different dataset fields