Showing posts with label exporting. Show all posts

Friday, March 30, 2012

Problem in generating Excel worksheets

In the Report Designer, I insert some page breaks after data regions. When
exporting to excel format, the pages are displayed as several worksheets in
the excel. But I found no way to specify the name of worksheet in Report
Designer.Is there any ways to do that?
Thanks.There is no way to specify the name of the worksheet when exporting your
report. When exporting to excel, page breaks after a data region on your
report are interepreted as a new worksheet. I'm not sure if this is on the
wishlist or this capability will be included in RS 2005.
"Johnny Chow" wrote:
> In the Report Designer, I insert some page breaks after data regions. When
> exporting to excel format, the pages are displayed as several worksheets in
> the excel. But I found no way to specify the name of worksheet in Report
> Designer.Is there any ways to do that?
> Thanks.

Problem in exporting Report with multiline textbox to Excel

Hi,

I am facing a problem while exporting reports to Excel.
My report contains a multilined textbox - which is displayed correctly in Report Design.

Following is code of report Statistics contents to be displayed in a textbox: ="Report Statistics " & vbcrlf & "Date : " & Format(Globals!ExecutionTime, "MMM dd yyyy tt”) & vbcrlf & "By : " & User!UserID

Problem Description: In Excel - one extra line is added between each line

Sample output of report exported in Ms Excel 2003:

Report Statistics

Date : Jun 12 2006

Time : 6:53:23 PM

By : COMPANY\EMP ID

Correct Output Required:

Report Statistics

Date : Jun 12 2006

Time : 6:53:23 PM

By : SERWIZSOL\P97006

Configuration:
Microsoft SQL Server 2000 SP3
Microsoft SQL Reporting Services 2000 SP2

If some one is facing similar problem or knows the solution, please let me know.

Thanks in Advance.
Regards,
Abhijeet

Hi Abhijeet,

I tried your expression ="Report Statistics " & vbcrlf & "Date : " & Format(Globals!ExecutionTime,"MMM dd yyyy tt") & vbcrlf & "By : " & User!UserID

Everything worked fine for me. I added a text box and set the expression to above text and it works perfectly. Was there anything else you were doing?

Wednesday, March 28, 2012

Problem in Exporting Crystal Reports

Hi All,
I have been using Crystal Reports 8.5 with VB6.0.
I want to set the Export options through VB code.
But when I call the Export method ,the settings whatever I made is not active,it is displaying the default settings only.
How to resolve this?

Thanks in Advance for all helps!

Regards,
Muthukumar.CThere are plenty of articles in Business Objects knowledge base about how to export reports using various interfaces:
http://support.businessobjects.com/library/kbase/articles/c2010117.asp
http://support.businessobjects.com/communityCS/FilesAndUpdates/autexprt.zip.asp

Be sure to always check the knowledge base before posting to forum. In most cases, you will find the solution much faster than you expect.

Tuesday, March 20, 2012

problem exporting views

While exporting a database with "export > objects > selecting the views"
I get the error:
Invalid object name 'dbo.myview'
The weird thing is that this view allready exists in the destination dbase.
Any help appreciated.
THX"nicholas" <murmurait1@.hotmail.com> wrote in
news:Ol2emWkgFHA.1948@.TK2MSFTNGP12.phx.gbl:
> While exporting a database with "export > objects > selecting the
> views" I get the error:
> Invalid object name 'dbo.myview'
> The weird thing is that this view allready exists in the destination
> dbase.
> Any help appreciated.
> THX
>
>
Run the following query in your user database. What are the results?
select t1.name, t2.name
from sysobjects t1, sysusers t2
where t1.name = 'myview' and t1.uid = t2.uid
--
Regards
JTC ^..^|||Sorry to ask, but how can I do this?
I tried the SQL query analyser and inserted:
select t1.name, t2.name
from sysobjects t1, sysusers t2
where t1.name = [mydatabase].[dbo].[tbl_customers] and t1.uid = t2.uid
but get this message:
Server: Msg 107, Level 16, State 2, Line 1
The column prefix 'mydatabase.dbo' does not match with a table name or alias
name used in the query
thx a lot
"JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
news:Xns968BC0C2DE4E1daveJTC@.213.123.26.234...
> "nicholas" <murmurait1@.hotmail.com> wrote in
> news:Ol2emWkgFHA.1948@.TK2MSFTNGP12.phx.gbl:
> > While exporting a database with "export > objects > selecting the
> > views" I get the error:
> > Invalid object name 'dbo.myview'
> >
> > The weird thing is that this view allready exists in the destination
> > dbase.
> >
> > Any help appreciated.
> >
> > THX
> >
> >
> >
> Run the following query in your user database. What are the results?
> select t1.name, t2.name
> from sysobjects t1, sysusers t2
> where t1.name = 'myview' and t1.uid = t2.uid
> --
> Regards
> JTC ^..^|||You are supposed to replace "mydatabase" with the name of your database. And "myview" with the name
of your view.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"nicholas" <murmurait1@.hotmail.com> wrote in message news:OcWsU$lgFHA.4000@.TK2MSFTNGP12.phx.gbl...
> Sorry to ask, but how can I do this?
> I tried the SQL query analyser and inserted:
> select t1.name, t2.name
> from sysobjects t1, sysusers t2
> where t1.name = [mydatabase].[dbo].[tbl_customers] and t1.uid = t2.uid
> but get this message:
> Server: Msg 107, Level 16, State 2, Line 1
> The column prefix 'mydatabase.dbo' does not match with a table name or alias
> name used in the query
> thx a lot
> "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
> news:Xns968BC0C2DE4E1daveJTC@.213.123.26.234...
>> "nicholas" <murmurait1@.hotmail.com> wrote in
>> news:Ol2emWkgFHA.1948@.TK2MSFTNGP12.phx.gbl:
>> > While exporting a database with "export > objects > selecting the
>> > views" I get the error:
>> > Invalid object name 'dbo.myview'
>> >
>> > The weird thing is that this view allready exists in the destination
>> > dbase.
>> >
>> > Any help appreciated.
>> >
>> > THX
>> >
>> >
>> >
>> Run the following query in your user database. What are the results?
>> select t1.name, t2.name
>> from sysobjects t1, sysusers t2
>> where t1.name = 'myview' and t1.uid = t2.uid
>> --
>> Regards
>> JTC ^..^
>|||Yes, ofcourse, I did that.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u%23d$xEmgFHA.2472@.TK2MSFTNGP15.phx.gbl...
> You are supposed to replace "mydatabase" with the name of your database.
And "myview" with the name
> of your view.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "nicholas" <murmurait1@.hotmail.com> wrote in message
news:OcWsU$lgFHA.4000@.TK2MSFTNGP12.phx.gbl...
> > Sorry to ask, but how can I do this?
> > I tried the SQL query analyser and inserted:
> >
> > select t1.name, t2.name
> > from sysobjects t1, sysusers t2
> > where t1.name = [mydatabase].[dbo].[tbl_customers] and t1.uid = t2.uid
> >
> > but get this message:
> > Server: Msg 107, Level 16, State 2, Line 1
> > The column prefix 'mydatabase.dbo' does not match with a table name or
alias
> > name used in the query
> >
> > thx a lot
> >
> > "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
> > news:Xns968BC0C2DE4E1daveJTC@.213.123.26.234...
> >> "nicholas" <murmurait1@.hotmail.com> wrote in
> >> news:Ol2emWkgFHA.1948@.TK2MSFTNGP12.phx.gbl:
> >>
> >> > While exporting a database with "export > objects > selecting the
> >> > views" I get the error:
> >> > Invalid object name 'dbo.myview'
> >> >
> >> > The weird thing is that this view allready exists in the destination
> >> > dbase.
> >> >
> >> > Any help appreciated.
> >> >
> >> > THX
> >> >
> >> >
> >> >
> >>
> >> Run the following query in your user database. What are the results?
> >>
> >> select t1.name, t2.name
> >> from sysobjects t1, sysusers t2
> >> where t1.name = 'myview' and t1.uid = t2.uid
> >>
> >> --
> >> Regards
> >> JTC ^..^
> >
> >
>|||"nicholas" <murmurait1@.hotmail.com> wrote in
news:OQwceImgFHA.3256@.TK2MSFTNGP12.phx.gbl:
> Yes, ofcourse, I did that.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> wrote in message news:u%23d$xEmgFHA.2472@.TK2MSFTNGP15.phx.gbl...
>> You are supposed to replace "mydatabase" with the name of your
>> database.
> And "myview" with the name
>> of your view.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "nicholas" <murmurait1@.hotmail.com> wrote in message
> news:OcWsU$lgFHA.4000@.TK2MSFTNGP12.phx.gbl...
>> > Sorry to ask, but how can I do this?
>> > I tried the SQL query analyser and inserted:
>> >
>> > select t1.name, t2.name
>> > from sysobjects t1, sysusers t2
>> > where t1.name = [mydatabase].[dbo].[tbl_customers] and t1.uid =>> > t2.uid
>> >
>> > but get this message:
>> > Server: Msg 107, Level 16, State 2, Line 1
>> > The column prefix 'mydatabase.dbo' does not match with a table name
>> > or
> alias
>> > name used in the query
>> >
>> > thx a lot
>> >
>> > "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
>> > news:Xns968BC0C2DE4E1daveJTC@.213.123.26.234...
>> >> "nicholas" <murmurait1@.hotmail.com> wrote in
>> >> news:Ol2emWkgFHA.1948@.TK2MSFTNGP12.phx.gbl:
>> >>
>> >> > While exporting a database with "export > objects > selecting
>> >> > the views" I get the error:
>> >> > Invalid object name 'dbo.myview'
>> >> >
>> >> > The weird thing is that this view allready exists in the
>> >> > destination dbase.
>> >> >
>> >> > Any help appreciated.
>> >> >
>> >> > THX
>> >> >
>> >> >
>> >> >
>> >>
>> >> Run the following query in your user database. What are the
>> >> results?
>> >>
>> >> select t1.name, t2.name
>> >> from sysobjects t1, sysusers t2
>> >> where t1.name = 'myview' and t1.uid = t2.uid
>> >>
>> >> --
>> >> Regards
>> >> JTC ^..^
>> >
>> >
>
Like this...
select t1.name, t2.name
from sysobjects t1, sysusers t2
where t1.name = 'tbl_customers' and t1.uid = t2.uid
The idea is that the query will returns all tables named tbl_customers
along with the table owners. Please Copy and Paste the results.
--
Regards
JTC ^..^|||Go back to the proposed query, and fix below things:
Do not remove the quotes around the name of the view in the WHERE clause. Do not fully qualify the
object name in the where clause.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"nicholas" <murmurait1@.hotmail.com> wrote in message news:OQwceImgFHA.3256@.TK2MSFTNGP12.phx.gbl...
> Yes, ofcourse, I did that.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:u%23d$xEmgFHA.2472@.TK2MSFTNGP15.phx.gbl...
>> You are supposed to replace "mydatabase" with the name of your database.
> And "myview" with the name
>> of your view.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "nicholas" <murmurait1@.hotmail.com> wrote in message
> news:OcWsU$lgFHA.4000@.TK2MSFTNGP12.phx.gbl...
>> > Sorry to ask, but how can I do this?
>> > I tried the SQL query analyser and inserted:
>> >
>> > select t1.name, t2.name
>> > from sysobjects t1, sysusers t2
>> > where t1.name = [mydatabase].[dbo].[tbl_customers] and t1.uid = t2.uid
>> >
>> > but get this message:
>> > Server: Msg 107, Level 16, State 2, Line 1
>> > The column prefix 'mydatabase.dbo' does not match with a table name or
> alias
>> > name used in the query
>> >
>> > thx a lot
>> >
>> > "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
>> > news:Xns968BC0C2DE4E1daveJTC@.213.123.26.234...
>> >> "nicholas" <murmurait1@.hotmail.com> wrote in
>> >> news:Ol2emWkgFHA.1948@.TK2MSFTNGP12.phx.gbl:
>> >>
>> >> > While exporting a database with "export > objects > selecting the
>> >> > views" I get the error:
>> >> > Invalid object name 'dbo.myview'
>> >> >
>> >> > The weird thing is that this view allready exists in the destination
>> >> > dbase.
>> >> >
>> >> > Any help appreciated.
>> >> >
>> >> > THX
>> >> >
>> >> >
>> >> >
>> >>
>> >> Run the following query in your user database. What are the results?
>> >>
>> >> select t1.name, t2.name
>> >> from sysobjects t1, sysusers t2
>> >> where t1.name = 'myview' and t1.uid = t2.uid
>> >>
>> >> --
>> >> Regards
>> >> JTC ^..^
>> >
>> >
>

Problem Exporting to PDF - TRIED EVERYTHING (almost)

OK.. The newest member so go slow with me (normally do male modelling.. ;) )

Anyway. Using Crystal Reports 8.0 and VB6. It "exports" from VB6 to The Crystal Report Viewer 8.5. I then try to use the export button and it will export to RTF and Text BUT not to PDF. It will not export from the Viewer OR the actual program.

I have copied all relevant DLL's into Windows\crystal on the PC. These were u2fpdf.dll, u2ddisk.dll. There is no need to Regsvr32 them as they will not go in anyway.

I have also put them in windows\system32 just for good measure as well as program files/common files/crystal decisions/1.0/bin/*. I have tryed downloading different versions of these DLL's but it has made no difference.

I even installed Adobe Acrobat Writer as I thought this might make a difference but it has not.

ANY HELP would be appreciated as firstly I can't spell... and secondly I don't really know what I am doing.. I'm finishing off someone elses project...

Cheers

KirbanWhich OS are you using? CrViewer requires different dll's to Windows98 and earlier OS's. With XP you must use crxf_pdf.dll instead u2fpdf.dll and be sure to register your exportmodeller.dll after you insert the dll.

In one rare occasion I had to rename crxf_pdf.dll to u2fpdf.dll in order to get the client machine working.

Problem exporting to pdf

When I export a report to pdf I sometimes get the error 'There was an error
opening the document. The file is damaged and could not be repaired.' When I
give different parametervalues there is no problem with the export (of the
same report).
I examined the created pdf-file (with notepad) and noticed that at the end
there is the html-code for the following errormessage: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError); Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.; Index was out of range. Must be non-negative and less than the size
of the collection. Parameter name: indexThis may have already been fixed - make sure you have installed SP1.
If it is happening on an SP1 machine, please email me a copy of your .pdf,
.rdl, and .rdl.data so I can take a look.
Thank you.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"kabouterman" <kabouterman@.discussions.microsoft.com> wrote in message
news:DCC8F9A1-E00E-473A-9A95-37ADBF497649@.microsoft.com...
> When I export a report to pdf I sometimes get the error 'There was an
> error
> opening the document. The file is damaged and could not be repaired.' When
> I
> give different parametervalues there is no problem with the export (of the
> same report).
> I examined the created pdf-file (with notepad) and noticed that at the end
> there is the html-code for the following errormessage: Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError); Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.; Index was out of range. Must be non-negative and less than the
> size
> of the collection. Parameter name: index|||When I tried the export again there was no longer a problem with the pdf-file.
SP1 was already installed.

Problem exporting to PDF

Hello everybody,
I can't render a report to PDF
and I get the following error :
"Internet Explorer cannot download Format=PDF from server
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or canot be found. Please try again later."
What it's weird is that other reports rendered to PDF, but this one!
Thanks for your help.
DomenicoWhat error do you see in the log file in your /ReportServer/LogFiles
directory? There should be a stack trace in there that you can will give us
more information.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riddick" <Riddick@.discussions.microsoft.com> wrote in message
news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> Hello everybody,
> I can't render a report to PDF
> and I get the following error :
> "Internet Explorer cannot download Format=PDF from server
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or canot be found. Please try again later."
> What it's weird is that other reports rendered to PDF, but this one!
> Thanks for your help.
> Domenico
>|||I thank you for your help.
Domenico
here below the stack trace of the error :
aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting Services
error
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. --> System.ArgumentOutOfRangeException: Index and length must refer
to a location within the string.
Parameter name: length
at System.String.Substring(Int32 startIndex, Int32 length)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double left,
Double top, Double paddingTop, Double width, Double height, Boolean wordTrim,
String fontLanguage, Int32& charactersFitted, Int32& linesFilled, String&
streamString)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
context, OutlineObjects outlines, Boolean wordTrim, String text, CanvasFont
font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effecectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
"Donovan Smith [MSFT]" wrote:
> What error do you see in the log file in your /ReportServer/LogFiles
> directory? There should be a stack trace in there that you can will give us
> more information.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> > Hello everybody,
> > I can't render a report to PDF
> > and I get the following error :
> >
> > "Internet Explorer cannot download Format=PDF from server
> > Internet Explorer was not able to open this Internet site. The requested
> > site is either unavailable or canot be found. Please try again later."
> >
> > What it's weird is that other reports rendered to PDF, but this one!
> >
> > Thanks for your help.
> > Domenico
> >
> >
>
>|||Please email me a copy of your .rdl and .rdl.data file. I'm curious why
you're hitting that.
Thank you.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riddick" <Riddick@.discussions.microsoft.com> wrote in message
news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
> I thank you for your help.
> Domenico
> here below the stack trace of the error :
> aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting Services
> error
> 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. --> System.ArgumentOutOfRangeException: Index and length must
> refer
> to a location within the string.
> Parameter name: length
> at System.String.Substring(Int32 startIndex, Int32 length)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
> context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double left,
> Double top, Double paddingTop, Double width, Double height, Boolean
> wordTrim,
> String fontLanguage, Int32& charactersFitted, Int32& linesFilled, String&
> streamString)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
> context, OutlineObjects outlines, Boolean wordTrim, String text,
> CanvasFont
> font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
> width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
> Int32 endPage, Boolean render)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> evaluateHeaderFooterExpressions, CreateAndRegisterStream
> createAndRegisterStreamCallback)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> reportContext, ClientRequest session, RenderingResult& result)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effecectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>
> "Donovan Smith [MSFT]" wrote:
>> What error do you see in the log file in your /ReportServer/LogFiles
>> directory? There should be a stack trace in there that you can will give
>> us
>> more information.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
>> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
>> > Hello everybody,
>> > I can't render a report to PDF
>> > and I get the following error :
>> >
>> > "Internet Explorer cannot download Format=PDF from server
>> > Internet Explorer was not able to open this Internet site. The
>> > requested
>> > site is either unavailable or canot be found. Please try again later."
>> >
>> > What it's weird is that other reports rendered to PDF, but this one!
>> >
>> > Thanks for your help.
>> > Domenico
>> >
>> >
>>|||I'm sorry but I had been waiting for your answer for some days. Then I
decided to design again the same report from scratch and this time were not
problem.
Thank you
"Donovan Smith [MSFT]" wrote:
> Please email me a copy of your .rdl and .rdl.data file. I'm curious why
> you're hitting that.
> Thank you.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
> >
> > I thank you for your help.
> > Domenico
> >
> > here below the stack trace of the error :
> >
> > aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting Services
> > error
> > 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. --> System.ArgumentOutOfRangeException: Index and length must
> > refer
> > to a location within the string.
> >
> > Parameter name: length
> >
> > at System.String.Substring(Int32 startIndex, Int32 length)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
> > context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double left,
> > Double top, Double paddingTop, Double width, Double height, Boolean
> > wordTrim,
> > String fontLanguage, Int32& charactersFitted, Int32& linesFilled, String&
> > streamString)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
> > context, OutlineObjects outlines, Boolean wordTrim, String text,
> > CanvasFont
> > font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
> > width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> > theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
> > Int32 endPage, Boolean render)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> > report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> > evaluateHeaderFooterExpressions, CreateAndRegisterStream
> > createAndRegisterStreamCallback)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> > report, NameValueCollection reportServerParameters, NameValueCollection
> > deviceInfo, NameValueCollection clientCapabilities,
> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> > CreateAndRegisterStream createAndRegisterStream)
> >
> > -- End of inner exception stack trace --
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> > report, NameValueCollection reportServerParameters, NameValueCollection
> > deviceInfo, NameValueCollection clientCapabilities,
> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> > CreateAndRegisterStream createAndRegisterStream)
> >
> > at
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> >
> > -- End of inner exception stack trace --
> >
> > at
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> >
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> > reportContext, ClientRequest session, RenderingResult& result)
> >
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effectiveParameters)
> >
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effecectiveParameters, String[]&
> > secondaryStreamNames)
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> > streamFactory)
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> > itemType)
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >
> >
> >
> > "Donovan Smith [MSFT]" wrote:
> >
> >> What error do you see in the log file in your /ReportServer/LogFiles
> >> directory? There should be a stack trace in there that you can will give
> >> us
> >> more information.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> >> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> >> > Hello everybody,
> >> > I can't render a report to PDF
> >> > and I get the following error :
> >> >
> >> > "Internet Explorer cannot download Format=PDF from server
> >> > Internet Explorer was not able to open this Internet site. The
> >> > requested
> >> > site is either unavailable or canot be found. Please try again later."
> >> >
> >> > What it's weird is that other reports rendered to PDF, but this one!
> >> >
> >> > Thanks for your help.
> >> > Domenico
> >> >
> >> >
> >>
> >>
> >>
>
>|||Odd. :) Well, if you encounter it again, please send me those files so I
can take a look.
Thanks.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riddick" <Riddick@.discussions.microsoft.com> wrote in message
news:C15ABB0A-7178-4ACD-BF85-5A47C1FC6EED@.microsoft.com...
> I'm sorry but I had been waiting for your answer for some days. Then I
> decided to design again the same report from scratch and this time were
> not
> problem.
> Thank you
>
> "Donovan Smith [MSFT]" wrote:
>> Please email me a copy of your .rdl and .rdl.data file. I'm curious why
>> you're hitting that.
>> Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
>> news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
>> >
>> > I thank you for your help.
>> > Domenico
>> >
>> > here below the stack trace of the error :
>> >
>> > aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting
>> > Services
>> > error
>> > 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. --> System.ArgumentOutOfRangeException: Index and length must
>> > refer
>> > to a location within the string.
>> >
>> > Parameter name: length
>> >
>> > at System.String.Substring(Int32 startIndex, Int32 length)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
>> > context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double
>> > left,
>> > Double top, Double paddingTop, Double width, Double height, Boolean
>> > wordTrim,
>> > String fontLanguage, Int32& charactersFitted, Int32& linesFilled,
>> > String&
>> > streamString)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
>> > context, OutlineObjects outlines, Boolean wordTrim, String text,
>> > CanvasFont
>> > font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
>> > width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
>> > theComposition, Report theReport, Boolean needTotalPages, Int32
>> > startPage,
>> > Int32 endPage, Boolean render)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
>> > report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
>> > evaluateHeaderFooterExpressions, CreateAndRegisterStream
>> > createAndRegisterStreamCallback)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
>> > report, NameValueCollection reportServerParameters, NameValueCollection
>> > deviceInfo, NameValueCollection clientCapabilities,
>> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
>> > CreateAndRegisterStream createAndRegisterStream)
>> >
>> > -- End of inner exception stack trace --
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
>> > report, NameValueCollection reportServerParameters, NameValueCollection
>> > deviceInfo, NameValueCollection clientCapabilities,
>> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
>> > CreateAndRegisterStream createAndRegisterStream)
>> >
>> > at
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
>> > createChunkCallback, RenderingContext rc, GetResource
>> > getResourceCallback)
>> >
>> > -- End of inner exception stack trace --
>> >
>> > at
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
>> > createChunkCallback, RenderingContext rc, GetResource
>> > getResourceCallback)
>> >
>> > at
>> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
>> > reportContext, ClientRequest session, RenderingResult& result)
>> >
>> > at
>> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
>> > reportContext, ClientRequest session, Warning[]& warnings,
>> > ParameterInfoCollection& effectiveParameters)
>> >
>> > at
>> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
>> > reportContext, ClientRequest session, Warning[]& warnings,
>> > ParameterInfoCollection& effecectiveParameters, String[]&
>> > secondaryStreamNames)
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
>> > streamFactory)
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
>> > itemType)
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>> >
>> >
>> >
>> > "Donovan Smith [MSFT]" wrote:
>> >
>> >> What error do you see in the log file in your /ReportServer/LogFiles
>> >> directory? There should be a stack trace in there that you can will
>> >> give
>> >> us
>> >> more information.
>> >>
>> >> --
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
>> >> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
>> >> > Hello everybody,
>> >> > I can't render a report to PDF
>> >> > and I get the following error :
>> >> >
>> >> > "Internet Explorer cannot download Format=PDF from server
>> >> > Internet Explorer was not able to open this Internet site. The
>> >> > requested
>> >> > site is either unavailable or canot be found. Please try again
>> >> > later."
>> >> >
>> >> > What it's weird is that other reports rendered to PDF, but this one!
>> >> >
>> >> > Thanks for your help.
>> >> > Domenico
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||You bet ! :)
Thanks.
"Donovan Smith [MSFT]" wrote:
> Odd. :) Well, if you encounter it again, please send me those files so I
> can take a look.
> Thanks.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> news:C15ABB0A-7178-4ACD-BF85-5A47C1FC6EED@.microsoft.com...
> >
> > I'm sorry but I had been waiting for your answer for some days. Then I
> > decided to design again the same report from scratch and this time were
> > not
> > problem.
> >
> > Thank you
> >
> >
> > "Donovan Smith [MSFT]" wrote:
> >
> >> Please email me a copy of your .rdl and .rdl.data file. I'm curious why
> >> you're hitting that.
> >>
> >> Thank you.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> >> news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
> >> >
> >> > I thank you for your help.
> >> > Domenico
> >> >
> >> > here below the stack trace of the error :
> >> >
> >> > aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting
> >> > Services
> >> > error
> >> > 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. --> System.ArgumentOutOfRangeException: Index and length must
> >> > refer
> >> > to a location within the string.
> >> >
> >> > Parameter name: length
> >> >
> >> > at System.String.Substring(Int32 startIndex, Int32 length)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
> >> > context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double
> >> > left,
> >> > Double top, Double paddingTop, Double width, Double height, Boolean
> >> > wordTrim,
> >> > String fontLanguage, Int32& charactersFitted, Int32& linesFilled,
> >> > String&
> >> > streamString)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
> >> > context, OutlineObjects outlines, Boolean wordTrim, String text,
> >> > CanvasFont
> >> > font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
> >> > width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> >> > theComposition, Report theReport, Boolean needTotalPages, Int32
> >> > startPage,
> >> > Int32 endPage, Boolean render)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> >> > report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> >> > evaluateHeaderFooterExpressions, CreateAndRegisterStream
> >> > createAndRegisterStreamCallback)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> >> > report, NameValueCollection reportServerParameters, NameValueCollection
> >> > deviceInfo, NameValueCollection clientCapabilities,
> >> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> >> > CreateAndRegisterStream createAndRegisterStream)
> >> >
> >> > -- End of inner exception stack trace --
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> >> > report, NameValueCollection reportServerParameters, NameValueCollection
> >> > deviceInfo, NameValueCollection clientCapabilities,
> >> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> >> > CreateAndRegisterStream createAndRegisterStream)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> >> > createChunkCallback, RenderingContext rc, GetResource
> >> > getResourceCallback)
> >> >
> >> > -- End of inner exception stack trace --
> >> >
> >> > at
> >> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> >> > createChunkCallback, RenderingContext rc, GetResource
> >> > getResourceCallback)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> >> > reportContext, ClientRequest session, RenderingResult& result)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> >> > reportContext, ClientRequest session, Warning[]& warnings,
> >> > ParameterInfoCollection& effectiveParameters)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> >> > reportContext, ClientRequest session, Warning[]& warnings,
> >> > ParameterInfoCollection& effecectiveParameters, String[]&
> >> > secondaryStreamNames)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> >> > streamFactory)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> >> > itemType)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >> >
> >> >
> >> >
> >> > "Donovan Smith [MSFT]" wrote:
> >> >
> >> >> What error do you see in the log file in your /ReportServer/LogFiles
> >> >> directory? There should be a stack trace in there that you can will
> >> >> give
> >> >> us
> >> >> more information.
> >> >>
> >> >> --
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> >> >> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> >> >> > Hello everybody,
> >> >> > I can't render a report to PDF
> >> >> > and I get the following error :
> >> >> >
> >> >> > "Internet Explorer cannot download Format=PDF from server
> >> >> > Internet Explorer was not able to open this Internet site. The
> >> >> > requested
> >> >> > site is either unavailable or canot be found. Please try again
> >> >> > later."
> >> >> >
> >> >> > What it's weird is that other reports rendered to PDF, but this one!
> >> >> >
> >> >> > Thanks for your help.
> >> >> > Domenico
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Problem exporting to excel

Hello,

Im using SSRS and i made a report that has a huge quantity of data, and when i want to export it to excel i got the following error.

Server Error in '/Reports' Application.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors]

[Exception: An error occurred during rendering of the report.]

Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +489

Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +959

Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84

Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143

Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

I can export other reports to excel, but not this one. Can anyone help me here?

Thank you

Does your report have more than 65,536 rows in it?

Jarret

|||

Hi,

No it hasn't, i found out the problem. It was two cells in the matrix that were hidden, once i made them visibile again, it worked.

Thanks for the work anyway

Problem exporting to CSV format

Hi,
When I export my report to csv format and then open the csv file, then I am getting the Data in my report. But in addition to that, I am getting a row that contains comma delimited list of the names of the controls(textboxes) that I have used in my Layout of RDL file for that report. Why does this happen? How do I avoid it?You can try using the NoHeader deviceinfo to suppress the header row http://msdn2.microsoft.com/en-us/library/ms155365.aspx.

Problem exporting to a .pdf

I have a column that contains a field I use for grouping.
The field prints in both the page header and footer, but not the detail section.

Hidden for the column is true.
Hidden for the textbox (field) is false
DataElementOutput for the textbox (field) is Output.
DataElementStyle for the textbox is ElementNormal ( I also tried AttributeNormal but no joy)

Everything works except when I export to acrobat, in which case the field does not print in the page header or footer.

If column is hidden, how will it ever work and print in any format?

What exactly is your problem?

|||

What version of Reporting Services are you using? I would expect the field to be present in PDF on SQL Server 2005 SP2.

Does exporting to TIFF work? Can you please file a bug on http://connect.microsoft.com and include a copy of your RDL?

Thank you.

|||Also noticed that the group field displays when the page is rendered on screen but does not print. Am using sp2. Is this a bug?|||>>What version of Reporting Services are you using?
SS 2005 SP2
>>Does exporting to TIFF work?
Nay

Problem exporting report to other format

Hi,

I have successfully created my first report. however when i tried to export the report to other format like excel, it doesn't work. and give me some funny codes

======================================
MIME-Version: 1.0
X-Document-Type: Workbook
Content-Type: multipart/related;boundary="--=_NextPart_01C35DB7.4B204430"
This is a multi-part message in MIME format.
--=_NextPart_01C35DB7.4B204430
Content-Type: text/html;
Content-Transfer-Encoding: base64
Content-Location:file:///c:/Report.htm
77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb2[TRIMMED]=
--=_NextPart_01C35DB7.4B204430
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Location:file:///c:/Sheet1.htm

77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb2[TRIMMED]==
--=_NextPart_01C35DB7.4B204430
Content-Type: text/css
Content-Transfer-Encoding: base64
Content-Location:file:///c:/stylesheet.css

77u/Lnhscl8zewpwYWRkaW5nLWJvdHRvbTowcHQ7ZGlyZWN0aW9uOkxUUjt0ZXh0LWRlY29yYXRpb246Tm9uZTtmb250LXNpemU6MTBwdDtjb2xvcjp[TRIMMED]
--=_NextPart_01C35DB7.4B204430--
=====================================================

Anything that i need to set?

______________
Post trimmed by moderator SomeNewKid

Hi eeyore21
I run Office 2003 and XP with SRS SP2. So It may differ or not. But what I found was that Office2k3 allows you to right click( which brings up the context menu) and choose export to excel. This is totally diffrent than to select the export format for the Report Server Toolbar. If you want to export a SRS report you must use the SRS Toolbar and not the IE context menu. Context menu does strange things to the SRS formating and the way it gets exported. Sometimes it ( context menu) will work depending on the HTML rendered by SRS it is not to complex|||

Hi l0n3i200n ,
Yup, i used the SRS toolbatr to export to excel, but it doesn't give me the end result.
Another issue that i face is that when i export to pdf, it seems to break the report horizontally to serveral pages, instead of 1 page only.
Is there anywhere i can set this?

|||

I've had the same problem with PDF files, I read in one of the posts that you should set the Report Margins to the required size, however that didn't work for me. In the end I had to resize the controls to fit on a report(SRS Report Designer Page) set with margins the same as a A4 page. This made things better but didn't solve the problem completely.

|||

Thanks l0n3i200n,
I managed to export to excel file after installing service pack 2 for Reporting server.
I guess we have to make our report fit on a A4 page. :(

|||Good Evening Or Good Morning!
I have just "scrapped" the export capibilities to PDF!
PDF never renders anything useful in Thai, Korean, Laos, or Cambodian!
So I just make everyone and at times do it automatically to a TIFF!
The export to a TIFF never "burps"!
This may be of some help or not and -
Best Regards,

Problem exporting from CR9

Hi,
Can anyone help with the fallowing problem please?

I am trying to export a report (CR9) to MS Outlook. I am getting the error 2147190548, Error in File??: Missing or out-of-date export DLL.

I have 2 machines running the same application. It works fine on one system and gives the above error on the other one.

Please help.

-Sharath.In that system, the dll may be corrupted. Try to reinstall the Crystal Report

Problem exporting data using Excel destination (wrong format)

Hi there,

I have designed a package that works perfectly well, exporting data to an excel file from an ole db source. The problem is that in the excel destination file, columns of data that originally were numbers, are formatted as text. It would be just annoying if it weren't because I use those figures in a pivot table that operates with them.

Any idea on how to tell Excel that those columns are numbers?

Thx in advance

What is the original data type in the OLE DB source of those columns? If they are strings you may need tu use the Data Conversion transformation. Does the excel file already exists? if so, what are the format of the columns?

I run a quick test loading 100 rows od AdventureWorks.Sales.SalesOrderDetail table into an Excel file and all the data types mapped fine. The only thing is that I used the Excel Destination in BIDS to create the file and the destination tab using the 'Name of the excel sheet' -->New... button; it generated an statement like:

CREATE TABLE `Excel Destination` (
`SalesOrderID` INTEGER,
`SalesOrderDetailID` INTEGER,
`CarrierTrackingNumber` NVARCHAR(25),
`OrderQty` SMALLINT,
`ProductID` INTEGER,
`SpecialOfferID` INTEGER,
`UnitPrice` MONEY,
`UnitPriceDiscount` MONEY,
`LineTotal` NUMERIC (38,6),
`rowguid` UNIQUEIDENTIFIER,
`ModifiedDate` DATETIME
)

I only had to adjust the Numeric data type precision and I worked just fine.

Rafael Salas

|||

Thx for your answer Rafael.

The numeric data from the ole db data source is in four-byte signed int [DT_I4]. I have a data conversion between the ole db data source and the excel destination and I've tried to both leave the numeric fields unchanged and "convert" them into the same type. Regarding the excel file, I use a template pre-formatted that i copy into a new file through a system file task in the control flow. I've tried several formatting in the columns (general, numeric, etc...) to no avail...

I've also tried in the excel destination to create the worksheets in which I export the data through that "new button" and with a command very similar to the one you posted, with type for the numeric columns as INTEGER. If it worked for you I'm really confused then :/, I was beginning to think it could be a bug in excel.

Thx again

|||

Loslor,

I just looked into the details of mi excel destination file and compared how the data types from BIDS got mapped. I found that all my DT_I4, DT_I2, DT_WSTR and Numeric in BDIS have 'general' when I looked into the format of the cells in the Excel file. I also used the data in the excel file to build a pivot table and worked fine. Are you getting the same behavior?

CREATE TABLE `Excel Destination` (
`SalesOrderID` INTEGER, --> mapped from an DT_I4 in the dataflow; loaded in excel as 'General' (when opening the execel file and look a the format of the cell)
`SalesOrderDetailID` INTEGER,

`CarrierTrackingNumber` NVARCHAR(25), --> mapped from an DT_WSTR in the dataflow; loaded in excel as 'General' (when opening the execel file and look a the format of the cell)
`OrderQty` SMALLINT, --> mapped from an DT_I2 in the dataflow; loaded in excel as 'General' (when opening the execel file and look a the format of the cell)
`ProductID` INTEGER,
`SpecialOfferID` INTEGER,
`UnitPrice` MONEY, --> mapped from an DT_CY in the dataflow; loaded in excel as 'Currency' (when opening the execel file and look a the format of the cell)
`UnitPriceDiscount` MONEY,
`LineTotal` NUMERIC (38,6), --> mapped from a Numeric in the dataflow; loaded in excel as 'General' (when opening the execel file and look a the format of the cell)
`rowguid` UNIQUEIDENTIFIER,--> mapped from an DT_DBTIMESTAMP in the dataflow; loaded in excel as 'Date' (when opening the execel file and look a the format of the cell)
`ModifiedDate` DATETIME
)

Rafael Salas

|||

Hi again,

Yes, my excell is doing the same. After exporting the data, all the cells have the format "General", though they are still treated as text. In fact, the numeric columns display a warning saying that "The number in the cell is formatted as text or preceded by apostrophe" (the last thing obviously being not true) and asks me if i want to reformat the cells, wich sounds a bit like a joke to me. The pivot table is still not getting right the data.

Thx Rafael

|||

Then it seems there is an issue in how excel treats the format 'general' in your side. As I told you I was able to generate the Pivot table regardless of the 'general' formating.

Sorry if I didnt hel you

Rafael Salas

|||

I'm beginning to fight in that front since I don't see any problem in the package.

Thx a lot for your time Rafael

Problem exporting data using Excel destination (wrong format)

Hi there,

Any idea on how to tell Excel that those columns are numbers?

Thx in advance

I only had to adjust the Numeric data type precision and I worked just fine.

Rafael Salas

|||

Thx for your answer Rafael.

Thx again

|||

Loslor,

Rafael Salas

|||

Hi again,

Thx Rafael

|||

Then it seems there is an issue in how excel treats the format 'general' in your side. As I told you I was able to generate the Pivot table regardless of the 'general' formating.

Sorry if I didnt hel you

Rafael Salas

|||

I'm beginning to fight in that front since I don't see any problem in the package.

Thx a lot for your time Rafael

|||

I'm having the same problem using Excel 2003 in SSIS 2005 and wonder if you discovered the solution. I'd appreciate any tips you may have. Thanks.

Dan

Problem Export - Works on dev computer, not on other ones...

I have a problem exporting report with Crystal Report for Visual Studio .NET 2002.
In fact, with the computer I used to program, the export works fine. I've tried to get my .NET project on another computer, and there the export doesn't work...
The error occurs on the line : report.Export(); When I catch it, it says "Echec de connexion", which means "Connection failed".

Here are my config :

- The "good" computer : Win 2000 Server with last SP's, VS.NET 2002, Crystal Report for VS .NET

- The "bad" one : same one...

I also tried on an Xp computer, and it doesn't work either...

I've tried the Modules utility from Business Object to see if DLL's were missing on "bad" computer, but it's quite hard to define ('have to see the DLL under aspnet_wp.exe process, haven't I ?)

I install all services packs and hotfixes for Crystal Report for VS .NET 2002...It doesn't change anything.

So, if you have any idea, it would be welcomed !! Thanks.Check to make sure all the required Export dlls are installed on the "bad" computer.

Each Export format (Excel, pdf, etc) and each Export Destination (Aplication, Disk, etc) has to have a dll installed on the machine it's running on. If, for example, you can export to pdf, but not to Excel, your problem may be that the dll required for Excel Export is missing.

In Crystal Reports 8.5, there's a file called runtime.hlp that tells exactly what dlls are required depending on what your application uses.

(Ex. For CR 8.5 and Win2k, my Excel export dll is: C:\WINNT\Crystal\u2fxls.dll and my dll for Exporting to Application is: C:\WINNT\Crystal\u2dapp.dll)

Friday, March 30, 2012

Problem in generating Excel worksheets

Problem in exporting Report with multiline textbox to Excel

Wednesday, March 28, 2012

Problem in Exporting Crystal Reports

Tuesday, March 20, 2012

problem exporting views

problem exporting views

problem exporting views

Problem Exporting to PDF - TRIED EVERYTHING (almost)

Problem exporting to pdf

Problem exporting to PDF

Problem exporting to excel

Server Error in '/Reports' Application.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Problem exporting to CSV format

Problem exporting to a .pdf

Problem exporting report to other format

Problem exporting from CR9

Problem exporting data using Excel destination (wrong format)

Problem exporting data using Excel destination (wrong format)

Problem Export - Works on dev computer, not on other ones...

connecting to SSAS

Blog Archive

About Me