Showing posts with label specific. Show all posts
Showing posts with label specific. Show all posts

Saturday, February 25, 2012

close

Below, I have pasted a portion of an MS MSDN article dealing with a specific issue we are having with Report Server performance. The URL (http://support.microsoft.com/kb/821438/en-us) is the MS KB article on the described fix. The fix mentioned is for "ASP.NET 1.1" but our BP Report Server is using "ASP.NET 2.0".


Has anyone encountered and resolved and how?

Running on box:
ASP.NET 2.0.50727;
SSRS 2005 Sp1 + Hotfix#2175;
Win Server 2003, R2, x64, SP1
Trend Micro OfficeScan Cleint for Win 2003/xp v7.3
IIS Version (I cannot find this #) - ? IE 6.0

===========================
Report Manager or the report server runs very slowly

In some circumstances, ASP.NET applications run very slowly on computers that are running anti-virus software. If the Report Server Web service is restarting frequently, and you are running anti-virus software, you can obtain an ASP.NET fix from Microsoft Customer Support Services.

Symptoms include Web applications or Application Domains restarting for no apparent reason, slow performance, session restarts, and more. For more information about the symptoms, cause, and resolution, see Microsoft Knowledge Base article 821438.

You can find out whether there are excessive server restarts by viewing the number of reportserver_<timestamp>.log files. A new log is created each time the server starts. A large collection of logs created at very short intervals is an indication that the conditions described in article 821438 exist on your server
===========================

It appears the issue goes away with SQL2K5 SP-2 load. Thanks to whoever..... Wink

Sunday, February 12, 2012

Clickable charts/graphs?

Hi all,
in Crystal reports it is possible to create a chart that you can click on
(i.e. specific bars within the chart) which then lead to a different section
of the report. Is this possible with SSRS?
Thanks
TazYes using "Action" option.
Amarnath
"Tarun Mistry" wrote:
> Hi all,
> in Crystal reports it is possible to create a chart that you can click on
> (i.e. specific bars within the chart) which then lead to a different section
> of the report. Is this possible with SSRS?
> Thanks
> Taz
>
>|||thanks for the response. It took me a little while to find the setting.
Would you also know of a quick way of re-rendering the graph on a further
restricted dataset?
kind regards
Taz
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:7E263DF9-A273-4E4D-A458-BCAA0BA1EA51@.microsoft.com...
> Yes using "Action" option.|||What do you mean by re-rendering. Something like drillthrough from graphs to
again displaying graphs.. something like that.
Amarnath
"Tarun Mistry" wrote:
> thanks for the response. It took me a little while to find the setting.
> Would you also know of a quick way of re-rendering the graph on a further
> restricted dataset?
> kind regards
> Taz
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:7E263DF9-A273-4E4D-A458-BCAA0BA1EA51@.microsoft.com...
> > Yes using "Action" option.
>
>|||Yes, if thats possible.
Imagine...
Graph 1 Displayed showing summary of data.
User click "Bar 2".
Graph redisplayed showing data specific to Bar 2. This required the
group/filter to be altered slightly.
Is something like this possible?
Kind Regards
Taz
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:7889B050-E641-4D14-ADB0-68B542A0BF29@.microsoft.com...
> What do you mean by re-rendering. Something like drillthrough from graphs
> to
> again displaying graphs.. something like that.
> Amarnath
> "Tarun Mistry" wrote:
>> thanks for the response. It took me a little while to find the setting.
>> Would you also know of a quick way of re-rendering the graph on a further
>> restricted dataset?
>> kind regards
>> Taz
>> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
>> news:7E263DF9-A273-4E4D-A458-BCAA0BA1EA51@.microsoft.com...
>> > Yes using "Action" option.
>>