Expression help

Howdy, I think this will be aneasy question. I want to return the Max
of three database fields.
I might have Serious = 20 and Medium = 10 and Low = 30
In that case I want it to return 30.
if it is Serious = 2 Medium = 0 and Low = 5
I want it to return 5
If it is serious = 0 Medium =10 Low =3
I want it to return 10.
I am looking at the Max function (aggregate) and can't figure out the
syntaxt. Any help would be appreciated.try
=Math.Max(Fields!Low.Value,Math.Max(Fields!Medium.Value,Fields!Serious.Value))
"Mandoskippy" wrote:
> Howdy, I think this will be aneasy question. I want to return the Max
> of three database fields.
> I might have Serious = 20 and Medium = 10 and Low = 30
> In that case I want it to return 30.
>
> if it is Serious = 2 Medium = 0 and Low = 5
> I want it to return 5
>
> If it is serious = 0 Medium =10 Low =3
> I want it to return 10.
> I am looking at the Max function (aggregate) and can't figure out the
> syntaxt. Any help would be appreciated.
>

Expression based min max settings for Y-axis

Hi,
I have a chart which has scalable Y-axis. I want to set the scale of the
Y-axis dynamically when the report loads based on the maximum and minimum
values the Y-axis variables can take. How do I do that?
Thanking you,
Jd.Check
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=fb9be106-99d0-49f2-b36d-c84e333eb275&sloc=en-us
for details.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:ADECAA95-40FC-415A-BECC-0084FB342690@.microsoft.com...
> Hi,
> I have a chart which has scalable Y-axis. I want to set the scale of the
> Y-axis dynamically when the report loads based on the maximum and minimum
> values the Y-axis variables can take. How do I do that?
> Thanking you,
> Jd.