Post New Web Links

Reporting Services 2005 now rendering PDFs differently!

Posted By: Posted Date: October 19, 2010 Points: 0 Category :Sql Server

We have a server running SQL 2005 and Reporting services. We have a Report we use to generate purchase orders and email the resulting PDFs to our vendors. All fields in this Report use Times New Roman, either 10 or 12, point, some bold, some not. This report has not changed in months.

Since Monday our vendors are reporting they are unable to copy and paste text out of some of the sections of the report. They get question marks, or boxes, not the text. This only happens on some of the fields in the report.

Neither the report nor the database has changed. SQL Server was upgraded over the weekend to 9.0.3282, the CU9 update. There may have also been some security patches applied, not sure which.

PDFs generated after the upgrades now have an additional font listed in the File | Properties dialog of Adobe Reader 9. It's a TrueType font.

Does anyone have any ideas or knowledge about how the PDF rendering component of MS Reporting Services may have changed? Any help would be welcome.

Barry Seymour

View Complete Post

More Related Resource Links

Error while Rendering Reports(Reporting Services 2005) in .Net 1.1 web Application on IIS 6.0

I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or something missing.

I have wasted so much time in a finding a solution and I appreciate any help in that.

Reporting Services SQL 2005 .Net 4 compatibility?

I've been working on my first asp.net application and for the most part it's been pretty smooth. Right now I'm having trouble getting reporting services working under SQL Server 2005. I developed the site with Visual Studio 2010 and didn't think about any of the .Net 4.0 compatibility issues that have arisen. I'm having no problems with the site communicating with SQL Server 2005 for the regular database stuff. The only problem I'm having is with setting up Reporting Services. I have the .Net 4.0 framework installed on the server, however Reporting Services is still using 2.x. I'm not sure if this is a problem with SSRS or with IIS. When i go to localhost/Reports it's reading my web.config for my application and throwing an error: "Parser Error Message: Unrecognized attribute 'targetFramework'." This is referring to a line in my web.config where targetFramework is set to 4.0.

Software that I'm using:

Visual Studio 2010
SQL Server 2005 Standard
IIS 7.0
.Net 4.0

Any suggestions?

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services

Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Data Points: Designing Reports with SQL Server Reporting Services 2005

Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both WindowsÃÂ® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint

Hi,

I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!

Thanks,
-Raj

SQL Server 2005: Install reporting services - which version?

Hello - I installed SQL Server 2005 as part of an SBS2008 install. I need to install reporting services, but now I'm having trouble identifying which version (X64 or X86) I'm running. Is there an easy way of figuring out which installation disk I need to insert for SQL Server 2005? Thanks, Nick.

Kerberos issue with SQL Reporting Services 2005 on Server 2003 R2

Hi Guys,apologies if this is the incorrect forum, so moderators, feel free to move it to SQL/IIS/SharePoint as appropriate... [Windows Server Security moderator pushed me this direction]I have a test environment that I'm trying to get SQL Reporting Services 2005 SP3 working in integrated mode with SharePoint 2007 SP2.The environment is all in VMWare, running Server 2003 R2 x86 and is layed out like this:SERVER A:AD/DNS/DHCPSERVER B:SQL 2005 SP3 CU8SERVER C:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82SERVER D:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82Through the use of DNS and (SharePoint) Alternate Access Names, SERVER D is used to deliver the Main Content in SharePoint and the Reporting Service website. SERVER C is used to deliver the Central Admin, SSP and MySite.I've set up SPN's for the SharePoint App Pools, using the following: [main content] setspn -S HTTP/SERVERA DOMAIN\AppPoolUserA setspn -S HTTP/SERVERA.FQDN DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB.FQDN DOMAIN\AppPoolUserA [repor

Generating Multiple Excel Sheet using Reporting Services 2005.

<p> Hi, I'm currently developing a program using ASP.NET 2.0 (C#) and i am using Reporting Services 2005. One of the report requirements is to export a data to an excel with multiple excel sheet. Is there other way to generate multiple excel sheet using the reporting services? if yes, i would like to ask a sample code... Thanks in advance, JP </p>

SharePoint integration with SQL Server 2005 Reporting Services

Hello Everyone, ÃÂ I have been banging my head against the wall with trying to integrate SharePoint 2007 and SQL Reporting Services.ÃÂ If anyone could offer any assistance, I would appreciate it greatly. I have been following these 2 websites down to the letter in trying to configure everything: ÃÂ ÃÂ 1. http://msdn2.microsoft.com/en-us/library/bb326356.aspxÃÂ ÃÂ ÃÂ ÃÂ <---Microsoft's Steps ÃÂ 2. http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with- wss-3-0-and-moss-2007.aspxÃÂ ÃÂ <---SharePoint Blog Group ÃÂ ÃÂ Basically my setup is as follows: ÃÂ Server 1 = SharePoint 2007 Server 2 = SQL Server Reporting Services SP2ÃÂ / SharePoint 2007 services Server 3 = Database ÃÂ Server1 is setupÃÂ and running SharePoint 2007 fine with no problems. It was installed under the complete option with its own server farm. Then with the Server2,ÃÂ SharePoint 2007 is installedÃÂ again, also under the complete complete option,ÃÂ and configured toÃÂ join Server1'sÃÂ server farm. In this way, Server2 is able to supply Server1 with services and it has been said that if you are usingÃÂ 2 different servers, one for SharePoint and one for Reporting Services, you need to have an instance of SharePoint on the reporting services box. With a SharePoint "front-end" the reporting-services now has a way to also join Server1s farm. ÃÂ This is where the headache be

How to configure Sharepoint 2007 Reporting Services 2005 with NLB sharing same RS database

Hello, I'm trying to configure RS using two FE and a single SQL database in sharepoint integrated mode. At first i was getting an error about version of reporting server wouldnt support scale-out configuration, so i upgraded RS Instances in both FE's to 2005 Ent Ed. and re-installed sharepointRS_Addin in both FE servers and successfully initialized both with the reporting services configuration tool. after successfully granted database access to both FE's using CAS. if i browse to http://WFE1:port/ReportServer/ or http://WFE2:port/ReportServer/ the database content is listed in browser. if i browse to: http://NLB-sitename:port/ReportServer the database content gets listed also, tho it seams to list random conten

Run Reporting services 2005 with databases housed on SQL Server 2008?

Hi, I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

Run Reporting services 2005 with databases housed on SQL Server 2008?

Hi, I posted this in the RS forum as well but was thinking it would be better here. I'm not sure if I can move a post to a different forum or not so sorry for the double post. I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

re: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

To have access to the webpart "report viewer for sql server reporting services" you can of course install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies. My question though is, does your SharePoint 2007 server have to be running in integrated mode so as to be able to install and use the report viewer web part? Thanks.

SQL Reporting Services 2005: Must declare scalar variable

I have a report that calls a stored procedure that builds a temp table and then runs a select that joins on that temp table. The only parameter I have is @Name, an optional parameter that can be filled or NULL. ÃÂ I keep getting the error "An error has occurred during local report processing. An error has occurred during report processing. Query execution failed for data set. Must declare the scalar variable "@Name". ÃÂ I have checked to make sure this parameter is connected to the dataset by looking at the parameter tab. I've searched on posts but haven't seen an answer. Does anyone have any idea what this could be about and how to fix it?

HELP!!! HIDE ONE TEXTBOX IN TABLE HEADER WHEN IT IS NOT IN FIRST PAGE IN REPORTING SERVICES 2005

help me plis. this thing drive me crazy. it really should be a simple solution but i cant find it, even with googling. i have subreport that display deposit transaction banking statement from account (customer). this subreport will be accessed through main report that loop all accounts in one branch, so its like a batch report processing for all customer in a branch. rendered to pdf and distributed to all our branchs. since i know that subreports header footer wont work on main report, i decide to move the subreport header into subreport table header and make it looks like it was a report header. but THERE is one problem i cant solve, there is ADDRESS BOX that should only VISIBLE on FIRST page for each customer, along with the other header that always visible. how im i supposed to do? please help. been searching n trying for 3 days and cant find any workin solution. been wondering do i really that dumm @_@ . thanks. ps: sory for my bad english.

Is it possible to make Reporting Services use a different chart rendering engine instead of the buil

Is it possible to make Reporting Services use a different chart rendering engine instead of the built-in one? E.g. to generate a datafile (e.g. CSV) and then use e.g. http://www.highcharts.com/demo to display the chart, rather than the built-in chart in reporting services?


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All