.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Export PDF in ssrs 2008 vs ssrs 2005 - pdf is different, won't work with itextsharp (possibly other

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server
We're migrating from SSRS 2005 to SSRS 2008. We use itextsharp (a pdf processing library) to merge different PDF outputs into one large PDF file. This was working brilliantly in SSRS 2005, but in SSRS 2008, itextsharp *can* open and parse the PDF, but itext sees the "content" section of the PDF pages as blank. So, the resulting composite PDF ends up being a series of blank pages. Acrobat 9 and a couple other PDF tools (tested linux Evince and win GIMP) seem to be able to open the SSRS 2008-generated PDF fine, but the java-version of itext, and the .net version of itext (itextsharp) see nothing but blanks.
So, I realize this points to a problem with itext, but I'm curious if anyone else is merging PDFS outputed from SSRS 2008, and what PDF tools/libraries they are using.

Much thanks!

View Complete Post

More Related Resource Links

Getting SSRS 2005 to work on Server 2008 R2


I reinstalled SQL Server 2005 x64 Standard Edition SP3 on a Server 2008 R2 box and installed IIS and SSRS as well.  SQL runs fine. SSRS is installed all configs look good, but I cannot get it accessible via the browser (//localhost/ReportServeror //localhost/Reports). 

I have tried both 32 & 64 defaults in IIS AppPools and each gives me an error and I can't find any other resources as to what the problem is?

32-bit setting is giving me this error on /ReportServer:

Could not load file or assembly 'ReportingServicesNativeClient, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.

64-bit setting is giving me this error on /ReportServer:

HTTP Error 500.0 - Internal Server Error, Error Code 0x800700c1

32 & 64-bit setting are both giving me this error on /Reports:

HTTP Error 401.2 - Unauthorized, Error Code0x80070005

Shared dataset in SSRS 2008 R2 running on SSAS 2005

I am trying to create a report in SSRS 2008 R2 using SSAS 2005 as a datasource. My dataset has a date parameter. When I create an embedded dataset in my report everything works fine, but when I create a shared dataset with the exact same mdx query, I get the following error: An error occurred during local report processing. The definition of the report 'xxxx' is invalid. The Value expression for the report parameter 'DateCalendarHierarchy' contains an error: [BC30034] Bracketed identifier is missing closing ']'. Does anybody have any ideas? Is this a bug? Thanks, Louis

SSRS 2008 Export to PDF fails for large data with System.Exception: Parameter is not valid

Hi, We are working on Range Bar Chart using SSRS 2008. The report has huge data. It is properly displaying the data, but when we tried to export to pdf it is failing with the following exception. Exporting to excel works fine. Also if the report has small/medium data it is property exporting to PDF. It is failing only in case of huge data (we have custom page size of 28" X 14"). Of course the report has lot of expressions we used to customize the colors/text as per our requirements.   Server Error in '/Reports_SQLDEV2008' Application. Parameter is not valid. 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: Parameter is not valid. 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: Parameter is not valid.]   [Exception: An error occurred during rendering of the report.]   [Exception: An error occurred during rendering of the report.]    Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream ou

SSRS 2008 Matrix - Cannot get average formula or growth formula to work

I have a report in Excel that I'm trying to replicate in SSRS 2008.  The report looks like this:   Priority 08/21/10 08/14/10 08/07/10 07/31/10 07/24/10 07/17/10 07/10/10 TOTAL Average Customer Name Code # of Lds # of Lds # of Lds # of Lds # of Lds # of Lds # of Lds  # of Lds   Check  #N/A            4            4            4            8            4            9           -            33          5       83%  A2             1          -            -            -            -            -           

SSRS 2008 R2 Reporting Samples, why don't they work?

Hi I have Win7 64bit ... SQL Server 2008 R2. From codeplex I’ve downloaded the latest Adventure Works sample dbs … http://msftdbprodsamples.codeplex.com/releases/view/45907 Then I wanted to see the latest Reporting Samples … http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008R2!AdventureWorks2008R2%20Report%20Samples&referringTitle=Home But here is the problem, these reports don’t work with the latest AdventureWorks dbs ... cause … the database AdventureWorks2008R2 does not exist in the dbs samples and all the datasets in the reports go in one way or the other to this particular database and some specific fields in it!! I have a simple installation on my laptop ... default default default ... everything else works great. Dbs I created, reports I create and so on … but I would like to get some inspiration and hints about more advanced reports from the codeplex sample reports of course. So … has anyone fixed this? Kind Regards jea

How do you freeze the tablix header row in an Excel export file in SSRS 2008?

So this is totally killing me. I've found out how to make a tablix header row repeat on each page of a PDF export file in SSRS 2008 (which I won't even get started on because all I can say is that 2005 is way better), but I cannot figure out how to make a simple header row of a tablix freeze in an Excel export file.  The tablix is right at the top of the body and spans the entire width of the design area.  How in the world do you get it to freeze in the Excel export file?

Barchart migiration problem when I move it from SSRS 2005 to SSRS 2008

Hi I am having a barchart report in ssrs 2005 which  is going to dynamically generate the bars depending on the input parameters for example if we give 15 as input it is going  to generate 15 bar on the chart and if we give 25 as input it is going to generate 25 bars on the report.Report is working well in ssrs 2005 but when I migrate it from ssrs 2005 to ssrs 2008 and run the report it is working well when i select 15 as input it is showing me 15 bar with the names on x-axis and y-axis.But when I select 25 as input it is generating bar chart  and I see multiples of 5 like(5,10,15,20)  bars are getting the names displayed on the y-axis and rest of the names are not displayed on chart.I was trying to expand the bar chart  and trying to see the different.When I expand report is spliting into two pages and I see multiples of 5 like(5,10,15,20) bars are getting the names displayed and rest of the names are not displayed.So can anyone suggest me any solution.   Thanks in Advance

SSRS in place upgrade from 2005 to 2008 issue


I did an inplace upgrade of SSRS 2005 to 2008 and now the reports are throwing the following error. The reports were all working fine and there is a datasource with the name 'Data Source Name' without the '_'.  Please help.

  • An error has occurred during report processing. (rsProcessingAborted)
    • The data source 'Data_Source_Name' cannot be found. (rsDataSourceNotFound)

SSRS 2005: Export to Excel, Tiff, and web archive all fail


SSRS Export to Excel is popular in our office but has been failing a lot recently- at the beginning of the year there were a few occurances a month until June, then they steadily increased until now it is nearly every time (44% of the events happened this month.)  Few software changes (just MS and virus def updates) No configuration changes until troubleshooting this issue began.  Policy changes on both server and clients is possible as that is controled by contractors and we are not notified of changes.

Upon exploring I discovered export to tiff and web archive also fail, but csv, PDF, and xml seems to work most of the time.   Some of the reports failing have not had any design changes in months.  Reports are not particularly large- 2 to 4 tables with under 200 rows each.  No more than 6 pages and then mostly because of page breaks between tables.  no more than 5 levels of drill down- most have fewer than that.  The failure happens very fast- about 4 seconds.  If the data is filtered down to very small sets so that the export process can complete inside those 4 seconds then it succeeds.

I have seem many questions on lots of forums with similar issues with SSRS but no solutions that worked for me.  All the timeout values I know of (about 6?) are set to between 120 and 3600 seconds.  None of my reports sh

SSRS 2005/2008 - Chart with bar graph not generating on subsequent executions of report even with mo


For a report executed from Report Manager that has a bar chart component, regenerating the report via refresh or view with same input parameters either gives a different result that is garbled or an empty chart (2008) or no chart at all (2005). I have the report set up to not do any caching, so that does not seem to be the issue. Is there some chart option I may need to set to get the proper chart display.

Report conversion from SSRS 2005 to SSRS 2008


I am converting reports developed in SSRS 2005 into SSRS 2008. In the report design interface I have several rows and columans of data that calculate count or rate. In addition to rows and columns, I have around ten hidden tablixes in which report expression calls hidden codes inside tablix to perform calculation with main report. My problem is when I set hidden tablix propert into hide, I am not getting correct calculation in my report.  when I change tablix property from hidden to show I will get correct calculation but I do not want to see those hidden tablixes in my report page. Is there any way  you can still call expressions inside hidden tablixes without turning on tablix property show in SSRS 2008? Is it a bug in SSRS 2008 reporting system? Please help me out!!

My operating system is windows vista.



ssrs 2008 export to word 2010



I am having an issue with the header on an rdl file (ssrs 2008) when I export to word 2010.  The header gets cut off at the top of the page (about .5 inch).  But when I export to a PDF file it is fine.  If all our users exported only to pdf this would not be an issue, but unfortunately our users use both word and pdf to print out the reports.



When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1

When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1,Sheet 2,Sheet 3) dynamically.So Please try to give me a solution.

When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1



When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1,Sheet 2,Sheet 3) dyanamically.Sp Please try to give me a solution.

SSRS 2005 to 2008 upgrade: exporting to .PDF does not produce the same result


We have recently converted .rdl SSRS 2005 files to SSRS 2008 .rdl files. We do not have SSRS 2008 R2, we are working with the  first release. We are seeing issues when exporing a report to .pdf format:

1) when rendered in HTML, the function that displays page numbers (ie:page 1 of 2) for the report are correct. The standard function "Globals!TotalPages" is used to get the count of pages. We previewed a report in html in reports manager that had 1777 pages. when the report is exported to .pdf the last page displays page 1777 of 1816, even though there is no more pages beyond 1777.

2)When rendering the report in html a value is shown as "Caretaker1" but when exporting to adobe .pdf version 9.3, the same value is shown as "Caretaker2".

3)   One of our issues is

SSRS 2008 export to Excel margin problem

When rendering report from SSRS 2008 with custom margins (let's say 0.5in) into Excel, margins do not export correctly, or do not export at all, thus Excel sets its default margins.

I heard in SSRS 2005 it was not a problem.

Any ideas?

In SSRS 2008, after export to Excel report loses nested visibility groups


I have a report  created in SSRS 2005 which is running on our new SSRS 2008 box.  It has 3 nested levels of visibility so the recipient can click the twist tie to view different levels of detail.  Each Zone has many Districts and each District has many Stores.  The report renders displaying the summary of the Zones.  If you click on the twist tie on the Zone it opens up a list of Districts.  If you click on the twist tie on a district, it opens up a list of stores.  If you click on the twist tie on one of the stores, you get the actual details of all repair orders submitted for that store.

The report renders fine in report manager.  The report has a subscription set up to run monthly that exports the results to Excel and emails them to our client.  The problem is when the report exports to Excel the twist tie exists on the Zone, but it missing on each of the Districts and Stores.  The client is not happy about this.  This report contains large amounts of data and is very combersome without the visibility grouping working properly in Excel.

I tried converting the report to SSRS 2008, but that did not solve my problem. 

Is there anyway to fix the export process to Excel? 


P.S. I tried to upload the code, but it caused my question to be too many characters

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

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend