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

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

Pause between pages when printing RS report

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server
I am using Report Services on SQL Server 2005. I have a report that gets its data from a single SQL Server stored procedure. One other small table is used, but only to provide a list of values for selecting a parameter value to send to the stored procedure.

On the report I use a list control to display multiple records per page.

When printing the report (which currently produces over 500 pages - future printings of this report will not be nearly so large), the printer pauses between each page as if they are seperate print jobs. This is an HP LaserJet 5Si that normally cranks out reports very fast.

The only thing I can think of that might contribute to this sort of behavior is the fact that I set my margin sizes to 0in to get as much design room on the report as possible. Could that cause this sort of behavior?

View Complete Post

More Related Resource Links

Printing crystal report from webservice



I am trying to print crystal repot directly from a C# application, which is calling webservice. I am able to display report in crystalreportviewer by passing the webservice call to datasource. However, is there anyway, I can print directly without showing the report?

Alternatively, I was trying return ReportDocument object from webservice, which would solve my problem, but I was unable to return the ReportDocument because of serialization issue. Is it even possible? Thank you


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

Printing Landscape Report using the Print Control of the ASP.NET Report Viewer

I am using the ASP.NET Report Viewer 2010 web control in remote processing mode connected to a SQL Server Reporting Services 2008 R2 report server in Native Mode. I am viewing the report in IE8 and the print control within the report viewer is available. According to "Printing Reports from a Browser Using the Print Control" at http://msdn.microsoft.com/en-us/library/ms159237.aspx  "The Print dialog box and the default printer settings for width, height, and page orientation are determined by the report definition." In SQL Server Business Intelligence Development Studio I am using the “Report Properties” window accessed from the “Report” menu to set the Orientation to “Landscape”, the paper size to “Letter”, the Width to “11in”, and the Height to “8.5in” in the report definition. When viewing the report using the ASP.NET Report Viewer 2010 in IE8 and exportint to PDF, the report renders correctly in landscape orientation and the size both on screen and printed is as defined in the report definition. However, if I print it directly from the ASP.NET Report Viewer using the Print Control the print preview shows the report correctly in landscape orientation and page size, but the resulting printout is in portrait orientation and skewed or cropped.  If I go into the properti

Im trying to print the content of a listbox1 but the printing is false so all the pages coming out f

 ManagementObjectSearcher mosPrinter = new ManagementObjectSearcher("SELECT * FROM Win32_Printer");                 foreach (ManagementObject moDiskete in mosPrinter.Get())                 {                     foreach (PropertyData p in moDiskete.Properties)                     {                           // listBox1.Items.Add(p.Value);                         listBox1.Items.Add(String.Format("{0}: {1}", p.Name, p.Value == null ? "NULL" :myprint.DocumentName=p.Value.ToString()));                      //   myprint.DocumentName = p.Value.ToString();                     

Printing of Web Page is smaller with .NET pages



I have been converting classic ASP web pages to the .NET platform and have found that the pages print out MUCH smaller with the .NET version.  Can this be a print property?  IIS setting?  As you can see I'm grasping here so could use a bit of educating about this as well.  This "shrinking" seems to happen in browsers other than IE as well (Chrome and Firefox).

ANY help or directions to helpful articles would be greatly appreciated!



Jeff Tolman

EandM Electric

SSRS Report printing blank first page




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. 



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...

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

problem when printing a report



I am having an error when I try to print a report.

When I click on the printer icon to print my report, it says:

"unable to load client printer control"

Any help??

My application is running on a shared hosting server.

SSRS 2005 Report Printing Additional Blank Page



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.



Blank Pages in between report


I created a report with multiy pages and in between every page of data is a blank page. If the Report is Sixteen pages long i get eight blank pages. The Body size of the report is 8.5in, 25.475in. The Report porperities or 8.5 x 11in. Each page has a table with a page break at start set to true. But I still get blank pages in between the report.

Group report splitting into multiple pages Need it in 1 page


1) Few of my group reports which have more than 500 rows are splitting into many pages without column header. (eg, page 1, page 2... etc.) I would like configure it to be in one page however large it may be.

2) I tried setting column header in group reports which are splitting into multiple pages but its not working.

Either I need achieve point 1 or point 2

Could you please help me how to achieve it?


Blank pages in SSRS Report PDF Export


I am developing a report with almost 25 columns table and the width of the report is 20pt. But I am changing the visibility of a few columns in run-time so that the resultant width will fit in one page (11pt)(I checked all the margins and resultant width of table. Sum of all the widths are with in the pagesize only). Everything is working fine when i check the report in browser, but when i try to Export to PDF there are alternate white pages, which are corresponding to the hidden columns width i guess.

How to achieve PDF Export without white pages? Also, is there any way to shrink the report to a single page?

I am using SSRS 2005

printing 20'' X 6'' report in a regular inkjet printer


Dear Friends

how do I print  20''  X 6'' report in a regular inkjet  printer.

I know I  need to feed the 6'' side to the printer but what should be the printer settings ?

should I design each of the text field in "writingMode=tb-rl"..... when i do this I am facing problems with alignment of adjacent fields...they seem to get displayed in different parts of the report

also i have about 50 textboxes and 2 tables  in the report.

Kindly help

html report printing problem


i have a 6 page long html report which i want to print, printing behaviour is different between IE and FF, i want to print ony certain number of lines per page, how do i acomplist this task without crystall report or any other propritery tool,

Note: Data of the report is dynamic.

below is the html of my report

        <table cellpadding=0 cellspacing=0 border=0 width=800px>
<img src="images/Header_FS.jpg" width="800px" />

<table cellpadding="0" cellspacing="0" border="0" width="620px">

<td align="center" style="height:40px" valign="middle">
<td align="center">

Printing and Print Preview hangs on a large report


Using SQL Server 2008 R2 Cumlative Update #4 (build 10.50.1746)

A report that is 119 pages long hangs after page 113 in both the print preview and printing.

A different report that is 90 pages long hangs on page 60 in both the print preview and printing.

These reports worked fine before applying the cumulative update #4.

Looking for best setup to accomplish this task, need to generate report view for printing(edited)


We have some pages that are in gridviews and datalists.. one requirement for 2 of them is the ability to generate the results in a report view of sorts.. in other words, if you do a search and the results come back in one of the 2 gridviews or datalist, on screen its presented as it currently does.. just a gridview or datalist.. but i need to add a button that gives you the option to convert / generate the data in a report view so you can print it out and not be just a print out of the gridview..

I already offer the ability to export to excel format, but what they are wanting is to create it so if it needs to be presented to someone, they can print it out with the click of a button and it looks like a nice report.

Hope that makes sense... any suggestions would be great..

Just thinking to myself, could it be possible or would this be an option and if it can, how can it be incorporated to work correctly..

Build a template page that has a formal report layout.. then if you chose to print, then each record in the gridview loops thru the template and each record would print out on its own page..

Does that sound like it can be done? or am i just wishing it could be that simple??


// Added to above //

What i guess would be comparable to what im looking for is

Printing on 'Odd' or 'Even' pages

Is there a way to print a report only on even (or odd) pages?
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