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


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

SSRS 2005 Report Printing Additional Blank Page

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

Hi,

New to SSRS 2005 and having some problems printing. I have a report that has only 7 columns and while in layout mode, the body of the report only has a width of not even 7 inches. I have made my left margin 0.2 in, RM at 0 in, TM at 0 in and BM at 0 in as well and yet when I print, I get an additional blank page. All my records print in the first page just fine but I get the additional blank page. This also happens to me on a different report when I change the settings for landscape printing. I am able to fit all the columns in one page using landscape but get an additional blank page for every page that is printed. So instead of printing just two pages of records, I get 2 additional blank pages.

Any help will be greatly appreciated.

Thanks.

 




View Complete Post


More Related Resource Links

SSRS Report printing blank first page

  

 

Greetings,

I have a pretty basic SSRS report that has a table header, body (with a table), and table footer.  When I view the report in normal layout,all is well.  However, when I switch to print layout only the table header and table footer are displayed on the first page.  I don't see any of my table data until page two.  So, this is adding an additional page to the beginning of the report and it's make a 17 page report 18 pages.  And because I am including the page numbers on the report, this is noticeable to the users of the report obviously.  Any feedback on things I could do or check to remove this blank page would be greatly appreciated. 

Thanks

jrock630


Report printing problem(ssrs 2005)

  
HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

SSRS Report issue blank page is coming

  
I have a report with 2 pages, some time the second page doesnot contain the data at that time i want to get only 1 page report. but as of now if second page does not have data it is coming as blank, can anyone help on this. I am using ssrs 2008Jeeva Jacob

Blank page while exporting the SSRS report to PDF format

  
While exporting SSRS report to PDF, I am getting blank page in between and at the end also. The report page size is set to 8.75in x 15.00in with 0.02in margin from left, right, bottom and top. I tried in changing the tablix and rectangle box "KeepTogether" property also. In both the case (true/false), I am getting blank pages. Can anyone help me out?

Font/letter spacing issue when printing from SSRS 2008 report page

  

We are developing reports in SSRS 2008.  When printing from the SSRS report page, we are seeing that that some text is "clumping" together or spaced oddly. I have tried a variety of printers so it's not printer-specific. If you export from the SSRS page to PDF or to Word and then print, everything prints as expected.

Nothing is as good as real text/names/data, but to reproduce, simply create several text boxes with...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
abcdefghijklmnopqrstuvwxyz
123456789000,000,000.00

I used several common fonts...
Arial, 10 pt (SSRS 2008 default)
Times New Roman, 12 pt (Office 2003 default)
Calibri, 11 pt (Office 2007 default)
Verdana, 11 pt
Tahoma, 11 pt

In the example above, I used normal weight, nothing fancy... If you use bold and underline, which is common for a page/column header or footer, this issue is even more apparent.

It feels similar to the following issue: https://connect.microsoft.com/SQLServer/feedback/details/482312/ssrs-report-font-rendering-issue

A workaround would obviously be to export to PDF and then print, but these are steps that our end users shouldn't have to (and won't want to) put up with to produce reports/invoices/etc. that ultimately go

SSRS-2005 Repeat Matrix On Each Report Page

  
I am using two matrix controls in my report. Both use different data sets. I want the first matrix to repeat on all the report pages. Can someone help me with this? Thank you in advance.

ssrs 2005 default value generates report

  
Hi, If all parameters have default value the report generates as soon as i load the report. Is it possible to only run the report when clicking on the view report button even if all parameters have default values? Thanks

Passing parameters from ASP.Net web page to SSRS report

  
I have a web page that displays some data.  The user first selects a date range on the web page and then can edit some data.  When they click a submit button, I want to run a report.  But I would like to pass the start date and end date values that the user already entered on the web page to the report.  Is this possible?  Can I use the value of a session variable in the report? Bob

Problems passing parameters to SSRS report from ASP.Net web page

  
I have a web page that displays some data.   When they click a submit button, I want to run a report.  But I would like to pass the start year/month and end year/month values that the user already entered on the web page to the report.  Here is what my url looks like when the report is displayed: http://xyzserver/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fDevicesAllNew&rs:Command=Render&StartYYMM=201007&EndYYMM=201008 But my report displays the 2 textboxes for my StartYYMM and EndYYMM parameters as empty.  What am I doing wrong?  I did a google search and I saw something about using ReportServer instead of ReportManager.  I notice at the top of the browser when I run my report, it reads "Report Manager - Windows Internet Explorer".  Is this correct? Bob     Bob

SSRS Report - Page break after the Header when export to PDF

  

Hi,

I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice. Within each invoice there is a header, body and footer.

My issue is after the header is printed, an automatic page break happens after the header, and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.

I wish any one can solve this issue and grateful if they can give the solution for my problem.

Thanks,

Mahalingam

 


SSRS 2005 Report with 7 subreports

  

I've SSRS 2005 Report with 7 subreports.
Toplevel report runs the query and returns recordset.

RegionID  CustID orderID  OBID     State      City       Name
69            1230    4565      75855    NY         NYC       Sam


Now i need to pass these values in subreports's query as parameter
something like
select * from Region where regionID = @RegionId (in my case it shud get 69 from upper record set.)
Likewise there are 6 more subreports where i need to pass above values as parameter.

Any suggestions would be very helpful.

Thank you,
Pratul.


SSRS blank page iisue while export to pdf

  

Hi,

I have added conditional page break in my ssrs report 2008 , because of blank page issue . After adding Conditional page break the blank page issue is fixed while i am preview the report. But if I export that to PDF alternate pages are coming as blank. I have checked the report width and body width and it is satisfying the condition, Please help to avoid this blank page issue while export to PDF


Jeeva Jacob

Exporting one particular page from SSRS report

  

Hi,

I have developed a report using 2 sub-reports. The report data spans across many pages.
User wants to export one of the sub-report in TIFF format.

Is this possible? Can I export one particular page using export option? Here I don't know the exact page number as well because sub-report may get displayed on any page 2,3.4 etc.

Regards,
Neeraj

 


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.


SSRS Report Page break when export to PDF

  

Hi,

I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer.

My issue is for certain cases the line items in the body of the invoice, only the last line item moves to the next page. Cretaing a large gap in the body of the report. This happens only for some invoices. I am using Land scape type report, having Page size as 11 * 8.5 inches.

I wish any one can solve this issue and grateful if they can give the solution for my problem.

I can also send the RDL file, sample data as well as the PDF output for review.

Thanks,

Mahalingam


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.

 

Thanks!


running value are not printing in page footer in Sql server reporting Services 2005

  

Hi everybody..

i've created one SSRS in that i've connected to the database having four fields..

now want i want is to calculate the salary page by page and at the last grand

total..

i've kept one extra column in table and kept one running field and made it as 

hidden. i've taken one textbox and placed in page footer with the 

expression="PAGE RECORD TOTAL="& Last(reportitems("Subtotal1").Value)

where subtotal1 is a running field and i'm taking the last value of that.. and printing in

page footer..

Now my problem is when i run the report the value will be present but when

i click on preview or  take the print the value will be disappeared..

please help me.. 


And when i make the running field hidden=false then it will display while printing also..

i dont want to show the running field i want to hide it..

i've created the report with the following link

http://community.dynamics.com/blogs/navteam/archive/2010/03/17/transfooter-and-transheader-functionality-in-rdlc-40-ssrs-41-reports.aspx

please help me


Categories: 
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