Expression in chart title?

Hi all,
why can I not apply an expression to the chart title? This seems strange to
me.
Please help,
TazWHat I generally do is either make a title out of a text box or a table with
only a table header in it.
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:%23naLU6l0GHA.328@.TK2MSFTNGP06.phx.gbl...
> Hi all,
> why can I not apply an expression to the chart title? This seems strange
> to me.
> Please help,
> Taz
>|||Hi Ben,
thanks for the work around. I was hoping for something cleaner. I feel RS
still has a long way to go.
Taz
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:u9SdQ5n0GHA.1288@.TK2MSFTNGP03.phx.gbl...
> WHat I generally do is either make a title out of a text box or a table
> with only a table header in it.
> "Tarun Mistry" <nospam@.nospam.com> wrote in message
> news:%23naLU6l0GHA.328@.TK2MSFTNGP06.phx.gbl...
>> Hi all,
>> why can I not apply an expression to the chart title? This seems strange
>> to me.
>> Please help,
>> Taz
>

Expression for visibility of a chart

Hi,

I wrote the following expression in the visibility(Hidden) property of a chart.

=Iif(DateDiff("Hour",Parameters!StartDate.Value ,Parameters!EndDate.Value)< 24,False,True)

And it is giving me the following error.

An error occured during local report processing.

The Hidden expression for the chart 'chart1' contains an error: Argument 'Interval' is not a valid value.

What is the problem?

Sincerely,

Amde

Is the report parameters' data type defined as DateTime?

Try this:
=Iif(DateDiff("h", CDate(Parameters!StartDate.Value), CDate(Parameters!EndDate.Value)) < 24,False,True)

-- Robert

|||

Yes! Now it is working. The thing is I tried by adding the CDate function, but the problem is with the interval value.

In the books oline it is documented to use the following interval: Year, Quarter, Month, Day, Hour, Minute, Second, or Week for the DateAdd and DateDiff functions. Why is this not working?

Amde

|||

The interval value must be either an enum value or a string value.

You have to use either DateInterval.Hour (enum value) or "h" (string value) for the first argument of the DateDiff function.

-- Robert

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.