Does chart support more than 800 points?

I'm using SQL Server 2000 Reporting Services. I want to create a curve using
chart for a series of data.
If the number of points (x axis) is small (less than 800), the curve is
displayed correctly.
But if the number of points is more than 800, the curve cannot come out,
after about 1 minute, in the "Event Viewer" of the server, I find a system
warning:
"A process serving application pool 'DefaultAppPool' suffered a fatal
communication error with the World Wide Web Publishing Service. The process
id was '22656'. The data field contains the error number(8007006d). "
Anyone could give me a solution to fix it? ThanksIn the log file of reporting service, I find an exception of Out of Memory:
w3wp!processing!2afc!2006-6-30-15:38:29:: e ERROR:
System.OutOfMemoryException: Out of memory.
at System.Drawing.Graphics.CheckErrorStatus(Int32 status)
at System.Drawing.Graphics.DrawCurve(Pen pen, PointF[] points, Int32
offset, Int32 numberOfSegments, Single tension)
at Dundas.Charting.WebControl.GdiGraphics.DrawCurve(Pen pen, PointF[]
points, Int32 offset, Int32 numberOfSegments, Single tension)
at Dundas.Charting.WebControl.ChartTypes.LineChart.DrawLine(ChartGraphics
graph, CommonElements common, DataPoint point, Series series, PointF[]
points, Int32 pointIndex, Single tension)
at
Dundas.Charting.WebControl.ChartTypes.LineChart.ProcessChartType(Boolean
selection, ChartGraphics graph, CommonElements common, ChartArea area, Series
seriesToDraw)
at Dundas.Charting.WebControl.ChartTypes.LineChart.Paint(ChartGraphics
graph, CommonElements common, ChartArea area, Series seriesToDraw)
at Dundas.Charting.WebControl.ChartArea.Paint(ChartGraphics graph)
at Dundas.Charting.WebControl.ChartPicture.Paint(Graphics graph, Boolean
cursorsOnly, Boolean svgMode, XmlTextWriter svgTextWriter, String
documentTitle, Boolean resizable, Boolean preserveAspectRatio)
at Dundas.Charting.WebControl.ChartImage.GetImage()
at Dundas.Charting.WebControl.Chart.Save(Stream imageStream)
at
Microsoft.ReportingServices.ReportRendering.DundasChart.GetImage(ImageType
type, Boolean& hasImageMap)
at
Microsoft.ReportingServices.ReportRendering.DundasChart.GetImage(ImageType
type, ChartInstanceInfo instanceInfo, Boolean& hasImageMap)
at Microsoft.ReportingServices.ReportRendering.Chart.GetImage(ImageType
type, Boolean& hasImageMap)
w3wp!processing!2afc!2006-6-30-15:38:29:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
error has occurred during rendering of chart chart1. Details: Out of memory.,
;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
error has occurred during rendering of chart chart1. Details: Out of memory.
--> System.OutOfMemoryException: Out of memory.
at System.Drawing.Graphics.CheckErrorStatus(Int32 status)
at System.Drawing.Graphics.DrawCurve(Pen pen, PointF[] points, Int32
offset, Int32 numberOfSegments, Single tension)
at Dundas.Charting.WebControl.GdiGraphics.DrawCurve(Pen pen, PointF[]
points, Int32 offset, Int32 numberOfSegments, Single tension)
at Dundas.Charting.WebControl.ChartTypes.LineChart.DrawLine(ChartGraphics
graph, CommonElements common, DataPoint point, Series series, PointF[]
points, Int32 pointIndex, Single tension)
at
Dundas.Charting.WebControl.ChartTypes.LineChart.ProcessChartType(Boolean
selection, ChartGraphics graph, CommonElements common, ChartArea area, Series
seriesToDraw)
at Dundas.Charting.WebControl.ChartTypes.LineChart.Paint(ChartGraphics
graph, CommonElements common, ChartArea area, Series seriesToDraw)
at Dundas.Charting.WebControl.ChartArea.Paint(ChartGraphics graph)
at Dundas.Charting.WebControl.ChartPicture.Paint(Graphics graph, Boolean
cursorsOnly, Boolean svgMode, XmlTextWriter svgTextWriter, String
documentTitle, Boolean resizable, Boolean preserveAspectRatio)
at Dundas.Charting.WebControl.ChartImage.GetImage()
at Dundas.Charting.WebControl.Chart.Save(Stream imageStream)
at
Microsoft.ReportingServices.ReportRendering.DundasChart.GetImage(ImageType
type, Boolean& hasImageMap)
at
Microsoft.ReportingServices.ReportRendering.DundasChart.GetImage(ImageType
type, ChartInstanceInfo instanceInfo, Boolean& hasImageMap)
at Microsoft.ReportingServices.ReportRendering.Chart.GetImage(ImageType
type, Boolean& hasImageMap)
-- End of inner exception stack trace --
w3wp!reportrendering!2afc!06/30/2006-15:38:34:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
error has occurred during rendering of chart chart1. Details: Out of memory.
--> System.OutOfMemoryException: Out of memory.
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
w3wp!library!2afc!06/30/2006-15:38:34:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!2afc!06/30/2006-15:38:49:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Exception of
type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
error has occurred during rendering of chart chart1. Details: Out of memory.
--> System.OutOfMemoryException: Out of memory.
w3wp!library!7c40!6/30/2006-15:38:51:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!2afc!06/30/2006-15:39:09:: e ERROR: Found
System.OutOfMemoryException exception:
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Exception of
type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
error has occurred during rendering of chart chart1. Details: Out of memory.
--> System.OutOfMemoryException: Out of memory.
w3wp!library!2afc!06/30/2006-15:39:09:: e ERROR: Terminating worker process
How to avoid the out of memory? Thanks
"Jun Yuan" wrote:
> I'm using SQL Server 2000 Reporting Services. I want to create a curve using
> chart for a series of data.
> If the number of points (x axis) is small (less than 800), the curve is
> displayed correctly.
> But if the number of points is more than 800, the curve cannot come out,
> after about 1 minute, in the "Event Viewer" of the server, I find a system
> warning:
> "A process serving application pool 'DefaultAppPool' suffered a fatal
> communication error with the World Wide Web Publishing Service. The process
> id was '22656'. The data field contains the error number(8007006d). "
> Anyone could give me a solution to fix it? Thanks
>

document mapping

I have a report which has two items- chart and a matrix, both uses same
datasets and produces same results. I want to give an option to user to
choose between chart and matrix. I was thinking to use document mapping.
But i can't create bookmarkID, or document map on chart or matrix name, it
only gives option to use available fields from dataset. I end up using two
dummy text box linking them to chart and matrix having chart and matrix
hidden initially. I don't like this. Is there any other option?
Thanks
vipulYou could create a parameter, that the user could choose chart or matrix,
and you could change the visibility of both based on the parameters..
Visibility for chart
=Iif(Parameters!ReportType.Value) = 1,False, True)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Vipul Shah" <VipulShah@.discussions.microsoft.com> wrote in message
news:C045C009-F5C2-4081-A0EE-0DFFF8245031@.microsoft.com...
> I have a report which has two items- chart and a matrix, both uses same
> datasets and produces same results. I want to give an option to user to
> choose between chart and matrix. I was thinking to use document mapping.
> But i can't create bookmarkID, or document map on chart or matrix name, it
> only gives option to use available fields from dataset. I end up using
two
> dummy text box linking them to chart and matrix having chart and matrix
> hidden initially. I don't like this. Is there any other option?
> Thanks
> vipul