Repost:The processing of filter expression for the chart "MyChart" cannot be performed. Th

I got the following error when I try to luanch the report ,it is working on
another server with SP1 installed on it .Could it be the problem?(Not havinf
Sp1)
The processing of filter expression for the chart "MyChart" cannot be
performed. The comparison failed
I removed the filter and it works,why this filter is working in the other
server and not in this server.
here is the filters that I use:
=Fields!monthName.Value
!= Total
ThanksDoes installing SP1 resolve it on the other server too?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"ALI-R" <newbie@.microsoft.com> wrote in message
news:OkIHP4KCFHA.1392@.tk2msftngp13.phx.gbl...
> I got the following error when I try to luanch the report ,it is working
on
> another server with SP1 installed on it .Could it be the problem?(Not
havinf
> Sp1)
> The processing of filter expression for the chart "MyChart" cannot be
> performed. The comparison failed
> I removed the filter and it works,why this filter is working in the other
> server and not in this server.
> here is the filters that I use:
>
> =Fields!monthName.Value
> !=> Total
> Thanks
>|||I haven't had the chance to install SP1 yet,Do you think it might be
relevant?
Thanks
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23vIDaCOCFHA.268@.TK2MSFTNGP10.phx.gbl...
> Does installing SP1 resolve it on the other server too?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:OkIHP4KCFHA.1392@.tk2msftngp13.phx.gbl...
> > I got the following error when I try to luanch the report ,it is working
> on
> > another server with SP1 installed on it .Could it be the problem?(Not
> havinf
> > Sp1)
> >
> > The processing of filter expression for the chart "MyChart" cannot
be
> > performed. The comparison failed
> > I removed the filter and it works,why this filter is working in the
other
> > server and not in this server.
> > here is the filters that I use:
> >
> >
> > =Fields!monthName.Value
> > !=> > Total
> >
> > Thanks
> >
> >
>|||While there is no specific change for chart filters in SP1, there are some
improvements to make chart processing more efficient. Also from your
description, the same report with the same data works fine on the SP1
server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"ALI-R" <newbie@.microsoft.com> wrote in message
news:exH0YqUCFHA.2960@.TK2MSFTNGP14.phx.gbl...
> I haven't had the chance to install SP1 yet,Do you think it might be
> relevant?
> Thanks
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%23vIDaCOCFHA.268@.TK2MSFTNGP10.phx.gbl...
> > Does installing SP1 resolve it on the other server too?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "ALI-R" <newbie@.microsoft.com> wrote in message
> > news:OkIHP4KCFHA.1392@.tk2msftngp13.phx.gbl...
> > > I got the following error when I try to luanch the report ,it is
working
> > on
> > > another server with SP1 installed on it .Could it be the problem?(Not
> > havinf
> > > Sp1)
> > >
> > > The processing of filter expression for the chart "MyChart" cannot
> be
> > > performed. The comparison failed
> > > I removed the filter and it works,why this filter is working in the
> other
> > > server and not in this server.
> > > here is the filters that I use:
> > >
> > >
> > > =Fields!monthName.Value
> > > !=> > > Total
> > >
> > > Thanks
> > >
> > >
> >
> >
>|||Yes,It's working fine in the server with SP1.I willl let you know as soon as
I install SP1 and should the problem is solved.
Thanks
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:e9QjDfaCFHA.1936@.TK2MSFTNGP14.phx.gbl...
> While there is no specific change for chart filters in SP1, there are some
> improvements to make chart processing more efficient. Also from your
> description, the same report with the same data works fine on the SP1
> server.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:exH0YqUCFHA.2960@.TK2MSFTNGP14.phx.gbl...
> > I haven't had the chance to install SP1 yet,Do you think it might be
> > relevant?
> > Thanks
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > news:%23vIDaCOCFHA.268@.TK2MSFTNGP10.phx.gbl...
> > > Does installing SP1 resolve it on the other server too?
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "ALI-R" <newbie@.microsoft.com> wrote in message
> > > news:OkIHP4KCFHA.1392@.tk2msftngp13.phx.gbl...
> > > > I got the following error when I try to luanch the report ,it is
> working
> > > on
> > > > another server with SP1 installed on it .Could it be the
problem?(Not
> > > havinf
> > > > Sp1)
> > > >
> > > > The processing of filter expression for the chart "MyChart"
cannot
> > be
> > > > performed. The comparison failed
> > > > I removed the filter and it works,why this filter is working in the
> > other
> > > > server and not in this server.
> > > > here is the filters that I use:
> > > >
> > > >
> > > > =Fields!monthName.Value
> > > > !=> > > > Total
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > >
> >
> >
>

Repost : Custom tools

Hi
i am posting this message again.
We have the chart control. But i know that we can change the chart type dynamically. So is it posible that we can change the chart control dll and add some combobox along with it which will give the various types of chart. On selecting the type , the corresponding chart type would be shown.I mean to say can i add custom tool which will have the existing chart control of report designer and an extra combo box to select the type at runtime. MrRobert Bruckner [MSFT] has given one solution for that is to have multiple chart types and make any one visible based on some parameter. But then doing that the report will become very heavy.
Can some one throw some light on the approach i have put .
Or is this feature available in the SP1.
Thanks in advanceCombo boxes (or custom controls) are not available in a report. You could
have a set of hyperlinks that changed the type via a parameter. I'm not sure
why you mean it will become "very heavy".
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari" <Hari@.discussions.microsoft.com> wrote in message
news:15F6CB61-A8EE-484D-BE0E-6AAFD396BA76@.microsoft.com...
> Hi
> i am posting this message again.
> We have the chart control. But i know that we can change the chart type
dynamically. So is it posible that we can change the chart control dll and
add some combobox along with it which will give the various types of chart.
On selecting the type , the corresponding chart type would be shown.I mean
to say can i add custom tool which will have the existing chart control of
report designer and an extra combo box to select the type at runtime.
MrRobert Bruckner [MSFT] has given one solution for that is to have
multiple chart types and make any one visible based on some parameter. But
then doing that the report will become very heavy.
> Can some one throw some light on the approach i have put .
> Or is this feature available in the SP1.
> Thanks in advance|||Dynamic (expression-based) chart types will not be available in SP1. We
understand that having multiple charts side-by-side and only one visible at
runtime (based on parameter) will make the design more complex. However, the
impact at runtime is very limited because if chart instances are hidden, no
processing/rendering of the chart will happen.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari" <Hari@.discussions.microsoft.com> wrote in message
news:15F6CB61-A8EE-484D-BE0E-6AAFD396BA76@.microsoft.com...
> Hi
> i am posting this message again.
> We have the chart control. But i know that we can change the chart type
dynamically. So is it posible that we can change the chart control dll and
add some combobox along with it which will give the various types of chart.
On selecting the type , the corresponding chart type would be shown.I mean
to say can i add custom tool which will have the existing chart control of
report designer and an extra combo box to select the type at runtime.
MrRobert Bruckner [MSFT] has given one solution for that is to have
multiple chart types and make any one visible based on some parameter. But
then doing that the report will become very heavy.
> Can some one throw some light on the approach i have put .
> Or is this feature available in the SP1.
> Thanks in advance|||Thanks for the reply Brian, but my question was more of asking whether custom controls can be made or not.
And why i meant it heavy is that when the report is processing it will take more time since it has process data for two chart separetely and while showing it , it is showing only one but inside both the charts are processed. Even if we use hyperlinks we must have defferent chart for each type. Is it available in SP1.
"Brian Welcker [MSFT]" wrote:
> Combo boxes (or custom controls) are not available in a report. You could
> have a set of hyperlinks that changed the type via a parameter. I'm not sure
> why you mean it will become "very heavy".
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Hari" <Hari@.discussions.microsoft.com> wrote in message
> news:15F6CB61-A8EE-484D-BE0E-6AAFD396BA76@.microsoft.com...
> > Hi
> > i am posting this message again.
> >
> > We have the chart control. But i know that we can change the chart type
> dynamically. So is it posible that we can change the chart control dll and
> add some combobox along with it which will give the various types of chart.
> On selecting the type , the corresponding chart type would be shown.I mean
> to say can i add custom tool which will have the existing chart control of
> report designer and an extra combo box to select the type at runtime.
> MrRobert Bruckner [MSFT] has given one solution for that is to have
> multiple chart types and make any one visible based on some parameter. But
> then doing that the report will become very heavy.
> > Can some one throw some light on the approach i have put .
> > Or is this feature available in the SP1.
> > Thanks in advance
>
>