Charts slow report rendering to a crawl

I've searched the forums on this issue, haven't really found the answer.

I have several nifty little sales reports which crunch a ton of data quite efficiently and render in just a few seconds in Report Manager. I've pushed as much of the data processing back to the server as possible, use a stored procedure (with parameters) in a shared datasource, don't return unneccessary data, all that. It works great.

When I first developed the reports, I continued generating my charts (which use the same data as the reports, just grouped differently) in Excel and pasting them in as images. Now I want to stop that nonsense and use the SSRS charts. I fooled around with the charting function and got a reasonable facimile of my Excel charts, two per report, which use their own separate stored procedures and the same shared datasource.

Now, reports that used to render in 5-8 seconds may take 1-5 MINUTES. Help! It's definitely the charts--taking them back out fixes the problem.

I have complete control over the datasources--would it make more sense to use non-shared sources, or to create totally separate shared sources? I saw a post that recommended "making data calls non-synchronous," but I have no idea how to do that.

Thanks for any suggestions.

On further investigation, it appears that deleting EITHER ONE of the charts brings the rendering time down almost to the same time as no chart at all. It's apparent that having MULTIPLE charts on a page multiplies the rendering time exponentially (I'm gonna tell Edward Tufte!)

This happens whether I put the charts side-by-side (preferred) or one above the other on the page--they just take FOREVER to render.

Anybody...?

|||

I know this post is a bit old but im having exactly the same problem.

I have a report that has around 150 charts on it once expanded and it is taking around 3 seconds to load each chart.

Is there a resolution for this?

Regards

Will

Charts slow report rendering to a crawl

I've searched the forums on this issue, haven't really found the answer.

I have several nifty little sales reports which crunch a ton of data quite efficiently and render in just a few seconds in Report Manager. I've pushed as much of the data processing back to the server as possible, use a stored procedure (with parameters) in a shared datasource, don't return unneccessary data, all that. It works great.

When I first developed the reports, I continued generating my charts (which use the same data as the reports, just grouped differently) in Excel and pasting them in as images. Now I want to stop that nonsense and use the SSRS charts. I fooled around with the charting function and got a reasonable facimile of my Excel charts, two per report, which use their own separate stored procedures and the same shared datasource.

Now, reports that used to render in 5-8 seconds may take 1-5 MINUTES. Help! It's definitely the charts--taking them back out fixes the problem.

I have complete control over the datasources--would it make more sense to use non-shared sources, or to create totally separate shared sources? I saw a post that recommended "making data calls non-synchronous," but I have no idea how to do that.

Thanks for any suggestions.

On further investigation, it appears that deleting EITHER ONE of the charts brings the rendering time down almost to the same time as no chart at all. It's apparent that having MULTIPLE charts on a page multiplies the rendering time exponentially (I'm gonna tell Edward Tufte!)

This happens whether I put the charts side-by-side (preferred) or one above the other on the page--they just take FOREVER to render.

Anybody...?

Charts not rendering

Hi, this is a pretty vague post but hopefully someone will be able to help.
I've recently experienced some problems where the charts wouldn't render at
all and the standard IE broken image X would display. Refreshing the page
doesn't help and neither does reopening the report. I have a feeling that
it might be IIS or the server itself...has anyone else experienced this and,
if applicable, what did you do to solve it?Did you look at this posting?
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=26004e9b-814f-465d-9c62-98813d8d7a3c&sloc=en-us
Also, does the hostname contain certain characters (like underscores?) -
then you might run into:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;275033
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Casey Rosing" <casey@.climark.com> wrote in message
news:eVUdCSnpEHA.132@.TK2MSFTNGP14.phx.gbl...
> Hi, this is a pretty vague post but hopefully someone will be able to
help.
> I've recently experienced some problems where the charts wouldn't render
at
> all and the standard IE broken image X would display. Refreshing the page
> doesn't help and neither does reopening the report. I have a feeling that
> it might be IIS or the server itself...has anyone else experienced this
and,
> if applicable, what did you do to solve it?
>

Chart rendering problem

Hi
I have a report that has a chart also. When I try to
render the report the chart that is supposed to be
displayed as a picture does not show up and there is some
junk text right after the chart area.
Can anyone please tell me what can be wrong here.
The chart shows up perfectly in the preview and also on
the report manager.
Thanks a lotI have posted a similar questions but I did not get any answer. My reports
show perfectly fine when I use http:// servername/reportserver to view the
reports. all images and charts show. But when I used
http://servername/reports to view the reports, all images and charts
disappear, other data table in the same report looks fine. Please help.
Thanks.
<anonymous@.discussions.microsoft.com> wrote in message
news:7e3e01c484e9$8101c600$a501280a@.phx.gbl...
> Hi
> I have a report that has a chart also. When I try to
> render the report the chart that is supposed to be
> displayed as a picture does not show up and there is some
> junk text right after the chart area.
> Can anyone please tell me what can be wrong here.
> The chart shows up perfectly in the preview and also on
> the report manager.
> Thanks a lot
>

Chart and image rendering problem

Hello,
Has anybody found a solution to the problem where images and charts doesn't
show when the report is opened from ../Reports, but is OK in Visual Studio,
../Reportserver and in subscriptions?
Best regards,
VemundPlease check this related posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=628a4607-e2b1-49ad-ad0b-37f3c2f148d9&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vemund Haga" <vemund.haga@.nospam.nospam> wrote in message
news:uDYyXUYlEHA.3760@.TK2MSFTNGP12.phx.gbl...
> Hello,
> Has anybody found a solution to the problem where images and charts
doesn't
> show when the report is opened from ../Reports, but is OK in Visual
Studio,
> ../Reportserver and in subscriptions?
>
> Best regards,
> Vemund
>|||Hello,
Many thanks for the answer.
The solution to my problem was to disable the use of session cookies by
modifying the ConfigurationInfo table. Even though I was already using the
IP address in the configuration files, all images and charts are now
displaying correctly from the Report Manager.
Best regards,
Vemund
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:e4xg3hulEHA.3760@.TK2MSFTNGP12.phx.gbl...
> Please check this related posting:
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=628a4607-e2b1-49ad-ad0b-37f3c2f148d9&sloc=en-us
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Vemund Haga" <vemund.haga@.nospam.nospam> wrote in message
> news:uDYyXUYlEHA.3760@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> Has anybody found a solution to the problem where images and charts
> doesn't
>> show when the report is opened from ../Reports, but is OK in Visual
> Studio,
>> ../Reportserver and in subscriptions?
>>
>> Best regards,
>> Vemund
>>
>|||i was having the same problem and i had an underscore in
my server name once i removed the underscore the images
and charts all showed up but some of them were not lined
up as they were in visual studio
>--Original Message--
>Hello,
>Has anybody found a solution to the problem where images
and charts doesn't
>show when the report is opened from ../Reports, but is OK
in Visual Studio,
>.../Reportserver and in subscriptions?
>
>Best regards,
>Vemund
>
>.
>