Charts don't update when using dropdown parameters

I have recently upgraded from RS2000 to RS2005. The reports seem to have
converted without any errors. In the report designer, everything works fine.
When deploying to the server the reports don't update properly.
Details:
The reports have two components (a table and a chart) - both are based on
the same query. There are three parameters in a report. One is a dropdown
box that includes a list of products based on a subquery. The other two
parameters are textboxes that provide start and end months for the reporting
period. When changing either of the month parameters, the table and chart
updates with proper data. When changing the product (dropdown box), the
table information updates, but the chart does not (it still includes the
title and data from the previous update when a month was changed; or it
includes the results of the first query if a month was not changed).
Has anyone experienced anything like this? Is there a fix?Hello Piell,
I tested on my side and do not reproduce this issue.
Also, I did not find any related issue in our internal database.
I would like to know if this issue appeared on all reports?
If you apply SP1 on your SSRS 2005, does this issue persist?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Wei,
We have the same problem on all reports and we have even deleted the chart
and re-created it and get the same results. I will be checking with the
admins later today to find out if SP1 has been applied. If it hasn't, we
will have them update it.
Thanks.|||Wei,
We have installed SQL 2005 SP1 and still have the same problem. Would the
available hot fix help
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/rs2005-kb918222-x86-enu.exe|||We installed hot fix and charts still don't update when dropdown parameter
changes.|||Hello piell,
I would like to suggest you to check your IE security setting and try to
set the security level to low.
If this issue still persist, would you please send a sample report to me so
that I could try to reproduce this issue on my side.
To reach me, please remove the ONLINE in my email address.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Chart Question: Number of Bars on X-axis

Hi Guys,
Is there any way, we can set the number of Bars on X-axis per Page (in a
Column Chart) in Report Designer?
All I want to do is set no of Bars per page so that a new page is created if
the number of bars on the X-axis exceeds the given value..
Any help is appreciated..
Regards
Raj ChidipudiThis is not natively supported in RS2000.
Depending on your actual data, you may be able to use filters on the first
chart and dynamically show/hide additional charts (with page breaks) if the
number of bars is too high for the first chart.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj Chidipudi" <someone@.email.com> wrote in message
news:Ok9QsdbmEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hi Guys,
> Is there any way, we can set the number of Bars on X-axis per Page (in a
> Column Chart) in Report Designer?
> All I want to do is set no of Bars per page so that a new page is created
if
> the number of bars on the X-axis exceeds the given value..
> Any help is appreciated..
> Regards
> Raj Chidipudi
>

Chart i blurring in IE

Hi,
I created a chart through the reporting services. The chart is very clear if
I preview it throguh the Report Designer. However, it is very blurring when I
view the report through the Report Manager or Internet Explorer.
Any ideas about this problem?
Thanks,
DavidAre just the fonts in the chart "blurring" when shown in IE? If that is the
case, then most likely, the report server machine has "ClearType" turned on
(Control Panel - Display - Appearance - Effects). Does turning ClearType off
improve it?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"David" <wei.liu@.powerinfonet.com> wrote in message
news:CB3F80F8-1630-4C36-8C67-1745E888B51A@.microsoft.com...
> Hi,
> I created a chart through the reporting services. The chart is very clear
> if
> I preview it throguh the Report Designer. However, it is very blurring
> when I
> view the report through the Report Manager or Internet Explorer.
> Any ideas about this problem?
> Thanks,
> David|||Hi, Robert:
Thank you very much for your information. I tried ClearType and it does not
work in my case. I am using URL to access the report. If I set the
HTMLFragment to true, I get a much better quality chart report.
I have another question. Right now I have multiple reports in one HTML page.
Therefore, each report has its own horizontal frame. Is it possible to set
all reports have one horizontal frame?
Thank you for your kind help,
Best regards,
Favid
"Robert Bruckner [MSFT]" wrote:
> Are just the fonts in the chart "blurring" when shown in IE? If that is the
> case, then most likely, the report server machine has "ClearType" turned on
> (Control Panel - Display - Appearance - Effects). Does turning ClearType off
> improve it?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "David" <wei.liu@.powerinfonet.com> wrote in message
> news:CB3F80F8-1630-4C36-8C67-1745E888B51A@.microsoft.com...
> > Hi,
> >
> > I created a chart through the reporting services. The chart is very clear
> > if
> > I preview it throguh the Report Designer. However, it is very blurring
> > when I
> > view the report through the Report Manager or Internet Explorer.
> >
> > Any ideas about this problem?
> >
> > Thanks,
> >
> > David
>
>