Error Printing using Adobe

Hi,
In rs2005 I am trying to print the report to a pdf file - export is not
an option as I cannot embed the fonts. When I click on the print
setting I get the following Adobe error.
Unable to find "Adobe PDF" resource files.
"C:\doc and settings\al users\documents\adobe
pdf\settings\nt\SC_Black-and-White.joboptions"
Do you want to run the installer in repair mode?
Anyone else experience this?
Every other application can print fine even rs2000
thanksanyone?
seanlacey@.gmail.com wrote:
> Hi,
> In rs2005 I am trying to print the report to a pdf file - export is not
> an option as I cannot embed the fonts. When I click on the print
> setting I get the following Adobe error.
> Unable to find "Adobe PDF" resource files.
> "C:\doc and settings\al users\documents\adobe
> pdf\settings\nt\SC_Black-and-White.joboptions"
> Do you want to run the installer in repair mode?
>
> Anyone else experience this?
> Every other application can print fine even rs2000
> thanks

Error on Reporting Server - but only through the ReportViewer control

We are using the webviewer control.

We get the following error when we try to export to EXCEL.

InternetExploer cannot download ...n=OnlyHtmlInline&Format=EXCEL from app.webcobra.com.

Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.

This error comes up almost immediatly after it starts trying to download the file. It is a large dataset but it isn't "overly large". There are basically 44 records.

The other wierd thing is that it works fine on our BETA servers but not on our Production servers. We figure this is a setting somewhere that we have missed.

And now I found out that if it just leave it sitting there it eventually asks me if I want to open the file and it opened fine.

So what was the above error all about?

Does anyone have any ideas that I can look into?

Thanks!

Doesn't sound like a reporting service config problem. Maybe you should check your pro box or firewall's settings, including authentication, etc.|||

It doesn't happen with smaller amounts of records. If I have 4 or 5 records it doesn't give the message.

|||There is no firewall between the production box and the application servers.|||

Here is the fix...it problem was SSL

"Internet Explorer file downloads over SSL do not work with the cache control headers"

http://support.microsoft.com/kb/323308/en-us

|||

Well, that didn't fix it. It was promising but it didn't work.

First, the registry update is on a client computer. We don't have access to everyone's client computer. We need a fix for our servers.

And we updated one of our computers with the registry fix and we still got the message. Any other ideas?

|||

Hi:

We had the same issue. Does your fixed?

Error on Reporting Server - but only through the ReportViewer control

We are using the webviewer control.

We get the following error when we try to export to EXCEL.

InternetExploer cannot download ...n=OnlyHtmlInline&Format=EXCEL from app.webcobra.com.

Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.

This error comes up almost immediatly after it starts trying to download the file. It is a large dataset but it isn't "overly large". There are basically 44 records.

The other wierd thing is that it works fine on our BETA servers but not on our Production servers. We figure this is a setting somewhere that we have missed.

And now I found out that if it just leave it sitting there it eventually asks me if I want to open the file and it opened fine.

So what was the above error all about?

Does anyone have any ideas that I can look into?

Thanks!

Doesn't sound like a reporting service config problem. Maybe you should check your pro box or firewall's settings, including authentication, etc.|||

It doesn't happen with smaller amounts of records. If I have 4 or 5 records it doesn't give the message.

|||There is no firewall between the production box and the application servers.|||

Here is the fix...it problem was SSL

"Internet Explorer file downloads over SSL do not work with the cache control headers"

http://support.microsoft.com/kb/323308/en-us

|||

Well, that didn't fix it. It was promising but it didn't work.

First, the registry update is on a client computer. We don't have access to everyone's client computer. We need a fix for our servers.

And we updated one of our computers with the registry fix and we still got the message. Any other ideas?

|||

Hi:

We had the same issue. Does your fixed?

Error on Export to Excel with Bookmarks and Navigation Jumps

Hello All,

We're running RS 2005. I have a problem in a report using two

main sections. There's a top level report, made up from 4 tables

within a rectangle. The second section of the report contains the

detail of the calculations making the top level figures.

The second section of the report contains bookmarks and jump links to

drill to different levels of the reporting structure. This works

fine.

The top level of the report also has jump to bookmark links to drop

into the relevant section of section two, and display the detail.

The problem I'm having is that although the jump links work fine within

report manager, the report will not export to excel from report

manager. It errors with the error at the bottom of this post.

Removing the bookmark links from the top level of the report solves the

export issue (but obviously without the functionality I require).

The strangest thing is that the export works fine from the development

environment in VS .NET 2005, although the bookmarks do not work and

claim an "invalid link" (or something similar).

Any ideas, anybody?

Thanks in advance.
Jon
Error message below:
w3wp!reportrendering!1!06/22/2006-16:51:19:: e ERROR: Throwing

Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:

An error occurred during rendering of the report., ;

Info:

Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:

An error occurred during rendering of the report. >

Microsoft.ReportingServices.ReportRendering.ReportRenderingException:

An error occurred during rendering of the report. >

System.ArgumentException: Item has already been added. Key in

dictionary: ' 2' Key being added: ' 2'

at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)

at System.Collections.Hashtable.Add(Object key, Object value)

at

Microsoft.ReportingServices.Rendering.BIFFUtility.WorkBook.AddBookmarkLink(String

name, String uniqueName, Boolean keepName)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderTextBox(TextBox

textBox, PageReportItemInfo reportItemInfo, PageCell pageCell,

PageTableGrid pageTableGrid, ReportItem dataRegionParent,

Hashtable& duplicateItemsTable, Hashtable riReferenceTable, Int32

row, Int32 col, Boolean addHeaderRows)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout

pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable,

Boolean addHeaderRows, ReportItem parentItem, Hashtable

riReferenceTable)

at

Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer

excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32

minCol, Int32 maxCol)

at

Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer

excelRenderer, Stream stream, Int32 offset)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout

pageLayout, Int32& currentPageNumber, Stack& stack)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection

pageCollection, Int32& currentPageNumber, Stack& stack,

PageLayout& lastPageLayout)

at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()

at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream

createAndRegisterStream)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream

createAndRegisterStream)

at

Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report

report, NameValueCollection reportServerParameters, NameValueCollection

deviceInfo, NameValueCollection clientCapabilities,

EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,

CreateAndRegisterStream createAndRegisterStream)A little more on this issue.

I've two extra tables to the top level of the report to represent other

views on the same data. I've found that the top level figure -

which is a single table, with only a detail row, and only a single row

of data feeding into it - works fine, whilst another new table (with

again, a single table, only a detail row, but a different dataset with

the same fields) does not work.

Confused |||Again... some more on this issue!

A colleague of mine has a similar problem. Making a couple of

assumptions, the common issue seems to be when you have bookmark/jump

IDs that are generated from the dataset. If you have two

different jump points that jump to the SAME bookmark, there appears to

be an issue.

As mentioned previously, I can export through the development environment but the bookmark links show up as being invalid.

I'm sure this is a feature supported by Excel. Is this possibly a bug with the excel renderer?

Cheers,
Jon|||

It definately seems like a bug, although I haven't been able to duplicate it yet. I don't have an idea for a workaround at this time.

The fact that you can run it successfully from Visual Studio is puzzling. Do you have different versions of Reporting Services installed on your server vs. where you are developing?

- Geoff

|||Hi Geoff,

Thanks for looking at this post too.

I do run both RS 2000 and 2005, but they're hosted on seperate servers,

and I develop using the appropriate version of VS .NET (2k3 for RS 2k,

and 2k5 for RS 2k5). In this case it's VS 2k5 with RS 2k5.

It will export from VS, but the bookmark links on the Excel version do

not work and come up with a "Reference Not Valid" error when

clicked. It simply won't export from the report manager and

errors (as above). Would you like me to mail you spreadsheet with

the export from the development environment? With the error

message posted above, you can see what happens from both VS and report

manager.

Regards,
Jon|||

Hi Jon,

This looks like a bug to me. The best way to continue here is to submit it via Microsoft Connect, at https://connect.microsoft.com/SQLServer. This will get the issue into our bug pipeline so that it can be properly addressed and tracked for a fix.

Thanks, Geoff

|||OK Geoff, thanks for your help.

I've now logged this bug, so we'll see if something comes back from

it. Unfortunately, connect isn't particularly compatible with

Firefox so I ended up submitting it 4 times!

Shall I submit this bug too

Thanks again,
Jon

Error on Export to Excel with Bookmarks and Navigation Jumps

Hello All,
We're running RS 2005. I have a problem in a report using two main sections. There's a top level report, made up from 4 tables within a rectangle. The second section of the report contains the detail of the calculations making the top level figures.
The second section of the report contains bookmarks and jump links to drill to different levels of the reporting structure. This works fine.
The top level of the report also has jump to bookmark links to drop into the relevant section of section two, and display the detail.
The problem I'm having is that although the jump links work fine within report manager, the report will not export to excel from report manager. It errors with the error at the bottom of this post.
Removing the bookmark links from the top level of the report solves the export issue (but obviously without the functionality I require). The strangest thing is that the export works fine from the development environment in VS .NET 2005, although the bookmarks do not work and claim an "invalid link" (or something similar).
Any ideas, anybody?
Thanks in advance.

Jon

Error message below:

w3wp!reportrendering!1!06/22/2006-16:51:19:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ;
Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. > Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. > System.ArgumentException: Item has already been added. Key in dictionary: ' 2' Key being added: ' 2'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.Rendering.BIFFUtility.WorkBook.AddBookmarkLink(String name, String uniqueName, Boolean keepName)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderTextBox(TextBox textBox, PageReportItemInfo reportItemInfo, PageCell pageCell, PageTableGrid pageTableGrid, ReportItem dataRegionParent, Hashtable& duplicateItemsTable, Hashtable riReferenceTable, Int32 row, Int32 col, Boolean addHeaderRows)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean addHeaderRows, ReportItem parentItem, Hashtable riReferenceTable)
at Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol, Int32 maxCol)
at Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout& lastPageLayout)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)

A little more on this issue.
I've two extra tables to the top level of the report to represent other views on the same data. I've found that the top level figure - which is a single table, with only a detail row, and only a single row of data feeding into it - works fine, whilst another new table (with again, a single table, only a detail row, but a different dataset with the same fields) does not work.
Confused
|||Again... some more on this issue!
A colleague of mine has a similar problem. Making a couple of assumptions, the common issue seems to be when you have bookmark/jump IDs that are generated from the dataset. If you have two different jump points that jump to the SAME bookmark, there appears to be an issue.
As mentioned previously, I can export through the development environment but the bookmark links show up as being invalid.
I'm sure this is a feature supported by Excel. Is this possibly a bug with the excel renderer?
Cheers,

Jon
|||

It definately seems like a bug, although I haven't been able to duplicate it yet. I don't have an idea for a workaround at this time.

The fact that you can run it successfully from Visual Studio is puzzling. Do you have different versions of Reporting Services installed on your server vs. where you are developing?

- Geoff

|||Hi Geoff,
Thanks for looking at this post too.
I do run both RS 2000 and 2005, but they're hosted on seperate servers, and I develop using the appropriate version of VS .NET (2k3 for RS 2k, and 2k5 for RS 2k5). In this case it's VS 2k5 with RS 2k5.
It will export from VS, but the bookmark links on the Excel version do not work and come up with a "Reference Not Valid" error when clicked. It simply won't export from the report manager and errors (as above). Would you like me to mail you spreadsheet with the export from the development environment? With the error message posted above, you can see what happens from both VS and report manager.
Regards,

Jon
|||

Hi Jon,

This looks like a bug to me. The best way to continue here is to submit it via Microsoft Connect, at https://connect.microsoft.com/SQLServer. This will get the issue into our bug pipeline so that it can be properly addressed and tracked for a fix.

Thanks, Geoff

|||OK Geoff, thanks for your help.
I've now logged this bug, so we'll see if something comes back from it. Unfortunately, connect isn't particularly compatible with Firefox so I ended up submitting it 4 times!
Shall I submit this bug too
Thanks again,

Jon
sql

Error on Export to Excel

We are getting this error when we try to export to excel in one report. Has anyone had this problem and what can I do to fix it?

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) +924

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) +153

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.210Found the answer on server. We were returning too many rows in excel.

Error occurred during rendering of the report. Stack Empty.

I have developed a report in SSRS 2005. When I try to export the output to Excel, it shows an error saying:

Error occurred during local report processing.

Error occurred during rendering of the report. Stack Empty.

Do anyone have any idea what this means and how to fix it?

I can render the report in other formats (Adobe, csv etc) without any problem. My other reports, under same project and using same dataset, are working fine.

Thanks in Advance.

Have you checked your log files for errors?

C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles

You may need to crank up the level of tracing to get anything interesting:

http://technet.microsoft.com/en-us/library/ms156500.aspx

Does the report render in Excel for a different dataset? Try faking a dataset using something like:

SELECT 1 AS Age, 'M' AS Sex

UNION

SELECT 7 AS Age, 'F' AS Sex

and see if you render correctly. Make sure you have 'alligned your edges' to reduce the complexity of the resulting Excel. If you want to (are willing/able to) send me your RDL, I will take a look and post the results of my analysis back here.