sql server reporting services: I am using Reporting Web services's render method to render report.There is
one report with huge number of data.I able to render report in TXT
format.Total file size of TXT file after rendering is 30 MB.When i am trying
to render same report with PDF format.It takes 2 hours to render and even
after that it shows below error
nThe request failed with the error message:\r\n--\r\n\r\n \r\n \r\n \r\n
\r\n\r\n \r\n\r\n
Server Error in '/ReportServer' Application.
Runtime Error.
Is there any limitation with size of data on Reporting web services because
same report working fine in PDF format by using URL?

No i just check again and i found that Report is getting fail even via URL.
After checking Reporting Server log.
I found below err. message

Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. ---> System.OutOfMemoryException: Exception of type
System.OutOfMemoryException was thrown.
w3wp!library!1308!07/26/2005-12:02:23:: e ERROR: Terminating worker process

What is limit of data to export or render ?



[quoted text, click to view]

Web service time out property is set to -1 . so there is no question of web
service time out.
After checking log file it's looks like that out of memory problem.
did u guys have any idea regarding size of report can be export or render
using reporting service ?



[quoted text, click to view]